Java Reference
In-Depth Information
private static String dbUserName = "sa";
private static String dbPassword = "dba";
private Connection con = null;
protected String username;
protected String password;
public LoginBean(){
}
public void setUsername(String username){
this.username = username;
}
public void setPassword(String password){
this.password = password;
}
public String getUsername(){
return username;
}
public String getPassword(){
return password;
}
public String validate(){
int id = -1;
String memberPwd = null;
try {
Class.forName("com.inet.pool.PoolDriver");
com.inet.tds.TdsDataSource tds = new com.inet.tds.TdsDataSource();
tds.setServerName( "JUPITER" );
tds.setDatabaseName( "MEMBERS" );
tds.setUser( dbUserName );
tds.setPassword( dbPassword );
DataSource ds = tds;
Connection con = ds.getConnection(dbUserName,dbPassword);
Statement stmt;
ResultSet rs = null;
String SQLQuery = "SELECT * FROM LOGIN WHERE UserName = '" +
username + "';"; // for clarity
stmt = con.createStatement();
rs = stmt.executeQuery(SQLQuery);
while(rs.next()){
