teacherdao.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.Teacher;
import bit.jeffy.springdb.TeacherRowMapper;

public class TeacherDao{
	private JdbcTemplate jdbcTemplate;
	
	private String sql = "select count(*) from teacher where TH=?";
	private String sql_1= "select * from Teacher where TH=? and PASSWORD=?";
	private String sql_2 ="insert into teacher(TH,PASSWORD,XM,YX) values(?,?,?,?)";
	
	public boolean validate(Teacher tea){
		String th = tea.getTh();
		
		if( th.equals("") || th==null){
			return false;
		}
		
		Object[] ob = new Object[]{th};
		int nCount = 0;
		
		nCount = jdbcTemplate.queryForInt(sql,ob);
		
		if( nCount>0 ){
			return true;
		}else{
			return false;
		}		
	}
	
//	通过TH,PASSWORD把teacher读取出来
	public Teacher read(Teacher tea){
		String th = tea.getTh();
		String pd = tea.getPassword();
		Teacher t = null;
		
		if( th.equals("") || th==null || pd.equals("") || pd==null){
			return null;
		}
		
		List list = null;
		Iterator it = null;
		Object[] ob = new Object[]{th,pd};
		try{
			list = jdbcTemplate.query(sql_1,ob,new RowMapperResultReader(new TeacherRowMapper()));
			it = list.iterator();
			if( it.hasNext() ){
				t = (Teacher)it.next();
				return t;
			}else{
				return null;
			}
		}catch(Exception e){
			return null;
		}
	}
	
	//添加教师
	public boolean save(Teacher tea){
		String th = tea.getTh();
		String password = tea.getPassword();
		String yx = tea.getYx();
		
		if(th==null || password==null || yx==null){
			return false;
		}
		
		Object[] ob = new Object[]{th,password,tea.getXm(),yx};
		try{
			jdbcTemplate.update(sql_2,ob);
			return true;
		}catch(Exception e){
			return false;
		}
	}
	
	public JdbcTemplate getJdbcTemplate() {
		return jdbcTemplate;
	}

	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}
}