教务管理系统（WEB服务应用开发）.rar

package com.tcd.service; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.tcd.model.stuInfo; public class stuInfoService { /** * ��֤�û��Ƿ�Ϸ� */ private Connection conn; private PreparedStatement pstmt; public stuInfoService() { conn = new com.tcd.conn.conn().getCon(); } /** * �����ݿ������ѧ����Ϣ * @param stu * @return */ public boolean addStu(stuInfo stu){ try { pstmt =conn.prepareStatement("insert into studentinfo" +"(nicheng,truename,xb,zy,kc,xq,bz)" +"values(?,?,?,?,?,?,?)"); pstmt.setString(1, stu.getNicheng()); pstmt.setString(2, stu.getTruename()); pstmt.setByte(3, stu.getXb()); pstmt.setString(4, stu.getZy()); pstmt.setString(5, stu.getKcs()); pstmt.setString(6, stu.getXqs()); pstmt.setString(7, stu.getBz()); pstmt.executeUpdate(); return true; } catch (SQLException e) { e.printStackTrace(); return false; } } /** * ��ѯѧ����Ϣ * @return */ public List queryAllStu(){ List stus = new ArrayList(); try { pstmt =conn.prepareStatement("select * from studentinfo"); ResultSet rs = pstmt.executeQuery(); while(rs.next()){ stuInfo stu = new stuInfo(); stu.setId(rs.getInt(1)); stu.setNicheng(rs.getString(2)); stu.setTruename(rs.getString(3)); stu.setXb(rs.getByte(4)); stu.setZy(rs.getString(5)); if(rs.getString(6)!=null) stu.setKc(rs.getString(6).split("&")); if(rs.getString(7)!=null) stu.setXq(rs.getString(7).split("&")); stu.setBz(rs.getString(8)); stus.add(stu); } return stus; } catch (Exception e) { // TODO: handle exception e.printStackTrace(); return null; } } /** * ����ѧ��id��ѯѧ����Ϣ * @param id * @return */ public stuInfo queryStubyID(int id){ //List stus = new ArrayList(); try { pstmt =conn.prepareStatement("select * from studentinfo where id=?"); pstmt.setInt(1, id); ResultSet rs = pstmt.executeQuery(); if(rs.next()){ stuInfo stu = new stuInfo(); stu.setId(rs.getInt(1)); stu.setNicheng(rs.getString(2)); stu.setTruename(rs.getString(3)); stu.setXb(rs.getByte(4)); stu.setZy(rs.getString(5)); if(rs.getString(6)!=null) stu.setKc(rs.getString(6).split("&")); if(rs.getString(7)!=null) stu.setXq(rs.getString(7).split("&")); stu.setBz(rs.getString(8)); //stus.add(stu); return stu; } return null; } catch (Exception e) { // TODO: handle exception e.printStackTrace(); return null; } } /** * �޸�ѧ����Ϣ * @param stu * @return */ public boolean updateStu(stuInfo stu){ try { pstmt = conn.prepareStatement("update studentinfo set nicheng=?,truename=?,xb=?," + "zy=?,kc=?, xq=?,bz=? where id=?"); pstmt.setString(1, stu.getNicheng()); pstmt.setString(2, stu.getTruename()); pstmt.setByte(3, stu.getXb()); pstmt.setString(4, stu.getZy()); pstmt.setString(5, stu.getKcs()); pstmt.setString(6, stu.getXqs()); pstmt.setString(7, stu.getBz()); pstmt.setInt(8, stu.getId()); pstmt.executeUpdate(); return true; } catch (Exception e) { // TODO: handle exception e.printStackTrace(); return false; } } /** * ɾ��ѧ����Ϣ * @param id * @return */ public boolean deleteStu(int id){ try { pstmt = conn.prepareStatement("delete from studentinfo where id=?"); pstmt.setInt(1, id); pstmt.executeUpdate(); return true; } catch (Exception e) { e.getStackTrace(); return false; } } }