how to connect jsp to mysql

View Answers

June 4, 2008 at 7:27 PM

Hi ragini,

This is form code ,

<html>
<head>
<title>Insert into database</title>

</head>

<body>

<table border="1" width="50%" bgcolor="pink" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<form method="POST" action="/examples/jsp/LoginAction" >

<h2 align="center">login page</h2>
<table border="1" width="100%">
<tr>
<td width="50%"><b>User Name:</b></td>
<td width="50%"><input type="text" name="userid" size="20"/></td>
</tr>
<tr>
<td width="50%"><b>Password:</b></td>
<td width="50%"><input type="password" name="password" size="20"/> </td>
</tr>

</table>
<p><input type="submit" value="Submit" name="submit">
<input type="reset" value="Reset" name="reset"></p>

</form>
</td>
</tr>
</table>

</body>
</html>

--------------------------------

web.xml

<servlet>
<servlet-name>loginaction</servlet-name>
<servlet-class>javacode.LoginAction</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>loginaction</servlet-name>
<url-pattern>/jsp/LoginAction</url-pattern>
</servlet-mapping>

June 4, 2008 at 7:29 PM

This is servlets code,

package javacode;

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class LoginAction extends HttpServlet {
private Connection con;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";
public void init()throws ServletException {
System.out.println("INIT");
try {
Class.forName(driver);
con=DriverManager.getConnection(url+db,userName,password);
}//try
catch(Exception e){
e.printStackTrace();
throw new ServletException("unable to get database cooenction.");
}//catch

}//init
public void doGet(HttpServletRequest req,HttpServletResponse res)throws IOException,ServletException {

System.out.println("in service");
res.setContentType("text/html");
PrintWriter out=res.getWriter();
PreparedStatement ps=null;
try{
String userid=req.getParameter("userid");
String pass=req.getParameter("password");
if(userid==null||userid.equals("")||pass==null||pass.equals("")){
out.println("<html><body>");
out.println("<i>UserName/Password are empty,they cannot be empty </i>");
out.println("</body></html>");
return;
}//if
ps=con.prepareStatement("select * from login where userid=? and password=?");
ps.setString(1,userid);
ps.setString(2,pass);
ResultSet rs=ps.executeQuery();
out.println("<html><body>");
if(rs.next())
out.println("Successfully login");
else
out.println("username and password not currect, please try again.");
out.println("</body></html>");
}//try
catch(Exception e){
out.println("unable to process the request please try later");
}//catch
finally {
try{
ps.close();
}
catch(Exception e) {}
}//finally
}//doget
public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException,
IOException {
doGet(req, res);
}
public void destroy() {
System.out.println("In destroy");
try {
con.close();
}
catch(Exception e) {
System.out.println(e);
}
}//destroy
}

------------------------------------------------

Read for more information.

http://www.roseindia.net/servlets

Thanks

Ads