Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.atos.java.servlet;
- import java.io.IOException;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import javax.servlet.ServletException;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- /**
- * Servlet implementation class Dbservlet
- */
- public class Dbservlet extends HttpServlet {
- private static final long serialVersionUID = 1L;
- private static final String DB_URL=
- "jdbc:oracle:thin:@localhost:1521:xe";
- private static final String USER_ID ="hr";
- private static final String PASSWORD ="hr";
- /**
- * @see HttpServlet#HttpServlet()
- */
- public Dbservlet() {
- super();
- // TODO Auto-generated constructor stub
- }
- /**
- * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
- */
- protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- // TODO Auto-generated method stub
- //response.getWriter().append("Served at: ").append(request.getContextPath());
- int bn,amt;
- String name;
- try{
- Class.forName("oracle.jdbc.driver.OracleDriver");
- Connection con = DriverManager.getConnection(DB_URL,USER_ID,PASSWORD);
- PreparedStatement ps = con.prepareStatement("insert into bill_master values(?,?,?");
- bn=Integer.parseInt(request.getParameter("bn"));
- name=request.getParameter("name");
- amt=Integer.parseInt(request.getParameter("amt"));
- ps.setInt(1,bn);
- ps.setString(2,name);
- ps.setInt(3,amt);
- int i = ps.executeUpdate();
- con.commit();
- System.out.println("Record Successfully Inserted...!");
- }catch(Exception e){System.out.println("Hi");}
- }
- /**
- * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
- */
- protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- // TODO Auto-generated method stub
- doGet(request, response);
- }
- }
Add Comment
Please, Sign In to add comment