文章目录
一、拿数据
导包
servlet-api.jar
mysql-connector-java-5.1.7-bin.jar
jstl-1.2.jar
jsp-api.jar
layui.css
1 创建实体类
Course.java
public class Course {
private Integer id;
private String courseName;
private String courseLevel;
private Date createDate;
private int courseGood;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getCourseName() {
return courseName;
}
public void setCourseName(String courseName) {
this.courseName = courseName;
}
public String getCourseLevel() {
return courseLevel;
}
public void setCourseLevel(String courseLevel) {
this.courseLevel = courseLevel;
}
public Date getCreateDate() {
return createDate;
}
public void setCreateDate(Date createDate) {
this.createDate = createDate;
}
public int getCourseGood() {
return courseGood;
}
public void setCourseGood(int courseGood) {
this.courseGood = courseGood;
}
}
2 数据库帮助类
public class DBUtil {
public static Connection getConnection() {
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql:///icode?characterEncoding=utf-8", "root", "root");
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
}
2.1 类加载驱动(Class.forName(“com.mysql.jdbc.Driver”);)
- Class.forName:返回与给定的bai字符串名称相关联类或接口的Class对象。
- Class.forName(String name, boolean initialize, ClassLoader loader)
- name表示的是类的全名;
- initialize表示是否初始化类;
- loader表示加载时使用的类加载器
- Class.forName(String className)。
- initialize的值为 true,loader的值为当前类的类加载器。
- Class.forName(String name, boolean initialize, ClassLoader loader)
2.2 DriverManager.getConnection()
- DriverManager.getConnection() 方法用于获得试图建立到指定数据库 URL 的连接。DriverManager 试图从已注册的 JDBC 驱动程序集中选择一个适当的驱动程序。
3 持久层代码
CourseDao.java
public interface CourseDao {
public List<Course> findAllCourse();
}
CourseDaoImpl.java
public class CourseDaoImpl implements CourseDao {
@Override
public List<Course> findAllCourse() {
List<Course> clist = new ArrayList<Course>();
ResultSet rs = null;
Connection con = DBUtil.getConnection();
String sql = "select * from t_course";
try {
PreparedStatement prst = con.prepareStatement(sql);
rs = prst.executeQuery();
while(rs.next