dusers.java

java sql jsp javabean

package com.gc.dao;

import com.gc.action.Users;
import com.gc.impl.IUsers;
import java.sql.*;

public class DUsers implements IUsers{
	private Connection con = null;
	private PreparedStatement pre = null;
	private ResultSet rs = null;
	
	public boolean isUsers(String account,String password) 
	{
		boolean user = false;
		try
		{
			dao d = new dao();
			this.con = d.getCon();
			if(con != null)
			{
				pre = con.prepareStatement("select * from Users where UAccount='"+account+"' and UPassword='"+password+"'");
				rs = pre.executeQuery();
				while(rs.next())
				{
					user = true;
				}
			}
			rs.close();
			pre.close();
			con.close();
		}catch(Exception ex)
		{
			ex.printStackTrace();
		}
		return user;
	}
	/**
	 * 添加用户信息
	 */
	public boolean addUsers(Users users) {
		int count = 0;
		try
		{
			dao d = new dao();
			con = d.getCon();
			if(con!=null)
			{
				pre = con.prepareStatement("insert into Users(UAccount,UPassword,UName) values(?,?,?)");
				pre.setString(1, users.getAccount());
				pre.setString(2, users.getUpassword());
				pre.setString(3, users.getUname());
				count = pre.executeUpdate();
			}
			pre.close();
			con.close();
			con.close();
		}catch(Exception e)
		{
			e.printStackTrace();
		}
		if(count>0)
		{
			return true;
		}else
		{
			return false;
		}
	}
	public boolean isExistUsers(String account) {
		boolean user = false;
		try
		{
			dao d = new dao();
			this.con = d.getCon();
			if(con != null)
			{
				pre = con.prepareStatement("select * from Users where UAccount='"+account+"'");
				rs = pre.executeQuery();
				while(rs.next())
				{
					user = true;
				}
			}
			rs.close();
			pre.close();
			con.close();
		}catch(Exception ex)
		{
			ex.printStackTrace();
		}
		return user;
	}
}