jdbc连接

最新推荐文章于 2024-07-18 11:33:28 发布

哼唧

最新推荐文章于 2024-07-18 11:33:28 发布

阅读量155

点赞数

分类专栏： JDBC

本文链接：https://blog.csdn.net/u011256670/article/details/71248671

版权

JDBC 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

public void testStatement(){
		
		/*  MYSQL 连接时的*/
		//数据库用户名
		String users = "root";
			//数据库密码
			 String password = "11";
			//数据库驱动
			 String classNames = "com.mysql.jdbc.Driver";
			//数据库jdbc url
		 String urls = "jdbc:mysql://localhost:3306/shop";
		 
		 /* oracle连接时  */ 
		 String url = "jdbc:oracl:thin:@127.0.0.1:1521:orcl";
		 String user = "scott";
		 String pwd = "tiger";
         String className = "oracle.jdbc.driver.OracleDriver";
		
		try {
			Class.forName(className);
			Connection conn = DriverManager.getConnection(url, user, pwd);
			Statement st = conn.createStatement();
			String sql = " select *  from emp ";
			ResultSet rs = st.executeQuery(sql);
			while(rs.next()){
				
			Integer  empno = rs.getInt(1);
			String ename = rs.getString("ename");
			System.out.println(empno+":"+ename);	
		
			}
			
			rs.close();
			st.close();
			
			conn.close();
			
			
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
}