user.java

网上购书系统 采用jsp+servlet+sql2000

package bean;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


public class User {
	private String username;
	private String password;
	
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}

	public boolean validate(){
		boolean validation=false;
		try{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=bookshop";
			String user="sa";
			String pwd="sa";
			Connection conn=DriverManager.getConnection(url,user,pwd);
			Statement stat=conn.createStatement();
			String sql="select * from book_user where username='"+username+"' and password='"+password+"'";
			ResultSet rest=stat.executeQuery(sql);
			if(rest.next()){
				validation=true;
			}
		}catch(Exception ex){
			ex.printStackTrace();
		}finally{
			
		}
		return validation;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
}