JAVA 学生管理系统-版本1（servlet3.0+bootstrap3.3.7+jsp）

package com.stu.service; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Timestamp; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.List; import org.junit.Test; import com.stu.entity.Student; import com.stu.utils.DataBaseUtil; /** * 基本信息业务逻辑，包括增删改查等基本操作 * @author LEahis * @date 2018年5月16日上午9:38:39 */ public class StuInfoService extends DataBaseUtil{ private SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); private Connection conn = getConn(); @Test public void test(){ System.out.println(sdf.format(new Timestamp(new Date().getTime()))); } /** * 增加学生基本信息 * @param stu 学生实体类 * @return 操作是否成功 */ public boolean addStu(Student stu){ try{ String sql_string = "insert into s_info(s_id,s_name,s_major,s_court,s_dep,create_date,s_home_address,s_grade,head_teacher) " + "values("+stu.getsId() +",'"+stu.getsName() +"','"+stu.getsMajor() +"','"+stu.getsCourt() +"','"+stu.getsDep() +"','"+sdf.format(new Timestamp(new Date().getTime())) +"','"+stu.getsHomeAddress() +"','"+stu.getsGrade() +"','"+stu.getHeadTeacher()+"');"; System.out.println("录入时用到的sql语句:"+sql_string); //构造sql语句,由于字段较多，这里信息插入语句做sql拼接 PreparedStatement statement = conn.prepareStatement(sql_string); System.out.println(statement); //执行sql statement.execute(); return true; }catch(SQLException e){ e.printStackTrace(); return false; } } /** * 修改学生基本信息 * @param stu 学生实体类 * @return 操作是否成功 */ public boolean updateStu(Student stu,String oldSId){ try{ String sql_string = "update s_info set s_id="+stu.getsId() + ",s_name='"+stu.getsName() + "',s_major='"+stu.getsMajor() + "',s_court='"+stu.getsCourt() + "',s_dep='"+stu.getsDep() + "',update_date='"+sdf.format(new Timestamp(new Date().getTime())) + "',s_home_address='"+stu.getsHomeAddress() + "',s_grade='"+stu.getsGrade() + "',head_teacher='"+stu.getHeadTeacher() + "' where s_id="+oldSId+";"; System.out.println("修改用到的sql语句:"+sql_string); //根据学号查找。构造sql语句,由于字段较多，这里信息插入语句不做sql拼接及空判断 PreparedStatement statement = conn.prepareStatement(sql_string); //执行sql statement.execute(); return true; }catch(SQLException e){ e.printStackTrace(); return false; } } /** * 删除学生基本信息，做逻辑删除 * @param stu 学生实体类 * @return 操作是否成功 */ public boolean delStu(String sId){ try{ //根据学号查找。构造sql语句,由于字段较多，这里信息插入语句不做sql拼接及空判断 PreparedStatement statement = conn.prepareStatement("update s_info set s_del = 1 where s_id="+sId); //执行sql statement.execute(); return true; }catch(SQLException e){ e.printStackTrace(); return false; } } /** * 查询学生基本信息 * @param sId 学号 * @param sName 学生姓名 * @return 操作是否成功 */ public List<Student> queryStu(String sId,String sName){ try{ //根据学号查找。构造sql语句,由于字段较多，这里信息插入语句不做sql拼接及空判断 StringBuilder sb = new StringBuilder(); sb.append("select s_id,s_name,s_major,s_dep,create_date,s_home_address,s_grade,head_teacher,s_court from s_info where IFNULL(s_del,'')!=1"); if(sId!=null && !sId.isEmpty()&& !sId.equals(" ")){ sb.append(" and s_id="+sId); } if(sName!=null && !sName.isEmpty()&& !sName.equals(" ")){ sb.append(" and s_name like '%"+sName+"%'"); } PreparedStatement statement = conn.prepareStatement(sb.toString()); //执行sql ResultSet result = statement.executeQuery(); List<Student> list = new ArrayList<Student>(); while(result.next()){ Student stu = new Student(); stu.setsId(result.getString("s_id")); stu.setsName(result.getString("s_name")); stu.setsMajor(result.getString("s_major")); stu.setsCourt(result.getString("s_court")); stu.setsDep(result.getString("s_dep")); stu.setsHomeAddress(result.getString("s_home_address")); stu.setsGrade(result.getString("s_grade")); stu.setHeadTeacher(result.getString("head_teacher")); list.add(stu); } return list; }catch(SQLException e){ e.printStackTrace(); return null; } } //按学号查找学生信息 public Student findBysId(String sId){ try{ //根据学号查找。构造sql语句 PreparedStatement statement = null; if(sId!=null && !sId.isEmpty() && !sId.equals(" ")){ statement = conn.prepareStatement("select s_id,s_name,s_major,s_dep,create_date,s_home_address,s_grade,head_teacher,s_court from s_info where s_id="+sId); //执行sql ResultSet result = statement.executeQuery(); Student stu = null; while(result.next()){ stu = new Student(); stu.setsId(result.getString("s_id")); stu.setsName(result.getString("s_name")); stu.setsMajor(result.getString("s_major")); stu.setsCourt(result.getString("s_court")); stu.setsDep(result.getString("s_dep")); stu.setsHomeAddress(result.getString("s_home_address")); stu.setsGrade(result.getString("s_grade")); stu.setHeadTeacher(result.getString("head_teacher")); } return stu; }else{ //学号为空 return null; } }catch(SQLException e){ e.printStackTrace(); return null; } } }