JDBC 简单编程步骤

		// 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最简单的用法