java连接数据库(JDBC):
实体类:创建与数据库对应的成员变量(封装)
Dao类:
1.导包(下载包)
eg:Class.forName("com.mysql.cj.jdbc.Driver");
2.加载驱动 //(driverManger)
eg:DriverManager.getConnection("jdbc:mysql://192.168.3.92:3306/school","root","123456");
3.准备连接串,账号,密码//(connection)
eg:Connection connection=DriverManager.getConnection()
4.执行sql语句 //preparedStatement
eg:String sql="select * from t_student";
PreparedStatement ps=connection.prepareStatement(sql);
5.查询//executeQuery 非查询//execute
返回值resultSet 返回值boolean
eg:ResultSet rs=ps.executeQuery();
6.迭代
while(re.next()){
Student student=new Student();
student.setStuNo(rs.getString("stu_no"));
student.setName(rs.getString("name"));
student.setGender(rs.getInt("gender"));
students.add(student);
}
若re.next()有值(数据)返回true并迭代遍历,没有返回false退出循环。