Re: Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql:// localhost:3306/karthicraj","mysql","mysql");
Dear friend
first you add MySql Jar file .
Steps in My Eclips 5.01
1- Right click in your project
2-Select Built Path
3- then selct Add External Archive
4- D:\Program Files\MySQL\MySQL Tools for 5.0\java\lib
select jar file..
finish now you may add jar file...
Check this in ur code:-
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/karthicraj","mysql","mysql");
then u run it will give result
Same code:
----------
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.sql.Connection.*;
public class EmpDetail extends HttpServlet
{
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws IOException,ServletException
{
Connection con;
Statement stm;
PreparedStatement pstm;
String s1=request.getParameter("s1");
String s2=request.getParameter("s2");
String s3=request.getParameter("s3");
PrintWriter pw=response.getWriter();
String name=request.getParameter("name");
int age=Integer.parseInt(request.getParameter("age"));
int salary=Integer.parseInt(request.getParameter("salary"));
pw.println("<HTML>");
pw.println("<BODY>");
if(s1!=null)
{
try
{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/karthicraj","mysql","mysql");
System.out.println ("Database connection established");
System.out.println("hi");
stm=con.createStatement();
String strQry="Insert into ram(name,age,salary)values(?,?,?)";
pstm=con.prepareStatement("Insert into ram(name,age,salary)values(?,?,?)");
System.out.println("Ready for Insert");
pstm.setString(1,name);
pstm.setInt(2,age);
pstm.setInt(3,salary);
pstm.executeUpdate();
System.out.println("Updated");
pstm.close();
con.close();
pw.println("thank u for Inserting data");
RequestDispatcher dispatcher = request.getRequestDispatcher("EmpDetail.html");
dispatcher.include(request, response);
}
catch(ClassNotFoundException e)
{
pw.println(e);
}
catch(SQLException e)
{
pw.println(e);
}
}
else if(s2!=null)
{
try
{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/karthicraj","mysql","mysql");
System.out.println("connection success 1");
stm=con.createStatement();
String strQry="update ram set age=?,salary=? where name=? "; // and age=?";
pstm=con.prepareStatement(strQry);
pstm.setInt(1,age);
pstm.setInt(2,salary);
pstm.setString(3,name);
//pstm.setInt(4,age);
pstm.executeUpdate();
pstm.close();
con.close();
pw.println("thank u for updating data");
RequestDispatcher dispatcher = request.getRequestDispatcher("EmpDetail.html");
dispatcher.include(request, response);
}
catch(ClassNotFoundException e)
{
pw.println(e);
}
catch(SQLException e)
{
pw.println(e);
}
}
else
{
try
{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/karthicraj","mysql","mysql");
stm=con.createStatement();
stm.executeUpdate("delete from ram where name='"+name+"' and age="+age);
stm.close();
con.close();
pw.println("thank u for Deleting data");
RequestDispatcher dispatcher = request.getRequestDispatcher("EmpDetail.html");
dispatcher.include(request, response);
}
catch(ClassNotFoundException e)
{
pw.println(e);
}
catch(SQLException e)
{
pw.println(e);
}
pw.println("</BODY>");
pw.println("</HTML>");
}
}
}
Subject
Written By
Posted
September 02, 2005 03:08AM
November 28, 2005 06:25AM
December 16, 2005 11:45AM
December 16, 2005 12:13PM
Re: Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql:// localhost:3306/karthicraj","mysql","mysql");
September 10, 2009 11:15AM
September 10, 2009 11:32AM
September 25, 2007 04:22PM
September 05, 2011 07:07AM
February 12, 2010 11:00PM
December 03, 2010 10:52AM
September 28, 2007 04:20AM
November 29, 2007 04:01PM
September 26, 2011 02:08AM
November 13, 2007 04:05PM
November 30, 2007 11:56AM
February 06, 2008 02:03AM
December 14, 2008 08:25PM
September 03, 2009 07:37AM
December 04, 2009 08:15AM
November 08, 2010 01:11PM
February 21, 2011 04:32AM