Java代码连接各种数据库demo

若相惜、不离不弃

已于 2023-09-21 10:57:10 修改

阅读量214

点赞数

分类专栏： db2 文章标签： java 数据库 mysql oracle

于 2022-06-16 11:51:54 首次发布

本文链接：https://blog.csdn.net/weixin_44124385/article/details/125313286

版权

db2 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

仅供参考

1.MySQL

mysql.JDBC.Driver=com.mysql.jdbc.Driver
mysql.JDBC.Username=
mysql.JDBC.Password=
mysql.JDBC.ConnectionURL=jdbc:mysql://ip:端口/库名?serverTimezone=GMT%2B8&characterEncoding=utf8
或者
?autoReconnect=true&nullCatalogMeansCurrent=true&useUnicode=true&characterEncoding=utf8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC&useSSL=false&tcpRcvBuf=1024000

2.Oracle

Acms.JDBC.Driver=oracle.jdbc.driver.OracleDriver
Acms.JDBC.Username=AGREE_DATA
Acms.JDBC.Password=
Acms.JDBC.ConnectionURL=jdbc:oracle:thin:@//ip:port/orcl

3.DB2

Acms.JDBC.Driver=com.ibm.db2.jcc.DB2Driver
Acms.JDBC.Username=db2inst1
Acms.JDBC.Password=db2inst1-pwd
Acms.JDBC.ConnectionURL=jdbc:db2://ip:port/ycyhdb:currentSchema=SPYHABX

4.mysql完整举例


		String driver="com.mysql.jdbc.Driver";
		String username="***";
		String password="***";
		String url="jdbc:mysql://ip:端口/库名?serverTimezone=GMT%2B8&characterEncoding=utf8";
		
		Class.forName(driver);
		Connection connection = DriverManager.getConnection(url,username,password);
		String sql="select * from test ";
		/**
		 * 	预编译的SQL
		 * connection.prepareStatement(sql);
		 */
		Statement statement = connection.createStatement();
		boolean execute = statement.execute(sql);
		ResultSet rs = statement.getResultSet();
		while (rs.next()) {
			System.out.println(rs.getString(2));
		}