基于JavaSwing的学籍管理系统＜JavaWeb简历展示＞

数据库部分

表

主要表结构

 

管理员表信息

 

 学生表部分信息

 学生表触发器<限制性别，人数自动变化>

Java部分

程序表

 主要核心部分代码位于Dao.impl包中

*这里只展示StudentDaoImpl实现类的代码*

public class StudentDaoImpl implements StudentDao{
	/**
	 * 根据关键字查找，默认是显示全部学生信息
	 */
	@Override
	public List<Vector> SelectAllStudent(Student stu_search, int search_loop) {
		List<Vector> list = new ArrayList<Vector>();
		Connection conn = null;
	    PreparedStatement ps = null;
	    ResultSet rs = null;
		try {
			conn = JDBCUtilsPro.GetConnection();
			StringBuilder sql = new StringBuilder("select s_id, s_name,s_sex,s_age,class.class_id,dept.dept_name,department.dpt_name,s_address,s_beizhu from student,class,"
					+ "dept,department where class.class_id = student.class_id and dept.dept_id = student.dept_id and department.dpt_id = student.dpt_id");//未拼接前的sql语句,默认查找所有学生信息
			if(search_loop == 0) {
				//下拉框选择学号
				if(!StringUtils.isEmpty(stu_search.getS_id())) {
					sql.append(" and s_id like '%" + stu_search.getS_id() + "%' ");
			    }
			}
			else if(search_loop == 1) {
				if(!StringUtils.isEmpty(stu_search.getS_name())) {
					//查找搜索的关键字和姓名类似的信息,append()字符串连接，StringBuilder的方法
					sql.append(" and s_name like '%" + stu_search.getS_name() + "%' ");
			    }
			}
			else if(search_loop == 2) {
				if(!StringUtils.isEmpty(stu_search.getS_sex())) {
					sql.append(" and s_sex like '%" + stu_search.getS_sex() + "%' ");
			    }
			}
			else if(search_loop == 3) {
				String str = Integer.toString(stu_search.getS_age());
				if(!StringUtils.isEmpty(str)) {
					sql.append(" and s_age = " + stu_search.getS_age() );
			    }
			}
			else if(search_loop == 4) {
				if(!StringUtils.isEmpty(stu_search.getS_class())) {
					sql.append(" and class.class_name like '%" + stu_search.getS_class() + "%' ");
			    }
			}
			else if(search_loop == 5) {
				if(!StringUtils.isEmpty(stu_search.getS_dept())) {
					sql.append(" and dept.dept_name like '%" + stu_search.getS_dept() + "%' ");
			    }
			}
			else if(search_loop == 6) {
				if(!StringUtils.isEmpty(stu_search.getS_dpt_name())) {
					sql.append(" and department.dpt_name like '%" + stu_search.getS_dpt_name() + "%' ");