1.将mysql-connector-java-5.1.45-bin.jar文件放在demo/WEB-INF/lib目录下
2.加载驱动
Class.forName("com.mysql.jdbc.Driver");
3.创建数据库连接
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/script","root","root");
4.创建语句容器
Statement st=conn.createStatement();
5.执行sql语句
ResultSet rs=st.executeQuery("select * from admin_info where name='"+t+"' and pwd='"+b+"'");
6.遍历结果集
while(rs.next()){
System.out.print(rs.getString("id"));
System.out.print(rs.getString("name"));
System.out.print(rs.getString("pwd "));
}