usermanager.java

用户登录管理

package org.nitpro.business;

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

public class UserManager {
	private static String validate_test="select count(*)form test where uname=?and password=?";
	private static final String insert_test="insert into test(uname,password)values(?,?)";
	public boolean validate(String uname,String password)throws Exception{
		Connection con=null;
		DBUtility db=DBUtility.getInstance();
		try{
			con=db.getConnection();
			PreparedStatement stmt=con.prepareStatement(validate_test);
			stmt.setString(1, uname);
			stmt.setString(2, password);
			ResultSet rs=stmt.executeQuery();
			rs.next();
			int n=rs.getInt(1);
			if(n==1){
				return true;
			}else{
				return false;
			}
		}catch(Exception e){
			e.printStackTrace();
			throw e;
		}finally{
			db.closeConnection(con);
			}
		}
	public int insert(String uname,String password)throws Exception{
		Connection con=null;
		String strSql;
		int result=0;
		DBUtility db=DBUtility.getInstance();
		try{
			con=db.getConnection();
			PreparedStatement stmt=con.prepareStatement(insert_test);
			stmt.setString(1, uname);
			stmt.setString(2, password);
			result=stmt.executeUpdate();
		}
		catch(Exception ex){
			System.out.print(ex.getMessage());
		}
		finally{
			db.closeConnection(con);
		}
		return result;
			
		}
	}