Expand|Select|Wrap|Line Numbers
- 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;
- }