usersutil.java

使用servlet写的简单网上书店

package utils;

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

import entity.Users;

public class UsersUtil {
	private Connection con;
	private PreparedStatement ps;

	public UsersUtil(Connection con) {
		this.con = con;
	}
	
	public boolean findUser(String name,String password){
		boolean isValid = false;
		try {
			ps=con.prepareStatement("select count(*) as num from users where username=? and password=?");
			ps.setString(1, name);
			ps.setString(2, password);
			ResultSet rs=ps.executeQuery();
			if(rs.next()&&rs.getInt(1)==1){
				isValid=true;
			}
			rs.close();
			ps.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return isValid;
	}
	
	public boolean register(Users user){
		boolean isSuccess=false;
		try {
			ps=con.prepareStatement("insert into users values(?,?,?)");
			ps.setInt(1, user.getId());
			ps.setString(2, user.getUsername());
			ps.setString(3, user.getPassword());
			ps.execute();
			
			ps.close();
			
			isSuccess=true;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally{
			if(ps!=null){
				try {
					ps.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		return isSuccess;
	}
}