|
This section shows you how to create a MySQL database by using Webconexion's Asparagus hosting control panel and how to connect to it using JSP JDBC.
Step 1 - Creating a MySQL database
Log into the Asparagus hosting control panel via the members area, select "Web Tools" then "MySQL Databases". Enter a database username and password of your choice, the database name will be your username with "db" appended to it, so if you created a database called "amazon" your database name would be "amazondb".
Step 2 - Connecting to MySQL using JSP and JDBC
Once you've successfully created your database can you connect to it using JSP via JDBC using the following connection example. Change the connection parameters in red to the ones you've chosen in Step 1.
<%@ page import="java.sql.*"%>
<html>
<head>
<title>JDBC Connection example</title>
</head>
<body>
<h1>JDBC Connection example</h1>
<%
java.sql.Connection cn;
Class.forName("org.gjt.mm.mysql.Driver");
cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/database_name", "database_username", "database_password");
%>
</body>
</html>
 Technical Support
| 
Connecting to MySQL using JSP and JDBC
UK domains £3.25 p/a
Map multiple domains to your web hosting account for the one time fee of £29.99 per domain!