1.导入jar包
buildpath
2.获取驱动,创建连接
Class.forName("com.mysql.jdbc.Driver");//驱动信息
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/date?useUnicode=true&characterEncoding=utf8&serverTimezone=CST","root","1234");//数据库信息
String sql="select *from Table_1";//sql语句
PreparedStatement ps=conn.prepareStatement(sql);//执行sql语句
ResultSet rs=ps.executeQuery();//返回结果集
while(rs.next()){
user=new User();
user.setName(rs.getString(3));
user.setAcc(rs.getString(1));
user.setPwd(rs.getString(2));
session.setAttribute("user", user);
....//读取结果集中的信息
}
rs.close();
conn.close();//关闭连接