北大青鸟6.0S2考试试题带答案

package org.yangmeng.dao.impl; import java.sql.ResultSet; import java.util.ArrayList; import org.yangmeng.dao.BaseDAO; import org.yangmeng.dao.StudentDAO; import org.yangmeng.entity.Student; public class StudentDAOImpl extends BaseDAO implements StudentDAO { public ArrayList<Student> getAll() { String sql = "select * from studentInfo order by sid"; ArrayList<Student> al = new ArrayList<Student>(); ResultSet rs = this.query(sql, null); try { while(rs.next()){ Student s = new Student(); s.setSid(rs.getInt(1)); s.setSname(rs.getString(2)); s.setSgender(rs.getString(3)); s.setSage(rs.getInt(4)); s.setAddress(rs.getString(5)); s.setSemail(rs.getString(6)); al.add(s); } this.close(); } catch (Exception e) { e.printStackTrace(); } return al; } public boolean update(Student s) { String sql = "update studentInfo set sname=?,sgender=?,sage=?,saddress=?,semail=? where sid=?"; ArrayList al = new ArrayList(); al.add(s.getSname()); al.add(s.getSgender()); al.add(s.getSage()); al.add(s.getAddress()); al.add(s.getSemail()); al.add(s.getSid()); int rs = this.update(sql, al); this.close(); return rs==1; } public Student getStuInfo(int id) { Student s = new Student(); String sql = "select * from studentInfo where sid = ? "; ArrayList al = new ArrayList(); al.add(id); ResultSet rs = this.query(sql, al); try { while(rs.next()){ s.setSid(rs.getInt(1)); s.setSname(rs.getString(2)); s.setSgender(rs.getString(3)); s.setSage(rs.getInt(4)); s.setAddress(rs.getString(5)); s.setSemail(rs.getString(6)); } } catch (Exception e) { e.printStackTrace(); } this.close(); return s; } public boolean add(Student s) { String sql = "insert into studentInfo values(sid.nextval,?,?,?,?,?)"; ArrayList al = new ArrayList(); al.add(s.getSname()); al.add(s.getSgender()); al.add(s.getSage()); al.add(s.getAddress()); al.add(s.getSemail()); int rs = this.update(sql, al); this.close(); return rs==1; } public boolean delete(ArrayList<Integer> al) { StringBuffer sql = new StringBuffer(); sql.append("delete studentInfo where 1=1"); ArrayList parms = new ArrayList(); if (al!=null) { for (int i = 0; i < al.size(); i++) { parms.add(al.get(i)); if (i==0) { sql.append(" and sid=?"); }else { sql.append(" or sid=?"); } } } int rs = this.update(sql.toString(), parms); if (rs>0) { return true; }else{ return false; } } }