Java Reference
In-Depth Information
rs.updateString("haircolor", haircolor);
rs.updateRow();
}
else{
System.out.println("READ_ONLY");
status = "Update failed";
}
}catch(Exception e){
e.printStackTrace();
}
return status;
}
public byte[] getMemberData(){
String rootTag = "MemberInfo";
String SQLQuery = "SELECT i.*, "+
"m.list MUSIC, g.list GOING_OUT, f.list FOODS, "+
"ph.list SPORTS, p.list PERSONALITY, a.list
ACTIVITIES "+
"FROM personalinfo i, MUSIC m, goingout g, foods
f, "+
"physicalactivities ph, personality p, activities
a "+
"WHERE m.id = g.id AND m.id = f.id AND m.id =
ph.id AND "+
"m.id = p.id AND m.id = a.id AND m.id = i.id AND
"+
"m.id = '"+memberId+"';";
ByteArrayOutputStream os = new ByteArrayOutputStream();
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;
con = ds.getConnection(dbUserName,dbPassword);
stmt = con.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
