How to check if database credentials are correct in Java?

Question

I have these two methods. I can't seem to get it to work. The first method initializes the database connection and the second runs an other GUI after the log in procedure. I want to check if credentials are correct first before calling the GUI Class. Anybody has any suggestions on how I can achieve that?

    public void getDBConnection() throws SQLException{
    userid = usernameF.getText();
    password = passwordF.getText();
    OracleDataSource ds;
    ds = new OracleDataSource();
    ds.setURL(jdbcUrl);
    conn = ds.getConnection(userid,password);

    if(conn){
    System.out.println("Connected Successfully to Database. User: " + userid);
    }
    else {
        System.out.println("Wrong Data");
    }

}



    private void loginbox_actionPerformed(ActionEvent e) {


    try {
        getDBConnection();
    } 
    catch (SQLException f) {
        status.setText("INVALID USERNAME OR PASSWORD");
        }



    GUI guid = new GUI();
    guid.setVisible(true);
    guid.setDefaultCloseOperation( JFrame.EXIT_ON_CLOSE );

    System.out.println(userid + " " + password);


}

@BeginnerJava: programming terms like "database connection" and "GUI" are NOT code. Please stop incorrectly formatting them as code in suggested edits! — BalusC
– BalusC, Commented Sep 18, 2013 at 13:33

René Link · Accepted Answer · 2013-09-18 13:21:06Z

1

You can execute a statement that has no effect to see if a connection works.

// for example
select 1 from dual;

Connection pools use this strategy to check if a connection is valid before returning it.

See http://docs.oracle.com/cd/E13222_01/wls/docs81/ConsoleHelp/jdbc_connection_pools.html for a verify statement overview (Table 127-1 Default Test Table Name by DBMS).

edited Sep 18, 2013 at 13:21

answered Sep 18, 2013 at 13:16

René Link

52k15 gold badges119 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

frostmatthew · Accepted Answer · 2013-09-18 13:14:40Z

0

getConnection returns a java.sql.Connection, your if statement should be using the isValid method of that to see if it's connected so for example that line could be if (conn.isValid(5)) { (where 5 is the maximum number of seconds to wait)

answered Sep 18, 2013 at 13:14

frostmatthew

3,2964 gold badges44 silver badges53 bronze badges

Comments

Learner · Accepted Answer · 2013-09-18 13:15:50Z

0

Return true or false from getDBConnection() method on the basis of connection logic then use the value in login method and perform the action of activating GUI or not

answered Sep 18, 2013 at 13:15

Learner

2212 silver badges11 bronze badges

Collectives™ on Stack Overflow

How to check if database credentials are correct in Java?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related