How to connect to MySQL with JSP/JDBC?

<%@ page import="java.sql.*" %>
<%@ page import="com.mysql.jdbc.Driver" %>

// mysql driver
String driver = "com.mysql.jdbc.Driver";

// the "url" to our DB, the last part is the name of the DB
String url = "jdbc:mysql://localhost/DBname";

// the default DB username and password may be the same as your control panel login

String name = "Username";
String pass = "Password";


<p>Attempting to open JDBC connection to:... </p> <%=url%>
// Test the DB connection by making an empty table
String tableStr = "CREATE.....table test (testid mediumint(8), name varchar(100))";
Class.forName( driver );

// initialize the Connection, with our DB info ...
Connection con = DriverManager.getConnection( url, name, pass );

Statement stat = con.createStatement();
<p> executing: <%=tableStr%></p>
stat.executeUpdate( tableStr );
<p> success.... </p>

// close connection

catch (SQLException sqle)
{ out.println("<p> Error opening JDBC, cause:</p> <b> " + sqle + "</b>"); }

catch(ClassNotFoundException cnfe)
{ out.println("<p> Error opening JDBC, cause:</p> <b>" + cnfe + "</b>"); }


Was this answer helpful?

 Print this Article

Also Read

Can I use Struts?

Yes. You can use Struts by uploading the Struts libraries /WEB-INF/lib. There's nothing extra...

How do I stop/start my tomcat server?

You have to open up support ticket in Technical department, requesting for tomcat...

Deploying JSPs & Servlets

JSP & Servlet Operation cPanel (with the mod_jk module) has JSP and servlet functionality...