usermanager.java

bbs论坛系统

package struts.business;

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

public class UserManager {
	
    private static final String validate_classuser="Select * from usertable where name=? and password=?";
	private static final String insert_classuser="insert into usertable(name,password,sex,email,qq,address) 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_classuser);
			stmt.setString(1,uname);
			stmt.setString(2,password);
			ResultSet rs=stmt.executeQuery();
			if(rs.next())
			{
				//int n=rs.getInt(1);
				//System.out.print(n);
				return true;
			}
			else
			{
				return false;
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
			throw e;
		}
		finally
		{
			db.closeConnection(con);
		}
	}
	public int insert(String name,String password,String sex,
			String email,String qq,String address ) throws Exception 
	{
		Connection con=null;
		String strSql;
		int result=0;
		DBUtility db=DBUtility.getInstance();
		try
		{
			con=db.getConnection();
			PreparedStatement stmt=con.prepareStatement(insert_classuser);
			stmt.setString(1, name);
			stmt.setString(2, password);
			stmt.setString(3, sex);
			stmt.setString(4, email);
			stmt.setString(5, qq);
			stmt.setString(6, address);
							
			result=stmt.executeUpdate();
		}
		catch(Exception e)
		{
			System.out.println(e.getMessage());
		}
		finally
		{
			db.closeConnection(con);
		}
		return result;
	}
	
	public static void main(String args[])
	{
		try{
			 UserManager um=new UserManager();
			 boolean c=um.validate("zhaoxiaobing", "1");
			 //int b=um.insert("xb","44","male","[e-mail]","1234567","shanxichangzhi");
			System.out.print(c);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
	}
   

}