package com.impl;
import java.util.ArrayList;
import java.util.List;
import com.dao.StudentDao;
import com.pojo.Student;
import java.sql.*;
import com.db.DBConnection;
public class StudentDaoImpl implements StudentDao {
public boolean deleteStudent(int sid) {
// TODO Auto-generated method stub
Connection con=null;
PreparedStatement pst=null;
boolean b=false;
try {
con=DBConnection.getConnection();
pst=con.prepareStatement("delete student where sid=?");
pst.setInt(1,sid);
int i=pst.executeUpdate();
if(i>0){
b=true;
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
finally{
DBConnection.closePreparedStatement(pst);
DBConnection.closeConnection(con);
}
return b;
}
public boolean insertStudent(Student s) {
// TODO Auto-generated method stub
Connection con=null;
PreparedStatement pst=null;
boolean b=false;
try {
con=DBConnection.getConnection();
pst=con.prepareStatement("insert into student values(?,?,?,?)");
pst.setString(1,s.getName());
pst.setString(2,s.getSex());
pst.setInt(3,s.getAge());
pst.setInt(4,s.getCid());
int i=pst.executeUpdate();
if(i>0){
b=true;
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
finally{
DBConnection.closePreparedStatement(pst);
DBConnection.closeConnection(con);
}
return b;
}
public List<Student> selectAllStudent() {
// TODO Auto-generated method stub
Connection con=null;
PreparedStatement pst=null;
ResultSet rs=null;
List<Student> list=new ArrayList<Student>();
try {
con=DBConnection.getConnection();
pst=con.prepareStatement("select * from student");
rs=pst.executeQuery();
while(rs.next()){
Student s=new Student();
s.setSid(rs.getInt("sid"));
s.setName(rs.getString("sname"));
s.setAge(rs.getInt("age"));
s.setSex(rs.getString("sex"));
s.setCid(rs.getInt("cid"));
list.add(s);
}
} catch (Exception e) {
// TODO: handle exception
}
finally{
DBConnection.closeResultSet(rs);
DBConnection.closePreparedStatement(pst);
DBConnection.closeConnection(con);
}
return list;
}
public boolean updateStudent(Student s) {
// TODO Auto-generated method stub
return false;
}
}
Java中Dao模式实例
5星 · 超过95%的资源 需积分: 28 138 浏览量
2009-02-23
08:53:23
上传
评论
收藏 232KB RAR 举报 
daoDemo.rar （35个子文件） 
daoDemo 
.project 1KB .mymetadata 294B WebRoot WEB-INF web.xml 1KB lib 
sqljdbc.jar 227KB classes com biz StudentBiz.class 271B dao ClassInfoDao.class 159B UserDao.class 177B StudentDao.class 260B db DBConnection.class 1KB servlet LoginServlet.class 2KB ShowInfoServlet.class 2KB impl UserDaoImpl.class 2KB StudentDaoImpl.class 3KB filter EncodingFilter.class 1KB pojo ClassInfo.class 719B User.class 887B Student.class 1KB index.jsp 1KB META-INF MANIFEST.MF 39B showInfo.jsp 1KB main.jsp 914B .myeclipse src com biz StudentBiz.java 54B dao UserDao.java 124B ClassInfoDao.java 146B StudentDao.java 259B db DBConnection.java 1005B servlet LoginServlet.java 1005B ShowInfoServlet.java 1KB impl UserDaoImpl.java 966B StudentDaoImpl.java 2KB filter EncodingFilter.java 777B pojo User.java 489B ClassInfo.java 310B Student.java 658B .classpath 432B
评论16
最新资源