常用JDBC写法

常用的JDBC的写法

Mysql

	String URL_DRIVER_MYSQL = "com.mysql.cj.jdbc.Driver";
	@Deprecated
	String URL_DRIVER_MYSQL_OLD = "com.mysql.jdbc.Driver";
	String JDBC_URL = "jdbc:mysql://" + ServerName + ":" + String.valueOf(ServerPort) + "/" + databaseName
				+ "?serverTimezone=UTC" + // 修正时区问题，GMT（格林威治时间）也可写为UTC（世界统一时间）。
				"&useServerPrepStmts=true" + // 开启预编译
				"&cachePrepStmts=true" + // 开启缓存编译后函数key
				"&rewriteBatchedStatements=true" + // 开启批处理
				"&allowPublicKeyRetrieval=true" + // 允许检索公钥
				"&useSSL=false" + // 使用SSL证书,是一种安全协议
				"&useUnicode=true" + // 使用Unicode编码
				"&characterEncoding=utf8";//编码格式utf-8

Oracle

	String URL_DRIVER_ORACLE = "oracle.jdbc.driver.OracleDriver";
	String JDBC_URL = "jdbc:oracle:thin:@" + serverName + ":" + String.valueOf(serverPort) + ":" + SID;

SqlServer

	String URL_DRIVER_SQLSERVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	String JDBC_URL = "jdbc:sqlserver://" + serverName + ":" + String.valueOf(serverPort) + ";DatabaseName="
				+ databaseName + ";";

SqlLite

	String URL_DRIVER_SQLLITE = "org.sqlite.JDBC";
	String JDBC_URL = "jdbc:sqlite:" + dataBasePath;

连接方法

	Connection connection = null;
	Statement statement = null;
	Class.forName(URL_DRIVER_SQLLITE);
	connection = DriverManager.getConnection(JDBC_URL, USER_NAME, USER_PSD);
	statement = connection.createStatement(); // 创建语句对象