|
Connect jsp <> mysql
Example
Please make sure that you have created
database through the control panel and that you have setup
password for db. Write down your database name - this is
very important !
Instructions for database set up available
in your initial account activation email titled " MySQL
Set Up Instructions"
After this steps, edit dbtest.jsp and
enter correct informations, upload this two files and test
them
This is an example with org.gjt.mm.mysql.Driver
MySQL driver. We also support com.mysql.jdbc.Driver
--------------------------------------------------------------------------------
File 1: dbtest.jsp
<%
String dbhost1 = request.getParameter("dbhost");
String dbname1 = request.getParameter("dbname");
String user1 = request.getParameter("user");
String pass1 = request.getParameter("pass");
if( dbhost1==null )
dbhost1="localhost";
if( dbname1==null )
dbname1="ENTER=HERE-YOUR-DB-NAME";
if( user1==null)
user1="YOUR-USER-NAME";
if( pass1==null )
pass1="MYSQL-PASSWORD";
%>
<form action="dbsubmit.jsp"
method=get>
<table>
<tr>
<td>dbhost
<td><input size=60 name="dbhost" type=text
value="<%=dbhost1%>">
<tr>
<td>dbname
<td><input size=60 name="dbname" type=text
value="<%=dbname1%>">
<tr>
<td>user
<td><input name="user" type=text value="<%=user1%>">
<tr>
<td>password
<td><input name="pass" type=text value="<%=pass1%>">
<tr>
<td colspan="2">
<input type=submit>
</table>
</form>
------------------------------------End
of dbtest.jsp
--------------------------------------------------------------------------------
File 2 - dbsubmit.jsp
<%
String dbhost = request.getParameter("dbhost");
String dbname = request.getParameter("dbname");
String user = request.getParameter("user");
String pass = request.getParameter("pass");
String connURL =
"jdbc:mysql://"+dbhost+"/"+dbname+"?user="+user+"&password="+pass;
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
java.sql.Connection conn = java.sql.DriverManager.getConnection(connURL);
response.getWriter().println("<font color=green><b>");
response.getWriter().println("Connection success!!!");
response.getWriter().println("</b></font>");
}
catch(Exception e)
{
response.getWriter().println("<font color=red><b>[");
response.getWriter().println(e.getMessage());
response.getWriter().println("]<br>");
response.getWriter().println("Connection URL:["+connURL+"]");
response.getWriter().println("</b></font>");
}
%>
<%@include file="dbtest.jsp"%>
--------------------------------End of dbsubmit.jsp
|
