studentdao.java

是一个专门用于高校教务管理的源码

package education;

import java.sql.*;
import java.util.*;
import java.io.*;

public class studentDAO extends DAO
{
    public boolean findStudent(studentBean bea)
   {
       boolean isOk=false;
       try
       {
           String sql="select * from student where name=? and password=?";
           PreparedStatement pstm=con.prepareStatement(sql);
           pstm.setString(1,bea.getName());
           pstm.setString(2,bea.getPassword());
           ResultSet rs=pstm.executeQuery();
           while(rs.next())
           {
               isOk=true;
           }
           rs.close();
           pstm.close();
       }
       catch(Exception e)
       {
           e.printStackTrace();
       }
       return isOk;
   }

   public ArrayList getStudent()
   {
       ArrayList list=new ArrayList();
       try
       {
           String sql="select id,name,password,sex,age,jiguan,tel,email,department,mark from student";
           PreparedStatement pstm=con.prepareStatement(sql);
           ResultSet rs=pstm.executeQuery();
           while(rs.next())
           {
               String id=rs.getString(1);
               String name=rs.getString(2);
               String password=rs.getString(3);
               String sex=rs.getString(4);
               String age=rs.getString(5);
               String jiguan=rs.getString(6);
               String tel=rs.getString(7);
               String email=rs.getString(8);
               String department=rs.getString(9);
               int mark=rs.getInt(10);

               studentBean bea=new studentBean();
               bea.setId(id);
               bea.setPassword(password);
               bea.setName(name);
               bea.setSex(sex);
               bea.setAge(age);
               bea.setJiguan(jiguan);
               bea.setTel(tel);
               bea.setEmail(email);
               bea.setDepartment(department);
               bea.setMark(mark);

               list.add(bea);
           }
           rs.close();
           pstm.close();
       }
       catch(Exception e)
       {
           e.printStackTrace();
       }
       return list;
   }

   public boolean addStudetn(studentBean bea)
   {
       boolean isOk=true;
       try
       {
           String sql="insert  into student (id,name,password,sex,age,jiguan,tel,department) values(?,?,?,?,?,?,?,?)";
           PreparedStatement pstm=con.prepareStatement(sql);
           pstm.setString(1,bea.getId());
           pstm.setString(2,bea.getName());
           pstm.setString(3,bea.getPassword());
           pstm.setString(4,bea.getSex());
           pstm.setString(5,bea.getAge());
           pstm.setString(6,bea.getJiguan());
           pstm.setString(7,bea.getTel());
           pstm.setString(8,bea.getDepartment());
           int n=pstm.executeUpdate();
           if(n>0)
           {
               isOk=true;
           }
           pstm.close();
       }
       catch(Exception e)
       {
           e.printStackTrace();
       }
       return isOk;
   }

   public boolean delStudent(String id){
       boolean isOk=true;
       try{
           String sql="delete from student where id=?";
           PreparedStatement pstm=con.prepareStatement(sql);
           pstm.setString(1,id);
           int n=pstm.executeUpdate();
           if(n>0){
               isOk=true;
           }
           pstm.close();
       }catch(Exception e){
           e.printStackTrace();
       }
       return isOk;
   }

   public boolean updStudent(studentBean bea){
       boolean isOk=false;
       try{
           String sql="update set name=?,password=?,sex=?,age=?,jiguan=?,tel=?,email=?,department=?,mark=?  from student ";
           PreparedStatement pstm=con.prepareStatement(sql);
           pstm.setString(1,bea.getId());
           pstm.setString(2,bea.getName());
           pstm.setString(3,bea.getPassword());
           pstm.setString(4,bea.getSex());
           pstm.setString(5,bea.getAge());
           pstm.setString(6,bea.getJiguan());
           pstm.setString(7,bea.getTel());
           pstm.setString(8,bea.getDepartment());
           int n=pstm.executeUpdate();
           if(n>0)
           {
               isOk=true;
           }
           pstm.close();

       }catch(Exception e){
           e.printStackTrace();
       }
       return isOk;
   }
}