JDBC访问数据库过程

1.加载JDBC驱动程序

Class.forName("com.mysql.jdbc.Driver");

2.创建数据库的连接

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库名?serverTimezone=UTC","数据库用户名","数据库密码");

3.执行SQL语句

String sql = "select * from admin_info where name='"+name+"' and pwd='"+psw+"'";
PreparedStatement st = conn.prepareStatement(sql);

4.获得查询结果

ResultSet rs = st.executeQuery();

5.遍历结果集

while(rs.next()){
System.out.print(rs.getString("name"));
	System.out.print(rs.getString("pwd"));
}

6.关闭数据库连接

rs.close();
st.close();
conn.close();