JDBC连接各种数据库的字符串

最新推荐文章于 2022-09-21 14:31:05 发布

你好好呀！

最新推荐文章于 2022-09-21 14:31:05 发布

阅读量522

点赞数 1

文章标签： jdbc 数据库 mysql sqlserver oracle

oracle driverClass：oracle.jdbc.driver.OracleDriver 
url：jdbc: oracle: thin: @127.0.0.1 : 1521 : orcl

数据库的用户名和密码写在Connection connection = DriverManager.getConnection(url, "scott", "tiger");
方法里面mysql driverClass：com.mysql.jdbc.Driver url：jdbc: mysql: //localhost:3306/数据库名称

数据库的用户名和密码写在Connection connection = DriverManager.getConnection(url, "数据库的名称", "密码");

方法里面Sql Server2005 driverClass：com.microsoft.sqlserver.jdbc.SQLServerDriver url：jdbc: sqlserver: //localhost:1433; DatabaseName=数据库名称
数据库的用户名和密码写在Connection connection = DriverManager.getConnection(url, "数据库名称", "密码");方法里面

public static void main(String[] args) {
	Connection conn = null;
	Statement st = null;
	ResultSet rs = null;
	try {
		Class.forName("oracle.jdbc.driver.OracleDriver");
		//mysql  com.mysql.jdbc.Driver
		//sqlserver  com.microsoft.sqlserver.jdbc.SQLServerDriver
		String url = "jdbc:oracle:thin:@localhost:1521:orcl";
		String url1 = "jdbc:mysql://localhost:3306/dbname";
		String url2 = "jdbc:sqlserver://localhost:3306/dbname";
		conn = DriverManager.getConnection(url, "scott", "tiger");
		st = conn.createStatement();
		rs = st.executeQuery("select * from emp");
		while (rs.next()) {
			System.out.println(rs.getString(5));
		}
	} catch(Exception e) {
		e.printStackTrace();
	} finally {
		try {
			conn.close();
			st.close();
			rs.close();
		} catch(Exception e2) {
			e2.printStackTrace();
		}
	}
}