Java Reference
In-Depth Information
boolean username_selection_ok = true;
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);
CallableStatement cs = con.prepareCall("{call
GET_LOGIN_FOR_USER(?)}");
cs.setString(1,username);
ResultSet rs = cs.executeQuery();
ResultSetMetaData md = rs.getMetaData();
int id = -1;
while(rs.next()){
id = rs.getInt("MemberID");
}
if(id>=0){
System.out.println(id+": "+username+"; "+password);
username_selection_ok = false;
}else{
cs = con.prepareCall("{call SET_LOGIN_FOR_USER(?,?)}");
cs.setString(1,username);
cs.setString(2,password);
if(cs.executeUpdate()!=1) username_selection_ok = false;
cs = con.prepareCall("{call GET_LOGIN_FOR_USER(?)}");
cs.setString(1,username);
rs = cs.executeQuery();
while(rs.next()){
id = rs.getInt("MemberID");
}
cs = con.prepareCall("{call
