页面增删改查

目标需求：

1.利用MySQL建4张表 分别为 学生表 教员表 班级表 爱好表

2.要求带条件的模糊查询（两个下拉框以及一个复选框）和分页

3.新增功能

4.修改界面，值回显的问题（显示已选中的爱好）

5.删除功能

爱好表（1代表篮球 2代表足球 3代表唱歌 4代表跳舞）

一、底层代码1（实体类以及dao方法）

package com.zsx.entity;

/**

实体类：班级类

@author zsx

@date 2022年6月18日上午8:51:59 */

import java.io.Serializable; public class Class implements Serializable{ //防止序列化与反序列化 private static final long serialVersionUID = 1L; private int cid;//班级编号 private String cname;//班级姓名

public int getCid() {
    return cid;
}
public void setCid(int cid) {
    this.cid = cid;
}
public String getCname() {
    return cname;
}
public void setCname(String cname) {
    this.cname = cname;
}
​
public Class() {
    // TODO Auto-generated constructor stub
}
public Class(int cid, String cname) {
    this.cid = cid;
    this.cname = cname;
}
​
public Class(String cname) {
    this.cname = cname;
}
@Override
public String toString() {
    return "Class [cid=" + cid + ", cname=" + cname + "]";
}
}

package com.cdl.entity;

import java.io.Serializable; import java.util.List;

package com.zsx.entity;

import java.io.Serializable; import java.util.List;

public class Student implements Serializable{ //防止序列化与反序列化 private static final long serialVersionUID = 1L; private int sid;//学生编号 private String sname;//学生姓名 private Class c;//班级 private Hobby h;//爱好 private Teacher tea;//老师 private String ss; private List<Hobby> ls;

public String getSs() {
    return ss;
}
public void setSs(String ss) {
    this.ss = ss;
}
public List<Hobby> getLs() {
    return ls;
}
public void setLs(List<Hobby> ls) {
    this.ls = ls;
}
public int getSid() {
    return sid;
}
public void setSid(int sid) {
    this.sid = sid;
}
public String getSname() {
    return sname;
}
public void setSname(String sname) {
    this.sname = sname;
}
public Class getC() {
    return c;
}
public void setC(Class c) {
    this.c = c;
}
public Hobby getH() {
    return h;
}
public void setH(Hobby h) {
    this.h = h;
}
public Teacher getTea() {
    return tea;
}
public void setTea(Teacher tea) {
    this.tea = tea;
}
​
public Student() {
    // TODO Auto-generated constructor stub
}
public Student(int sid, String sname, Class c, Hobby h, Teacher tea, String ss, List<Hobby> ls) {
    this.sid = sid;
    this.sname = sname;
    this.c = c;
    this.h = h;
    this.tea = tea;
    this.ss = ss;
    this.ls = ls;
}
public Student(int sid, String sname, Class c,Teacher tea, String ss) {
    this.sid = sid;
    this.sname = sname;
    this.c = c;
    this.tea = tea;
    this.ss = ss;
}
@Override
public String toString() {
    return "Student [sid=" + sid + ", sname=" + sname + ", c=" + c + ", h=" + h + ", tea=" + tea + ", ss=" + ss
            + ", ls=" + ls + "]";
}
}

package com.zsx.entity;

/**

实体类：教师类

@author zsx

@date 2022年6月18日上午8:50:19 */ import java.io.Serializable;

public class Teacher implements Serializable{ //防止序列化与反序列化 private static final long serialVersionUID = 1L; private int tid;//教员编号 private String tname;//教员姓名 private Class c;//所教班级 public int getTid() { return tid; } public void setTid(int tid) { this.tid = tid; } public String getTname() { return tname; } public void setTname(String tname) { this.tname = tname; } public Class getC() { return c; } public void setC(Class c) { this.c = c; }

public Teacher() {
    // TODO Auto-generated constructor stub
}
public Teacher(int tid, String tname, Class c) {
    this.tid = tid;
    this.tname = tname;
    this.c = c;
}
​
public Teacher( String tname, Class c) {
    this.tname = tname;
    this.c = c;
}
@Override
public String toString() {
    return "Teacher [tid=" + tid + ", tname=" + tname + ", c=" + c + "]";
}
}

