admininfodao.java

java开发购物车+网上书城

package com.xaccp.aj3q8073.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.List;

import com.xaccp.aj3q8073.db.DBManager;
import com.xaccp.aj3q8073.db.RowMapper;
import com.xaccp.aj3q8073.vo.AdminInfoVo;

public class AdminInfoDao {
	DBManager db=new DBManager();
	
	/**
	 * 查询系统管理员信息
	 * @return
	 */
	public List execute(){
		String sql="select * from adminInfo";
		List list= db.queryForList(sql, null, new AdminMapper());
		return list;
	}
	
	/**
	 * 根据id查询要修改的管理员信息
	 * @param id
	 * @return
	 */
	public Object findAdminById(int id){
		String sql="select * from adminInfo where adminId=?";
		Object[] obj=new Object[]{id};
		Object jt=db.queryForObject(sql, obj, new AdminMapper());
		return jt;
	}
	
	/**
	 * 根据id修改管理员信息
	 * @param vo
	 * @return
	 */
	public int editAdmin(AdminInfoVo vo){
		String sql="update adminInfo set adminName=?,adminPwd=?,adminLevel=? where adminId=?";
		Object[] obj=new Object[]{vo.getAdminName(),vo.getAdminPwd(),vo.getAdminLevel(),vo.getAdminId()};
		int i=db.executeUpdate(sql, obj);
		return i;
	}
	
	/**
	 * 根据id删除管理员信息
	 * @param id
	 * @return
	 */
	public int delAdminById(int id){
		String sql="delete from adminInfo where adminId=?";
		Object[] obj=new Object[]{id};
		int i=db.executeUpdate(sql, obj);
		return i;
	}
	
	/**
	 * 添加管理员
	 * @param vo
	 * @return
	 */
	public int addAdmin(AdminInfoVo vo){
		String sql="insert into adminInfo values(default,?,?,?,sysdate())";
		Object[] obj=new Object[]{vo.getAdminName(),vo.getAdminPwd(),vo.getAdminLevel()};
		int i=db.executeUpdate(sql, obj);
		return i;
	}
	
	/**
	 * 管理员的登陆验证
	 * @param vo
	 * @return
	 */
	public Object loginTest(AdminInfoVo vo){
		String sql="select * from adminInfo where adminName=? and adminPwd=?";
		Object[] obj=new Object[]{vo.getAdminName(),vo.getAdminPwd()};
		Object jt= db.queryForObject(sql, obj, new AdminMapper());
		return jt;
	}
	
	class AdminMapper implements RowMapper
	{
		public Object rowMapper(ResultSet rt) throws SQLException {
			SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
			AdminInfoVo av=new AdminInfoVo();
			av.setAdminId(rt.getInt("adminId"));
			av.setAdminName(rt.getString("adminName"));
			av.setAdminPwd(rt.getString("adminPwd"));
			av.setAdminLevel(rt.getInt("adminLevel"));
			try {
				av.setAdminTime(sdf.parse(rt.getString("adminTime")));
			} catch (ParseException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			return av;
		}
	}
}