studentdao.java

使用struts+spring+JDBC 实现的学生选课管理系统

package bit.jeffy.service;

import java.util.Iterator;
import java.util.List;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapperResultReader;

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(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";
	//学生登录验证
	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){
		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[]{xh,pd,stu.getXm()+"",yx,stu.getMajor()+""};
		
		try{
			jdbcTemplate.update(sql_1,ob);
			return true;
		}catch(Exception e){
			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){
		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{
			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){
			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{
			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(){
		return jdbcTemplate.query(sql_6,new RowMapperResultReader(new StudentRowMapper()));
	}
	
	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;
	}

}