inserttableservlet.java

SUN sl-314 source codes

package org.apache.jsp;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;

import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class InsertTableServlet extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws IOException {
	}
	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
	throws IOException { 
		response.setContentType("text/html;charset=GBK");
		PrintWriter out = response.getWriter();
		
		int empno; String ename; String job; int mgr; 
	    String hiredate; double sal; int deptno;
		
	    empno = Integer.parseInt(request.getParameter("empno"));
	    ename = request.getParameter("ename");
	    ename = new String(ename.getBytes("ISO8859_1"),"GBK");
	    job = request.getParameter("job");
	    mgr = Integer.parseInt(request.getParameter("mgr"));
	    hiredate = request.getParameter("hiredate");
	    hiredate = new String(hiredate.getBytes("ISO8859_1"),"GBK");
	    sal = Double.parseDouble(request.getParameter("sal"));
	    deptno = Integer.parseInt(request.getParameter("deptno"));
	    
		try {
	          Class.forName("oracle.jdbc.driver.OracleDriver");
	    	  Connection con = DriverManager.getConnection("jdbc:oracle:thin:@garfield:1521:orcl","scott","tiger");
	          Statement stmt = con.createStatement();
	          String SQL_stmt = "insert into emp(empno, ename, job, mgr, hiredate, sal, deptno) " +
	          		"values (" + empno + ", '" + ename + "', '" + job + "', " + mgr + ", '" + hiredate + "', " + sal + ", " + deptno + ")";
	          stmt.executeQuery(SQL_stmt);
	          stmt.executeQuery("commit");
		      con.close();
		      // out.print(SQL_stmt);
		      
		}
		catch (ClassNotFoundException e) {
		      out.println(e.getMessage());
		}
		catch (SQLException e) { 
		      out.println(e.getMessage());
		}
		response.sendRedirect("/c12/servlet/SelectTableServlet");
	}
}