课程设计小知识(三)
unt;
}
@Override
public int update(Reader reader) throws Exception {
// TODO Auto-generated method stub
int count = 0;
String sql = "UPDATE reader SET cardid=?,readername=?,password=?,sex=?,idcard=?,homeaddress=?,phone=?,jobaddress=?,booksum=?,carddate=?,abatedate=?,borrowersum=?,xueli=?,remark=? WHERE readerid=?";
PreparedStatement pstmt = null;
try {
pstmt = this.con.prepareStatement(sql);
pstmt.setString(1, reader.getCardid());
pstmt.setString(2, reader.getReadername());
pstmt.setString(3, reader.getPassword());
pstmt.setString(4, reader.getSex());
pstmt.setString(5, reader.getIdcard());
pstmt.setString(6, reader.getHomeaddress());
pstmt.setString(7, reader.getPhone());
pstmt.setString(8, reader.getJobaddress());
pstmt.setInt(9, reader.getBooksum());
pstmt.setString(10, reader.getCarddate());
pstmt.setString(11, reader.getAbatedate());
pstmt.setInt(12, reader.getBorrowersum());
pstmt.setString(13,reader.getXueli());
pstmt.setString(14,reader.getRemark());
pstmt.setInt(15, reader.getReaderid());
count = pstmt.executeUpdate();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
pstmt.close();
}
return count;
}
@Override
public Reader findByID(int id) throws Exception {
// TODO Auto-generated method stub
Reader reader = null;
String sql = "SELECT * FROM reader WHERE readerid=?";
PreparedStatement pstmt = null;
try {
pstmt = this.con.prepareStatement(sql);
pstmt.setInt(1, id);
ResultSet set = pstmt.executeQuery();
//System.out.println(set);
if(set.next()){
reader = new Reader();
reader.setReaderid(id);
reader.setCardid(set.getString(2));
reader.setReadername(set.getString(3));
reader.setPassword(set.getString(4));
reader.setSex(set.getString(5));
reader.setIdcard(set.getString(6));
reader.setHomeaddress(set.getString(7));
reader.setPhone(set.getString(8));
reader.setJobaddress(set.getString(9));
reader.setBooksum(set.getInt(10));
reader.setCarddate(set.getString(11));
reader.setAbatedate(set.getString(12));
reader.setBorrowersum(set.getInt(13));
reader.setXueli(set.getString(14));
reader.setRemark(set.getString(15));
set.close();
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
pstmt.close();
}
return reader;
}
@Override
public List
findAll() throws Exception {
// TODO Auto-generated method stub
List readers = null;
Reader reader = null;
String sql = "SELECT * FROM reader";
PreparedStatement pstmt = null;
try {
pstmt = this.con.prepareStatement(sql);
ResultSet set = pstmt.executeQuery();
if(set!=null){
readers = new ArrayList();
while(set.next()){
reader = new Reader();
reader.setReaderid(set.getInt(1));
reader.setCardid(set.getString(2));
reader.setReadername(set.getString(3));
reader.setPassword(set.getString(4));
reader.setSex(set.getString(5));
reader.setIdcard(set.getString(6));
reader.setHomeaddress(set.getString(7));
reader.setPhone(set.getString(8));
reader.setJobaddress(set.getString(9));
reader.setBooksum(set.getInt(10));
reader.setCarddate(set.getString(11));
reader.setAbatedate(set.getString(12));
reader.setBorrowersum(set.getInt(13));
reader.setXueli(set.getString(14));
reader.se