servlet-mysql-insert

http://www.devmanuals.com/tutorials/java/servlet/string/insert.html


MysqlInsertServlet.java

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class MysqlInsertServlet extends HttpServlet
{
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException
{
response.setContentType("text/html");
PrintWriter out= response.getWriter();
String oriString= request.getParameter("text1");
int ind_pos= Integer.parseInt(request.getParameter("text2"));
int rmv_char= Integer.parseInt(request.getParameter("text3"));
String subString= request.getParameter("text4");
String className= "com.mysql.jdbc.Driver";
String url= "jdbc:mysql://192.168.10.80/hr?useUnicode=true&characterEncoding=UTF8";
String user="root"; String password= "root";Connection con;
PreparedStatement ps;ResultSet rs;
try
{
Class.forName(className);
con= DriverManager.getConnection(url, user, password);
String sql0="insert into employee(recordID,firstName) value (5,'May')";
ps=con.prepareStatement(sql0);
ps.executeUpdate();
}
catch(SQLException sx)
{
out.println(sx);
}
catch(ClassNotFoundException cx)
{
out.println(cx);
}
}
}