user.java

Eclipse 3.1 下编写。自己编写

package vo;

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

import util.DB;

public class User {
	private String name , password;

	public User(){
		
	}
	public User(String name , String password){
		this.name = name;
		this.password = password;
	}
	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}
	
	public boolean userCheck(String name,String password){
		boolean isUser = false;
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		DB db = new DB();
		
		try {
			ps = con.prepareStatement("select * from user");
			rs = ps.executeQuery();
			while(rs.next()){
				String db_name = rs.getString("name");
				String db_password = rs.getString("password");
				if (db_name.equals(name) && db_password.equals(password)){
					isUser = true ;
					break;
				}else{
					isUser = false;
				}
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return isUser;
	}
	
	public static void main(String[] args){
		
	}
	
}