MySQL - Conectar con jsp

Tengo varias dudas quiero conectar Mysql con una pagina de jsp, ya me baje el driver de jdbc, cree las tablas tengo mysqlfront y el siguiente codigo de ejemplo:

import java.io.*;
import java.sql.*;

public class EjemploSQL{
public static void main(String[] args) throws IOException {

ResultSet result;
ResultSetMetaData rsmd;
Connection con=null;
Statement stmt=null;
String server;
String user;
String password;
String database;
String query;

try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
}
catch (Exception e) {
System.out.println("Error instanciando clase (revisar CLASSPATH)");
System.exit(1);
}
System.out.print("MySQL Server: ");
server = (new BufferedReader (new InputStreamReader(new BufferedInputStream(System.in))).readLine());
System.out.print("Database: ");
database = (new BufferedReader (new InputStreamReader(new BufferedInputStream(System.in))).readLine());
System.out.print("Login: ");
user = (new BufferedReader (new InputStreamReader(new BufferedInputStream(System.in))).readLine());
System.out.print("Password: ");
password = (new BufferedReader (new InputStreamReader(new BufferedInputStream(System.in))).readLine());
String url = "jdbc:mysql://"+server+":3306/"+database+"?user%3