userdao.java

servletjspjavabean的注册登陆模块

package com.dct.dao;

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

import com.dct.util.DBUtil;
import com.dct.vo.User;

public class UserDao {
	
	
	public User login(String username,String userpwd){
		
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		
		User user = new User();
		
		try{
			
			conn = DBUtil.getConn();
			pstmt = conn.prepareStatement("select * from userinfo where username= ? and userpwd= ? ");
			pstmt.setString(1, username);
			pstmt.setString(2, userpwd);
			rs = pstmt.executeQuery();
			while(rs.next()){
				user.setUsername(rs.getString("username"));
				user.setUserpwd(rs.getString("userpwd"));
				user.setUrid(rs.getInt("urid"));
			}
			
		}catch(Exception ex){
			ex.printStackTrace();
		}finally{
			DBUtil.closeAll(conn, pstmt, rs);
		}
		
		return user;
		
	}
	
	public boolean insert(User user){
		
		
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		boolean flag = false;
		int count = 0;
		try{
			
			conn = DBUtil.getConn();
			pstmt = conn.prepareStatement("insert userinfo values(?,?,?)");
			pstmt.setString(1, user.getUsername());
			pstmt.setString(2, user.getUserpwd());
			pstmt.setInt(3, user.getUrid());
			count = pstmt.executeUpdate();
			
		}catch(Exception ex){
			ex.printStackTrace();
		}finally{
			DBUtil.closeAll(conn, pstmt, rs);
		}
		
		return flag = (count>0?true:false);
	}
	
}