java很多基础知识都忘了_谢谢，大家帮下。好多java只是忘记了。都是基础知识。...

publicclassQuestionDaoextendsBaseDao{publicListfindAllInfo(){Listquestion=newArrayList();Connectionconn=null;PreparedStatementpst=null;Resul...

public class QuestionDao extends BaseDao {

public List findAllInfo(){

List question=new ArrayList();

Connection conn=null;

PreparedStatement pst=null;

ResultSet rs=null;

conn=this.getConnection();

try {

pst=conn.prepareStatement("select * from question");

rs=pst.executeQuery();

while(rs.next()){

question.add(new Question(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getInt(7),rs.getString(8)));

}

} catch (SQLException e) {

e.printStackTrace();

}

this.closeAll(rs, pst, conn);

return question;

}

public Question findBySubject(int subject){

Question question=null;

Connection conn=null;

PreparedStatement pst=null;

ResultSet rs=null;

conn=this.getConnection();

try {

pst=conn.prepareStatement("select * from question where subject=?");

rs=pst.executeQuery();

while(rs.next()){

question=new Question(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getInt(7),rs.getString(8));

pst.setInt(1, subject);

}

} catch (SQLException e) {

e.printStackTrace();

}

this.closeAll(rs, pst, conn);

return question;

}

public boolean addInfo(Question question){

boolean flag=false;

Connection conn=null;

PreparedStatement pst=null;

conn=this.getConnection();

try {

pst=conn.prepareStatement("insert into question values(seq_question.nextval,?,?,?,?,?,?,?)");

pst.setString(1, question.getQuestion());

pst.setString(2, question.getOption_a());

pst.setString(3, question.getOption_b());

pst.setString(4, question.getOption_c());

pst.setString(5, question.getOption_d());

pst.setInt(6, question.getSubject());

pst.setString(7, question.getAnswer());

flag=pst.executeUpdate()==1;

} catch (SQLException e) {

e.printStackTrace();

}

this.closeAll(null, pst, conn);

return flag;

}

}

展开