Home Jsp Connect JSP with mysql



Connect JSP with mysql
Posted on: July 4, 2008 at 12:00 AM
In this example we will show you how to connect to MySQL database from your JSP code.

Connect JSP with mysql

        

In this example we will show you how to connect to MySQL database from your JSP code. First, you need to create database and then write jsp code to connect jsp to database.

1. Create a database: 

First create a database named usermaster in mysql. Before running the jsp code you need to paste mySqlConnector.jar in lib directory of jdk.

mysql> create database usermaster;
(This query create database in my sql command prompt)

2. Connect JSP with mysql:  

Here is the jsp code.

ConnectJspToMysql.jsp

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
"http://www.w3.org/TR/html4/loose.dtd"> 

<%@ page import="java.sql.*" %> 
<%@ page import="java.io.*" %> 

<html> 
<head> 
<title>Connection with mysql database</title> 
</head> 
<body>
<h1>Connection status </h1>
<% 
try {
/* Create string of connection url within specified format with machine name, 
port number and database name. Here machine name id localhost and 
database name is usermaster. */
 
String connectionURL = "jdbc:mysql://localhost:3306/usermaster"; 

// declare a connection by using Connection interface 
Connection connection = null; 

// Load JBBC driver "com.mysql.jdbc.Driver" 
Class.forName("com.mysql.jdbc.Driver").newInstance(); 

/* Create a connection by using getConnection() method that takes parameters of 
string type connection url, user name and password to connect to database. */ 

connection = DriverManager.getConnection(connectionURL, "root", "root");

// check weather connection is established or not by isClosed() method 
if(!connection.isClosed())
%>
<font size="+3" color="green"></b>
<% 
out.println("Successfully connected to " + "MySQL server using TCP/IP...");
connection.close();
}
catch(Exception ex){
%>
</font>
<font size="+3" color="red"></b>
<%
out.println("Unable to connect to database.");
}
%>
</font>
</body> 
</html>

Output: 
Output of the program when connection is established with specified mysql database :

Output of the program when unable to connect to specified MySQL database :

Download source code

Related Tags for Connect JSP with mysql:
sqlmysqlcdatabasejspdatathiswritecreatetabjsconnectshowexampletobaseexamsheilitfromfirstinasmjasehowxaxampsspeeatmyisirllmpleaandcodcodessrithshostabpleplndodeonomo


More Tutorials from this section

Ask Questions?    Discuss: Connect JSP with mysql   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.