网上选课系统sqlserver+jsp

package bit.jeffy.service; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Iterator; import java.util.List; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import org.springframework.dao.DataAccessException; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowMapper; import org.springframework.jdbc.core.StatementCallback; import bit.jeffy.entity.Student; import bit.jeffy.springdb.StudentRowMapper; public class StudentDao{ private JdbcTemplate jdbcTemplate; private SelectCourseDao selectcoursedao; private String sql = "select count(*) from Student where XH=?"; private String sql_1 = "insert into Student(id,XH,PASSWORD,XM,YX,MAJOR) values(?,?,?,?,?,?)"; private String sql_2 = "delete from Student where ID=?"; private String sql_4 = "select * from Student where XH=? and PASSWORD=?"; private String sql_5 = "select * from Student where XH=?"; private String sql_6 = "select * from Student"; private String sql_7="select max(id) from student"; //学生登录验证 public boolean validate(Student stu){ String xh = stu.getXh(); if( xh.equals("") || xh==null){ return false; } Object[] ob = new Object[]{xh}; int nCount = 0; nCount = jdbcTemplate.queryForInt(sql,ob); if( nCount>0 ){ return true; }else{ return false; } } //管理员增加学生 public boolean add(Student stu){ System.out.println(stu.getId()); String xh = stu.getXh(); String pd = stu.getPassword(); String yx = stu.getYx(); if( xh.equals("") || xh==null || pd.equals("") || pd==null || yx.equals("") || yx==null){ return false; } Object ob[] = new Object[]{stu.getId(),xh,pd,stu.getXm()+"",yx,stu.getMajor()+""}; try{ jdbcTemplate.update(sql_1,ob); return true; }catch(Exception e){ System.out.println(e.getMessage()); return false; } } //管理员删除学生 public boolean removeById(Student stu){ long id = stu.getId(); if(id < 0){ return false; } Object[] ob = new Object[]{new Long(id)}; try{ if(selectcoursedao.deleteAllByStu(stu)){ jdbcTemplate.update(sql_2,ob); }else{ return false; } }catch(Exception e){ return false; } return true; } //通过学号和密码读出这个用户来 public Student read(Student stu){ System.out.println("run---------------"); String xh = stu.getXh(); String pd = stu.getPassword(); Student st = null; if( xh.equals("") || xh==null || pd.equals("") || pd==null){ return null; } List list = null; Iterator it = null; Object[] ob = new Object[]{xh,pd}; try{ RowMapper rm=new StudentRowMapper(); list=jdbcTemplate.query(sql_4,ob,rm); //list = jdbcTemplate.query(sql_4,ob,new RowMapperResultReader(new StudentRowMapper())); it = list.iterator(); if( it.hasNext() ){ st = (Student)it.next(); return st; }else{ return null; } }catch(Exception e){ System.out.println(e.getMessage()); return null; } } //用学号取出学生对象,被SelectCourseDao的LogScore调用 public Student readByXh(Student stu){ String xh = stu.getXh(); Student st = null; if(xh.equals("") || xh==null){ return null; } List list = null; Iterator it = null; Object[] ob = new Object[]{xh}; try{ RowMapper rm=new StudentRowMapper(); list=jdbcTemplate.query(sql_5,ob,rm); //list = jdbcTemplate.query(sql_5,ob,new RowMapperResultReader(new StudentRowMapper())); it = list.iterator(); if( it.hasNext() ){ st = (Student)it.next(); return st; }else{ return null; } }catch(Exception e){ return null; } } //取回所有的学生信息 public List getAll(){ RowMapper rm=new StudentRowMapper(); return jdbcTemplate.query(sql_6,rm); //return jdbcTemplate.query(sql_6,new RowMapperResultReader(new StudentRowMapper())); } /*public Integer getMaxId(){ return (Integer)jdbcTemplate.queryForInt(sql_7)+1; }*/ public Integer getMaxId(){ return (Integer) jdbcTemplate.execute(new StatementCallback(){ public Object doInStatement(Statement st) throws SQLException, DataAccessException { ResultSet rs=st.executeQuery(sql_7); if(rs.next()){ return rs.getInt(1)+1; } else return null; }}); } public JdbcTemplate getJdbcTemplate() { return jdbcTemplate; } public void setJdbcTemplate(JdbcTemplate jdbcTemplate) { this.jdbcTemplate = jdbcTemplate; } public SelectCourseDao getSelectcoursedao() { return selectcoursedao; } public void setSelectcoursedao(SelectCourseDao selectcoursedao) { this.selectcoursedao = selectcoursedao; } public static void main(String args[]){ ApplicationContext ac=new ClassPathXmlApplicationContext("/bit/jeffy/config/beans.xml"); StudentDao dao=(StudentDao) ac.getBean("studentdao"); System.out.println(dao.getMaxId()); } }