htmlform
<body>
<form name="customerform" action="/Customer/cs">
customerid:<input type="text" name="cid"/>
customerName:<input type="text" name="cname"/>
<input type="submit" value="store"/>
</form>
</body>
Servlet
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.io.*;
public class CustomerServlet extends HttpServlet{
public void Service(HttpServletRequest req,HttpServletResponse res){
try{
System.out.println("1");
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","prasad","abc");
Statement stmt = conn.createStatement();
String id = req.getParameter("cid");
String name = req.getParameter("cname");
int result=stmt.executeUpdate("insert into customer values('"+id+"','"+name+"')");
PrintWriter out = res.getWriter();
out.write(id);
out.write(name);
conn.close();
}catch(Exception e){}
}
}
web.xml
<web-app>
<servlet>
<servlet-name>csservlet</servlet-name>
<servlet-class>CustomerServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>csservlet</servlet-name>
<url-pattern>/cs</url-pattern>
</servlet-mapping>
</web-app>