📄 studentdao.java
字号:
/**
*
*/
package edu.yinhe.mis.model;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import edu.yinhe.mis.dto.StudentDTO;
import edu.yinhe.mis.vo.StudentVO;
import edu.yinhe.system.model.BaseDAO;
/**
* @author 吴朋
*
*/
public class StudentDAO extends BaseDAO {
/**
* 根据ID号删除学生信息
*
* 注：本方法虽然是删除方法但为了保存学生的信息，
* 就只修改了学生的状态，使其在页面消失但信
* 息还存在数据库；
* @author 吴朋
* @exception SQLException
* creation date :04-30-2008
*/
public Object delete(Object obj) throws SQLException {
boolean flag = false;
String []id = (String[])obj;
for(int i=0;i<id.length;i++){
this.deleteOne(id[i]);
}
flag = true;
return flag;
}
public void deleteOne(Object obj) throws SQLException {
PreparedStatement ps=null;
String did = (String)obj;
Integer sid=Integer.parseInt(did);
String SQL="UPDATE STUDENT SET STU_STATE='1' WHERE ID=?";
try {
ps=conn.prepareStatement(SQL);
ps.setInt(1, sid);
ps.executeUpdate();
} catch (RuntimeException e) {
e.printStackTrace();
}
if(ps!=null){
ps.close();
}
SQL=null;
}
public Object find() throws SQLException {
PreparedStatement ps=null;
ResultSet rs=null;
StudentVO svo=null;
StudentDTO sdto=null;;
ArrayList arraylist= new ArrayList();
String SQL="SELECT * FROM STUDENT ";
ps=conn.prepareStatement(SQL);
rs=ps.executeQuery();
while(rs.next()){
svo=new StudentVO();
svo.setId(rs.getInt("id"));
svo.setStuNo(rs.getString("stu_no"));
svo.setBirth(rs.getString("birth"));
svo.setCid(rs.getString("cid"));
svo.setClassNo(rs.getString("class_no"));
svo.setDormNo(rs.getString("dorm_no"));
svo.setDuty(rs.getString("duty"));
svo.setEnterTime(rs.getString("enter_time"));
svo.setFatherName(rs.getString("father_name"));
svo.setGender(rs.getString("gender"));
svo.setHomeAddr(rs.getString("home_addr"));
svo.setHomeTel(rs.getString("home_tel"));
// svo.setId(rs.getInt("id"));
svo.setLate(rs.getString("late"));
svo.setLearning(rs.getString("learning"));
svo.setLeave(rs.getString("leavees"));
svo.setMotherName(rs.getString("mother_name"));
svo.setNation(rs.getString("nation"));
svo.setPhone(rs.getString("phone"));
svo.setPolity(rs.getString("polity"));
svo.setRemarkInfo(rs.getString("remark_info"));
svo.setStuName(rs.getString("stu_name"));
// svo.setStuNo(rs.getString("stu_no"));
svo.setStuState(rs.getString("stu_state"));
svo.setSturyMark(rs.getString("study_mark"));
svo.setTeacherNo(rs.getString("teacher_no"));
svo.setTruant(rs.getString("truant"));
arraylist.add(svo);
}
if(ps!=null){
ps.close();
}
if(rs!=null){
rs.close();
}
svo=null;
SQL=null;
sdto=null;
return arraylist;
}
public Object find(Object arg0) throws SQLException {
return null;
}
public Object findAll() throws SQLException {
PreparedStatement ps=null;
ResultSet rs=null;
StudentVO svo=null;
StudentDTO sdto=new StudentDTO();
ArrayList arraylist=null;
String SQL=null;
Object[] objs=new Object[2];
Integer count =new Integer(0);
count=getCount(sdto);
StringBuffer strbuf=new StringBuffer("SELECT ID,STU_NO,STU_NAME,BIRTH,GENDER,NATION,PHONE,STU_STATE,FATHER_NAME,MOTHER_NAME,HOME_ADDR,HOME_TEL,POLITY,CID,REMARK_INFO,CLASS_NO,TEACHER_NO,ENTER_TIME,LEARNING,DORM_NO,DUTY,STUDY_MARK,LATE,LEAVEES,TRUANT FROM STUDENT WHERE 1=1 ");
if(sdto.getStuNo()!=null&&!"".equals(sdto.getStuNo())){
strbuf.append(" AND STU_NO='"+sdto.getStuNo().trim()+"'");
}
if(sdto.getStuName()!=null&&!"".equals(sdto.getStuName())){
strbuf.append(" AND STU_NAME='"+sdto.getStuName().trim()+"'");
}
if(sdto.getClassNo()!=null&&!"".equals(sdto.getClassNo())){
strbuf.append(" AND CLASS_NO='"+sdto.getClassNo().trim()+"'");
}
if(sdto.getId()!=0&&!"".equals(sdto.getId())){
strbuf.append(" AND ID='"+sdto.getId()+"'");
}
if(sdto.getStuName()!=null&&!"".equals(sdto.getStuName())){
strbuf.append(" AND STU_NAME='"+sdto.getStuName()+"'");
}
if(sdto.getGender()!=null&&!"".equals(sdto.getGender())){
strbuf.append(" AND GENDER='"+sdto.getGender()+"'");
}
if(sdto.getBirth()!=null&&!"".equals(sdto.getBirth())){
strbuf.append(" AND BIRTH='"+sdto.getBirth()+"'");
}
if(sdto.getNation()!=null&&!"".equals(sdto.getNation())){
strbuf.append(" AND NATION='"+sdto.getNation()+"'");
}
if(sdto.getPhone()!=null&&!"".equals(sdto.getPhone())){
strbuf.append(" AND PHONE='"+sdto.getPhone()+"'");
}
if(sdto.getStuState()!=null&&!"".equals(sdto.getStuState())){
strbuf.append(" AND STU_STATE='"+sdto.getStuState()+"'");
}
if(sdto.getFatherName()!=null&&!"".equals(sdto.getFatherName())){
strbuf.append(" AND FATHER_NAME='"+sdto.getFatherName()+"'");
}
if(sdto.getMotherName()!=null&&!"".equals(sdto.getMotherName())){
strbuf.append(" AND MOTHER_NAME='"+sdto.getMotherName()+"'");
}
if(sdto.getHomeAddr()!=null&&!"".equals(sdto.getHomeAddr())){
strbuf.append(" AND HOME_ADDR='"+sdto.getHomeAddr()+"'");
}
if(sdto.getHomeTel()!=null&&!"".equals(sdto.getHomeTel())){
strbuf.append(" AND HOME_TEL='"+sdto.getHomeTel()+"'");
}
if(sdto.getPolity()!=null&&!"".equals(sdto.getPolity())){
strbuf.append(" AND POLITY='"+sdto.getPolity()+"'");
}
if(sdto.getCid()!=null&&!"".equals(sdto.getCid())){
strbuf.append(" AND CID='"+sdto.getCid()+"'");
}
if(sdto.getRemarkInfo()!=null&&!"".equals(sdto.getRemarkInfo())){
strbuf.append(" AND REMARK_INFO='"+sdto.getRemarkInfo()+"'");
}
if(sdto.getTeacherNo()!=null&&!"".equals(sdto.getTeacherNo())){
strbuf.append(" AND TEACHER_NO='"+sdto.getTeacherNo()+"'");
}
if(sdto.getEnterTime()!=null&&!"".equals(sdto.getEnterTime())){
strbuf.append(" AND ENTER_TIME='"+sdto.getEnterTime()+"'");
}
if(sdto.getLearning()!=null&&!"".equals(sdto.getLearning())){
strbuf.append(" AND LEARNING='"+sdto.getLearning()+"'");
}
if(sdto.getDormNo()!=null&&!"".equals(sdto.getDormNo())){
strbuf.append(" AND DORM_NO='"+sdto.getDormNo()+"'");
}
if(sdto.getDuty()!=null&&!"".equals(sdto.getDuty())){
strbuf.append(" AND DUTY='"+sdto.getDuty()+"'");
}
if(sdto.getSturyMark()!=null&&!"".equals(sdto.getSturyMark())){
strbuf.append(" AND STUDY_MARK='"+sdto.getSturyMark()+"'");
}
if(sdto.getLate()!=null&&!"".equals(sdto.getLate())){
strbuf.append(" AND LATE='"+sdto.getLate()+"'");
}
if(sdto.getLeave()!=null&&!"".equals(sdto.getLeave())){
strbuf.append(" AND LEAVEES='"+sdto.getLeave()+"'");
}
if(sdto.getTruant()!=null&&!"".equals(sdto.getTruant())){
strbuf.append(" AND TRUANT='"+sdto.getTruant()+"'");
}
int i=(Integer.parseInt(sdto.getCurrentPage())-1)*Integer.parseInt(sdto.getRowPerPage());
strbuf.append(" AND LIMIT ORDER BY ID DESC "+i+","+sdto.getRowPerPage());
SQL=strbuf.toString();
ps=conn.prepareStatement(SQL);
rs=ps.executeQuery();
while(rs.next()){
svo.setBirth(rs.getString("birth"));
svo.setCid(rs.getString("cid"));
svo.setClassNo(rs.getString("classNo"));
svo.setDormNo(rs.getString("dormNo"));
svo.setDuty(rs.getString("duty"));
svo.setEnterTime(rs.getString("enterTime"));
svo.setFatherName(rs.getString("fatherName"));
svo.setGender(rs.getString("gender"));
svo.setHomeAddr(rs.getString("homeAdddr"));
svo.setHomeTel(rs.getString("homeTel"));
svo.setId(rs.getInt("id"));
svo.setLate(rs.getString("late"));
svo.setLearning(rs.getString("learning"));
svo.setLeave(rs.getString("leavees"));
svo.setMotherName(rs.getString("motherName"));
svo.setNation(rs.getString("nation"));
svo.setPhone(rs.getString("phone"));
svo.setPolity(rs.getString("polity"));
svo.setRemarkInfo(rs.getString("remarkInfo"));
svo.setStuName(rs.getString("stuName"));
svo.setStuNo(rs.getString("stuNo"));
svo.setStuState(rs.getString("stuState"));
svo.setSturyMark(rs.getString("sturyMark"));
svo.setTeacherNo(rs.getString("teacherNo"));
svo.setTruant(rs.getString("truant"));
arraylist.add(svo);
}
objs[0]=arraylist;
objs[1]=count;
if(ps!=null){
ps.close();
}
if(rs!=null){
rs.close();
}
svo=null;
sdto=null;
SQL=null;
return objs;
}
/**
*
* 查询student表中的所有信息
* @author 吴朋
* @param obj 传入 StudentDTO对象
* @return 返回objs数组 该数组存储了arraylit集合和count集合数据
* @exception SQLException
* creation date :04-30-2008
*/
public Object findAll(Object obj) throws SQLException {
PreparedStatement ps=null;
ResultSet rs=null;
StudentVO svo=null;
StudentDTO sdto=(StudentDTO) obj;
ArrayList arraylist=new ArrayList();
String SQL=null;
Object[] objs=new Object[2];
Integer count =new Integer(0);
count=getCount(sdto);
StringBuffer strbuf=new StringBuffer("SELECT ID,STU_NO,STU_NAME,BIRTH,GENDER,NATION,PHONE,STU_STATE,FATHER_NAME,MOTHER_NAME,HOME_ADDR,HOME_TEL,POLITY,CID,REMARK_INFO,CLASS_NO,TEACHER_NO,ENTER_TIME,LEARNING,DORM_NO,DUTY,STUDY_MARK,LATE,LEAVEES,TRUANT FROM STUDENT WHERE STU_STATE='0' ");
if(sdto.getStuNo()!=null&&!"".equals(sdto.getStuNo())){
strbuf.append(" AND STU_NO like '%"+sdto.getStuNo().trim()+"%'");
}
if(sdto.getStuName()!=null&&!"".equals(sdto.getStuName())){
strbuf.append(" AND STU_NAME like '%"+sdto.getStuName().trim()+"%'");
}
if(sdto.getClassNo()!=null&&!"".equals(sdto.getClassNo())){
strbuf.append(" AND CLASS_NO like '%"+sdto.getClassNo().trim()+"%'");
}
if(sdto.getId()!=0&&!"".equals(sdto.getId())){
strbuf.append(" AND ID='"+sdto.getId()+"'");
}
if(sdto.getBirth()!=null&&!"".equals(sdto.getBirth())){
strbuf.append(" AND BIRTH='"+sdto.getBirth()+"'");
}
if(sdto.getGender()!=null&&!"".equals(sdto.getGender())){
strbuf.append(" AND GENDER='"+sdto.getGender()+"'");
}
if(sdto.getNation()!=null&&!"".equals(sdto.getNation())){
strbuf.append(" AND NATION='"+sdto.getNation()+"'");
}
if(sdto.getPhone()!=null&&!"".equals(sdto.getPhone())){
strbuf.append(" AND PHONE='"+sdto.getPhone()+"'");
}
if(sdto.getStuState()!=null&&!"".equals(sdto.getStuState())){
strbuf.append(" AND STU_STATE='"+sdto.getStuState()+"'");
}
if(sdto.getFatherName()!=null&&!"".equals(sdto.getFatherName())){
strbuf.append(" AND FATHER_NAME='"+sdto.getFatherName()+"'");
}
if(sdto.getMotherName()!=null&&!"".equals(sdto.getMotherName())){
strbuf.append(" AND MOTHER_NAME='"+sdto.getMotherName()+"'");
}
if(sdto.getHomeAddr()!=null&&!"".equals(sdto.getHomeAddr())){
strbuf.append(" AND HOME_ADDR='"+sdto.getHomeAddr()+"'");
}
if(sdto.getHomeTel()!=null&&!"".equals(sdto.getHomeTel())){
strbuf.append(" AND HOME_TEL='"+sdto.getHomeTel()+"'");
}
if(sdto.getPolity()!=null&&!"".equals(sdto.getPolity())){
strbuf.append(" AND POLITY='"+sdto.getPolity()+"'");
}
if(sdto.getCid()!=null&&!"".equals(sdto.getCid())){
strbuf.append(" AND CID='"+sdto.getCid()+"'");
}
if(sdto.getRemarkInfo()!=null&&!"".equals(sdto.getRemarkInfo())){
strbuf.append(" AND REMARK_INFO='"+sdto.getRemarkInfo()+"'");
}
if(sdto.getTeacherNo()!=null&&!"".equals(sdto.getTeacherNo())){
strbuf.append(" AND TEACHER_NO='"+sdto.getTeacherNo()+"'");
}
if(sdto.getEnterTime()!=null&&!"".equals(sdto.getEnterTime())){
strbuf.append(" AND ENTER_TIME='"+sdto.getEnterTime()+"'");
}
if(sdto.getLearning()!=null&&!"".equals(sdto.getLearning())){
strbuf.append(" AND LEARNING='"+sdto.getLearning()+"'");
}
if(sdto.getDormNo()!=null&&!"".equals(sdto.getDormNo())){
strbuf.append(" AND DORM_NO='"+sdto.getDormNo()+"'");
}
if(sdto.getDuty()!=null&&!"".equals(sdto.getDuty())){
strbuf.append(" AND DUTY='"+sdto.getDuty()+"'");
}
if(sdto.getSturyMark()!=null&&!"".equals(sdto.getSturyMark())){
strbuf.append(" AND STUDY_MARK='"+sdto.getSturyMark()+"'");
}
if(sdto.getLate()!=null&&!"".equals(sdto.getLate())){
strbuf.append(" AND LATE='"+sdto.getLate()+"'");
}
if(sdto.getLeave()!=null&&!"".equals(sdto.getLeave())){
strbuf.append(" AND LEAVEES='"+sdto.getLeave()+"'");
}
if(sdto.getTruant()!=null&&!"".equals(sdto.getTruant())){
strbuf.append(" AND TRUANT='"+sdto.getTruant()+"'");
}
int i=(Integer.parseInt(sdto.getCurrentPage())-1)*Integer.parseInt(sdto.getRowPerPage());
strbuf.append(" ORDER BY ID DESC LIMIT "+i+","+sdto.getRowPerPage());
SQL=strbuf.toString();
ps=conn.prepareStatement(SQL);
rs=ps.executeQuery();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -