Knowledgebase

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";

%>

<html>
<head>
<title>testServlet</title>
</head>
<body>
Attempting to open JDBC connection to:... <%=url%>
<%
try
{
// 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();
%>
 executing: <%=tableStr%>
<%
stat.executeUpdate( tableStr );
%>
 success.... 

<%
// close connection
con.close();
}

catch (SQLException sqle)
{ out.println(" Error opening JDBC, cause: " + sqle + ""); }

catch(ClassNotFoundException cnfe)
{ out.println(" Error opening JDBC, cause: " + cnfe + ""); }

%>
</body>
</html>

Add to Favourites

Print this Article