?? inserttableservlet.java
字號(hào):
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");
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -