Desktop application and DB connection

Question

Lets say I have desktop application with simple login - here, in this part i have to create Connection, prepared statement which compares username and password. I use cardlayout- and for example, on another card (JPanel) i have JTable and JButton which retrieves values from SQL table to my JTable.... on third JPanel i have for example fields for name and password - using for new employee - he will give his name and password - after button click data will be inserted to DB

Now my Question: How does it work in real application? Shall I make one static method (e.g. getDBConnection()) which will create connection (first for login - after login close connection, then create another connection when i want to select from DB then close it and again if i want to insert something?) `

or how to do it in smarter/ proper way?

stackoverflow.com/questions/2835090/jdbc-connection-pooling

GriffeyDog
– GriffeyDog

2014-03-10 18:33:16 +00:00
Commented Mar 10, 2014 at 18:33 — GriffeyDog
– GriffeyDog, Commented Mar 10, 2014 at 18:33

Sandeep Chatterjee · Accepted Answer · 2014-03-10 18:46:47Z

1

You can write a properties file specific to your application and write a class to load it.

`MyDatabaseProperties.properties`

database.jdbc.url = jdbc:mysql://localhost:3306/database
database.jdbc.driver = "com.mysql.jdbc.Driver"
database.jdbc.username = "USERNAME"
database.jdbc.password = "PASSWORD"

Properties.java:

public class Properties {
    private static final String PROPERTIES_FILE = "MyDatabaseProperties.properties";
    private static final Properties PROPERTIES = new Properties();

    static {
        try {
            PROPERTIES.load(new FileInputStream("MyDatabaseProperties.properties"));
        } catch (IOException e) {
            // THROW YOUR EXCEPTION HERE.
        }
    }
}

You will find an excellent material on this subject here.

answered Mar 10, 2014 at 18:46

Sandeep Chatterjee

3,2489 gold badges34 silver badges52 bronze badges

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

Comments

hlfernandez · Accepted Answer · 2014-03-10 18:34:28Z

0

You can create a DAO (Data Access Object) to access the table Employee, named DAOEmployee for instance (note that this class will contain methods such as addEmployee, removeEmployee, getEmployees). Then, you can have a class (DataBaseConfiguration), responsible of returning the connection to the database (using a static method, for instance).

answered Mar 10, 2014 at 18:34

hlfernandez

4531 gold badge3 silver badges11 bronze badges

Collectives™ on Stack Overflow

Desktop application and DB connection

2 Answers 2

`MyDatabaseProperties.properties`

Properties.java:

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

MyDatabaseProperties.properties

Properties.java:

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related

`MyDatabaseProperties.properties`