How to change IP and PORT of Java Database Connection class dynamically?

Question

I have created a Java class for connecting to the MySQL database for my Java SWING Application.

public class DB1 {

private static Connection c;

public static Connection getMyConnection() throws Exception {
    if (c == null) {
        JTextField myUserNameTextField = new JTextField();
        JTextField myPasswordTextField = new JTextField();
        JTextField myIPTextField = new JTextField();
        JTextField myPortTextField = new JTextField();
        String myUserName = myUserNameTextField.getText();
        String myPassword = myPasswordTextField.getText();
        String myURL = "jdbc:mysql:// " + myIPTextField.getText() + ":" + myPortTextField.getText() + "/DBName";

        Class.forName("com.mysql.jdbc.Driver");

        c = DriverManager.getConnection(myURL, myUserName, myPassword);
    }
    return c;

}

public static void InsertEditDelete(String sql) throws Exception {
    getMyConnection().createStatement().executeUpdate(sql);
}

public static ResultSet Search(String sql) throws Exception {
    return getMyConnection().createStatement().executeQuery(sql);
}
}

I want to dynamically change the IP , which is localhost here and the port number from Jtextfields , so u do not recompile every time u change the IP and PORT number. These JTextfields should get opened up in a JFRAME

I created my class according what you told me. Now how do I get to display Jtextfields to enter the details. These details should also get saved in the class. — wishman
– wishman, Commented Feb 11, 2012 at 10:39
one time you are saying you want to take hostname and port from textfield and another time you are saying you want to access from table... please clear question... re-iterate your question again.... — Fahim Parkar
– Fahim Parkar, Commented Feb 11, 2012 at 10:45
Sorry, I just want to change it using JTextFields. I want these textfields to open in a frame. — wishman
– wishman, Commented Feb 11, 2012 at 10:51

Fahim Parkar · Accepted Answer · 2012-02-11 11:00:37Z

2

ResultSet rs = st.executeQuery("SELECT username, password, host, port FROM  myAllData where id=1");

String myURL = "jdbc:mysql:// " + rs.getString("host") + ":" + rs.getString("port") + "/DBName"
String myUserName = rs.getString("username");
String myPassword = rs.getString("password");

Class.forName("com.mysql.jdbc.Driver");

c = DriverManager.getConnection(myURL, myUserName, myPassword);

Update 1

If you need JTextField use below.

String myUserName = myUserNameTextField.getText();
String myPassword = myPasswordTextField.getText();
String myURL = "jdbc:mysql:// " + myIPTextField.getText() + ":" + myPortTextField.getText() + "/DBName"

Class.forName("com.mysql.jdbc.Driver");

c = DriverManager.getConnection(myURL, myUserName, myPassword);

Good Luck!!!

edited Feb 11, 2012 at 11:00

answered Feb 11, 2012 at 10:11

Fahim Parkar

31.8k46 gold badges168 silver badges285 bronze badges

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

1 Comment

wishman Over a year ago

OK Thanks I get it. But I want to change the values in Strings by entering into a JRAME or something like that. I can't edit the class every time. Basically, I have developed a SWING application. So I want a JRAME which has JTexfields, which will change the values of the DB Class I have created above on a button click event.

aleroot · Accepted Answer · 2012-02-11 09:44:56Z

1

Something like this should be what you want :

String host = textFieldHost.getText();
String port = textFieldPort.getText();

DriverManager.getConnection(String.format("jdbc:mysql://%s:%s/DBName",host,port), "root", "123");

answered Feb 11, 2012 at 9:44

aleroot

73k32 gold badges182 silver badges220 bronze badges

Comments

darek · Accepted Answer · 2012-02-11 09:45:12Z

1

You can put this settings into .properties or XML file, and then read it when needed.

This link should Help

http://docs.oracle.com/javase/6/docs/api/java/util/Properties.html

answered Feb 11, 2012 at 9:45

darek

3011 silver badge9 bronze badges

Comments

Heiko Rupp · Accepted Answer · 2012-02-11 09:44:00Z

0

Just use some string concatenation

String host = ...
int port = ...
String jdbcurl = "jdbc:mysql://" + host + ":" + port + "/DBName";
DriverManager.getConnection(jdbcurl,"root","123");

answered Feb 11, 2012 at 9:44

Heiko Rupp

31.1k13 gold badges86 silver badges120 bronze badges

3 Comments

wishman Over a year ago

Cant I store the host and port in mySQL database, and retrieve it using a resultset?

Heiko Rupp Over a year ago

And how do you first access the database when you want to first retrieve host and port from there?

wishman Over a year ago

Yes you are right! I cannot access the database when my IP and HOST are changed.

Collectives™ on Stack Overflow

How to change IP and PORT of Java Database Connection class dynamically?

4 Answers 4

Update 1

Good Luck!!!

1 Comment

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Update 1

Good Luck!!!

1 Comment

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related