admindaoimpl.java

房产交易平台 服务器端建议代码。工厂模型。

package com.fc.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.fc.dao.conn.DBConn;

public class AdminDaoImpl implements AdminDao {
	public AdminDaoImpl(){}
	
	/* (non-Javadoc)
	 * @see com.fc.dao.AdminDao#findByUname(java.lang.String)
	 */
	public Admin findByUname(String uname) {
		Admin u = null;
		Connection conn = null;
		conn = DBConn.getConnection();
		PreparedStatement prst = null;
		try {
			prst = conn
					.prepareStatement("select id,uname,password from admin where uname=?");
			prst.setString(1, uname);
			ResultSet rs = prst.executeQuery();
			u=new Admin();
			if (rs.next()) {
				u.setId(rs.getInt(1));
				u.setUname(rs.getString(2));
				u.setPassword(rs.getString(3));
			}
		} catch (SQLException ea) {
			ea.printStackTrace();
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return u;
	}
	
	/* (non-Javadoc)
	 * @see com.fc.dao.AdminDao#findById(int)
	 */
	public Admin findById(int id) {
		Admin u = new Admin();
		Connection conn = null;
		conn = DBConn.getConnection();
		PreparedStatement prst = null;
		try {
			prst = conn
					.prepareStatement("select id,uname,password from admin where id=?");
			prst.setLong(1, id);
			ResultSet rs = prst.executeQuery();
			if(rs.next()){
			u.setId(rs.getInt(1));
			u.setUname(rs.getString(2));
			u.setPassword(rs.getString(3));
			}
		} catch (SQLException ea) {
			ea.printStackTrace();
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return u;
	}
	
	
	/* (non-Javadoc)
	 * @see com.fc.dao.AdminDao#findAll()
	 */
	public List findAll() {
		List<Admin> list = new ArrayList<Admin>();
		Admin u = null;
		Connection conn = null;
		ResultSet rs = null;
		PreparedStatement prst = null;
		try {
			conn = DBConn.getConnection();
			prst = conn
					.prepareStatement("select id,uname,password from admin");
			rs = prst.executeQuery();
			while (rs.next()) {
				u=new Admin();
				u.setId(rs.getInt(1));
				u.setUname(rs.getString(2));
				u.setPassword(rs.getString(3));
				list.add(u);
			}
		} catch (SQLException ea) {
			ea.printStackTrace();
		} finally {
			if (conn != null)
				try {
					rs.close();
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return list;
	}
	
	/* (non-Javadoc)
	 * @see com.fc.dao.AdminDao#save(com.fc.dao.Admin)
	 */
	public boolean save(Admin u) {
		boolean ok = false;
		Connection conn = null;
		PreparedStatement prst = null;
		try {
			conn = DBConn.getConnection();
			prst = conn
					.prepareStatement("insert into admin(uname,password)values(?,?)");
			prst.setString(1, u.getUname());
			prst.setString(2, u.getPassword());
			prst.execute();
			ok = true;
		} catch (SQLException ea) {
			ea.printStackTrace();
			ok = false;
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return ok;
	}
	
	/* (non-Javadoc)
	 * @see com.fc.dao.AdminDao#modify(com.fc.dao.Admin)
	 */
	public boolean modify(Admin u) {
		boolean ok = false;
		Connection conn = null;
		PreparedStatement prst = null;
		try {
			conn = DBConn.getConnection();
			prst = conn
					.prepareStatement("update admin set password=? where id=?");
			prst.setString(1, u.getPassword());
			prst.setInt(2, u.getId());
			prst.execute();
			ok = true;
		} catch (SQLException ea) {
			ea.printStackTrace();
			ok = false;
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return ok;
	}

	
	/* (non-Javadoc)
	 * @see com.fc.dao.AdminDao#delete(com.fc.dao.Admin)
	 */
	public boolean delete(Admin u) {
		boolean ok = false;
		Connection conn = null;
		PreparedStatement prst = null;
		try {
			conn = DBConn.getConnection();
			prst = conn.prepareStatement("delete from admin where id=?");
			prst.setInt(1, u.getId());
			prst.execute();
			ok = true;
		} catch (SQLException ea) {
			ea.printStackTrace();
			ok = false;
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return ok;
	}
}