package com.zsx.entity;

/**

实体类：爱好类

@author zsx

@date 2022年6月18日上午8:53:52 */ import java.io.Serializable; public class Hobby implements Serializable{ //防止序列化与反序列化 private static final long serialVersionUID = 1L; private String hid;//爱好编号 private String hname;//爱好名称

public String getHid() { return hid; } public void setHid(String hid) { this.hid = hid; } public String getHname() { return hname; } public void setHname(String hname) { this.hname = hname; }

public Hobby() { // TODO Auto-generated constructor stub } public Hobby(String hid, String hname) { this.hid = hid; this.hname = hname; }

public Hobby( String hname) { this.hname = hname; } @Override public String toString() { return "Habby [hid=" + hid + ", hname=" + hname + "]"; }



}

package com.zsx.dao;

import java.util.List;

import com.zsx.entity.Student; /**

数据库访问层设计类
public interface IStuDao {

/**

查询单个

@param sid 学生编号

@return 学生对象 */ public Student getStu(int sid) ;

/**

查询所有

@return 查询的结果集合 */ public List<Student> getAll();

/**

模糊查询

@param colName 要查询的列名

@param str 关键字

@return 对象 */ public List<Student> getMH(String ctr,String htr, String str,int pageIndex,int pageSize);

/**

增加学生

@param stu 学生对象

@return 影响行数 */ public int addStu(Student stu);

/**

删除学生

@param sid 学生编号

@return 影响行数 */ public int delStu(int sid);

/**

修改学生

@param stu 要修改的对象

@param sid 学生编号

@return 影响行数 */ public int upStu(Student stu,int sid);

/**

总行数

@return 行数 */ public int getRows(String str);



}

package com.zsx.dao;

import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List;

import com.zsx.entity.Hobby; import com.zsx.entity.Student; import com.zsx.util.DBHelper; /**

数据库访问层

 public class StuDao implements IStuDao{

//三兄弟 Connection con = null; PreparedStatement ps =null; ResultSet rs = null;

public Student getStu(int sid) { Student stu = new Student(); try { //获得连接 con = DBHelper.getConnection(); //定义sql语句 String sql = "select * from tb_stu where sid=?"; //获得执行对象 ps=con.prepareStatement(sql); //给占位符赋值 ps.setInt(1, sid); //给rs赋值 rs=ps.executeQuery(); //判断 if(rs.next()) { stu.setSid(rs.getInt(1)); stu.setSname(rs.getString(2)); stu.setC(new ClDao().getll(rs.getInt(3))); //stu.setH(new HobbyDao().getHob(rs.getInt(4))); stu.setSs(rs.getString(4)); stu.setTea(new TeaDao().getTea(rs.getInt(5))); } } catch (Exception e) { // TODO: handle exception e.printStackTrace(); }finally { DBHelper.close(con, ps, rs); } return stu; }

@Override public List<Student> getAll() { List<Student> ls = new ArrayList<Student>(); try { //获得连接 con = DBHelper.getConnection(); //定义sql语句 String sql = "select * from tb_stu"; //获得执行对象 ps=con.prepareStatement(sql); //给集合赋值 rs=ps.executeQuery(); //遍历 while(rs.next()) { List<Hobby> list = new ArrayList<>(); //实例化一个对象 Student stu = new Student(); stu.setSid(rs.getInt(1)); stu.setSname(rs.getString(2)); stu.setC(new ClDao().getll(rs.getInt(3))); //stu.setH(new HobbyDao().getHob(rs.getInt(4))); //分割 String hob = rs.getString(4); //System.out.println(rs.getString(4)); //用逗号分割 String [] ss = hob.split(","); for (String so : ss) { IHb