That is my code, if i put a updateQuery statement in there, then it updates my database, but when i query the database then it doesn't populate the resultset
Code:
public ResultSet User(String user)
{
ResultSet st = null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbConn = DriverManager.getConnection("jdbc:odbc:user");
statement = dbConn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
String sql = "Select user_id, user_name, user_password from user where user_name like '*"+user+"*'";
resultSet = statement.executeQuery(sql);
if(resultSet.next())
{
st = resultSet;
}
if(!resultSet.next())
{
String sqlAll = "Select * from user where user_name like '*"+user+"*'";
resultSet = statement.executeQuery(sqlAll);
st = resultSet;
}
}catch(ClassNotFoundException cf)
{
}catch(SQLException ex)
{
System.out.println(ex.toString());
}
return st;
}