Accessing and retrieving data from a database is very simple.
First of all you need to add the DB driver(.jar) to your project. After that you can use below code.
In this example I am using mySql database.
//load DB driver
Class.forName("com.mysql.jdbc.Driver");
//this is the connection string
String connString
= "jdbc:mysql://localhost:3306/mydb?user=root&password=";
//Create connection
Connection con = DriverManager.getConnection(connString);
//Create a Statement object using connection
Statement statement = con.createStatement();
//Execute the SQL statement and get the results as a Resultset(Note that the name of the table is 'employee')
ResultSet resultSet = statement.executeQuery("select * from
employee");
//Now we can iterate through the resultSet
while(resultSet.next()){
//following method returns the value in Object type.
//'name_full' is the column name
Object o = resultSet.getObject("name_full");
System.out.println(o);
//following method returns the value in String type.
String s = resultSet.getString("name_full");
}
//Close the Statement object and Connection object.
statement.close();
con.close();
Note that you can remove above first two lines of the code and replace third line from below line to get the same result.
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "root", "");