18
Hi every one
i am a beginner..........
i installed xampp in my computer.(php+mysql) i wrritten a code below.
but it generate a error class not found.
can i connect my servlets with mysql which i installed with xampp?
//import javax.sql.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
public class Registration extends HttpServlet
{
private ServletContext application;
public void init(ServletConfig config) throws ServletException
{
super.init(config);
application= config.getServletContext();
}
public void doPost(HttpServletRequest req , HttpServletResponse res) throws ServletException,IOException
{
try
{
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";
String dbName = "mis";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String pass = "";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url+dbName,userNam e,password);
PreparedStatement pstat=con.prepareStatement("insert into registration values(?,?)");
String firstname=req.getParameter("username");
String password=req.getParameter("password");
pstat.setString(1,firstname);
pstat.setString(2,password);
int inser=pstat.executeUpdate();
if(inser==1)
{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
out.println("<html>");
out.println("<body>");
out.println("<b>Please Wait.......</b>");
out.println("</body>");
out.println("</html>");
res.setHeader("Refresh","5;URL= http://localhost:8000/musicsworld/jsp/RegistrationSuccess.jsp");
// The code i written below works well but after disscussion i am going to display this result through jsp
/* res.setContentType("text/html");
PrintWriter out=res.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>www.MusicsInc.com</title>");
out.println("</head>");
out.println("<body bgcolor=Tan>");
out.println("<img src=\"C:/j2sdkee1.2.1/public_html/musicsworld/img/rohit.jpg\">");
out.println("<br>");
out.println("<font face=arial color=#cc3333>Thank you for Registration in our web site</font>");
out.println("<p align=Left><b><font face=arial color=#cc3333 size=6>Congratulation ! on Successful Registration.....</font></b></p>");
out.println("<h3><font face=arial color=red>This site is Greate for fun and Masti. We hope You will Enjoy with it. Please Remember Your Id and password for Login.Our Private Policy Terms $ Condition Restrices Unauthories access of any Account.</h3>");
out.println("<h3><font face=arial color=red>Here your Id will your Name which you entered in Registration Form.</h3>");
out.println("<hr height= width= color=gray>");
out.println("</body>");
out.println("</html>"); */
}
}
catch(Exception e)
{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>www.MusicsInc.com</title>");
out.println("</head>");
out.println("<body bgcolor=Tan>");
out.println("<b>Your Request Failed Transaction Has Not Done</b>");
out.println("<br>");
out.println("<b>Error in connectivity...............</b>");
out.println(e);
out.println("<br>");
out.println("<b>Please Carefully Fillup Your Registration Form Filling Values Must Match As Accordidng TO Requirements...</b>");
out.println("<br>");
out.println("Remote Address: " + req.getRemoteAddr());
out.println("<br>");
out.println("PathInfo: " + req.getPathInfo());
out.println("<br>");
out.println("Protocol: " + req.getProtocol());
out.println("<br>");
out.println("Protocol: " + req.getAuthType());
out.println("<br><br><br><br>");
out.println("<hr height=600 width=400 color=gray>");
out.println("</body>");
out.println("</html>");
}
}
}
