You can study and implement the following examples to create a simple Java-based database-driven web application which makes use of JSP and Servlets applying a MVC (model-view-controller) principle.
Create the following files:
DatabaseConnection.java
package sample;
import java.sql.*;
public class DatabaseConnection {
public static Connection getConnection() {
Connection con = null;
try {
// change the following line to your jdbc driver
Class.forName("com.borland.datastore.jdbc.DataStoreDriver");
// change this to "your database url", "username", "password"
con = DriverManager.getConnection("jdbc:borland:dslocal:C:\\a.jds","Sample","");
System.out.println(con);
}
catch (Exception ex) {
ex.printStackTrace();
}
return con;
}
}