// 1.注册驱动 Class.forName("com.mysql.jdbc.Driver"); // 2.获取连接 Connection con = DriverManager.getConnection( "jdbc:mysql://localhost:3306/test", "root", "123");// 创建数据连接 String sql = "select * from tbl_user_info"; // 3.创建Statement对象 Statement statement = con.createStatement(); // 4.执行查询sql 返回结果对象 ResultSet rs = statement.executeQuery(sql); while(rs.next()){ String result = rs.getString("userName"); System.out.println(result); } //关闭资源 rs.close(); statement.close(); con.close();
JDBC最简单的用法