admindao.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.Admin;
import bit.jeffy.springdb.AdminRowMapper;

public class AdminDao{
	
	private JdbcTemplate jdbcTemplate;
	
	private String sql_1 ="select * from Admin where ADMIN_NO=? and PASSWORD=?";
	
	//通过admin_no把admin读取出来
	public Admin read(Admin admin){
		String admin_no = admin.getAdmin_no();
		String pd = admin.getPassword();
		Admin ad = null;
		
		if( admin_no.equals("") || admin_no==null || pd.equals("") || pd==null){
			return null;
		}
		
		List list = null;
		Iterator it = null;
		Object[] ob = new Object[]{admin_no,pd};
		try{
			list = jdbcTemplate.query(sql_1,ob,new RowMapperResultReader(new AdminRowMapper()));
			it = list.iterator();
			if( it.hasNext() ){
				ad = (Admin)it.next();
				return ad;
			}else{
				return null;
			}
		}catch(Exception e){
			return null;
		}
	}
	
	public JdbcTemplate getJdbcTemplate() {
		return jdbcTemplate;
	}
	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}
}