userdao.java

实现一个简易的租房系统

package com.wepull.zf.dao.jdbcImpl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.wepull.zf.dao.IUserDAO;
import com.wepull.zf.entity.User;

public class UserDAO implements IUserDAO {
	
	
	private Connection con;
	

	public UserDAO(Connection con) {
		super();
		this.con = con;
	}

	public User doRegister(User user) {
		
		try {
			PreparedStatement ps=con.prepareStatement("insert into TBL_USER(uname,upass) values(?,?)");
			ps.setString(1, user.getUname());
			ps.setString(2, user.getUpass());
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return user;
	}

	public User doLogin(User user) {
		try {
			PreparedStatement ps=con.prepareStatement("select * from TBL_USER where uname=? and upass=?");
			ps.setString(1, user.getUname());
			ps.setString(2, user.getUpass());
			ResultSet rs=ps.executeQuery();
			if(rs.next()){
				user.setUid(rs.getInt("uid"));
				return user;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return null;
	}

}