zhece.jsp

一个自已编写的用JSP编写的简单的人事管理系统

<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<% 
request.setCharacterEncoding("GBK");
String id=request.getParameter("id");
String name=request.getParameter("name");
String pass=request.getParameter("pass");
String bm=request.getParameter("bm");
String sex=request.getParameter("sex");
String sr=request.getParameter("sr");
String mz=request.getParameter("mz");
String jg=request.getParameter("jg");
String jtcs=request.getParameter("jtcs");
String jbgz=request.getParameter("jbgz");
String zw=request.getParameter("zw");
String zc=request.getParameter("zc");
String xl=request.getParameter("xl");
String jfqk=request.getParameter("jfqk");
String zyjl=request.getParameter("zyjl");
String shjz=request.getParameter("shjz");
String sf="员工";
Connection conn=null;
Statement stmt=null;
try
{
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce)
{
   out.println(ce.getMessage());
}
try
{ 
   conn=DriverManager.getConnection("jdbc:odbc:dong");                                                               
   stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
   String sql="insert into people values('"+id+"','"+name+"','"+pass+"','"+sf+"','"+bm+"','"+sex+"','"+sr+"','"+mz+"','"+jg+"','"+jtcs+"','"+jbgz+"','"+zw+"','"+zc+"','"+xl+"','"+jfqk+"','"+zyjl+"','"+shjz+"')";
   stmt.executeUpdate(sql);
}
catch(SQLException e)
{
   out.println(e.getMessage());
}
stmt.close();
conn.close();
response.sendRedirect("10.jsp");
%>