This doesnt give a resultSet but it updates the db

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sl1ver
    New Member
    • Mar 2009
    • 196

    #1

    This doesnt give a resultSet but it updates the db

    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;
        }
Working...