xiugai.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="员工";
out.println(name);
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="update people set id='"+id+"',name='"+name+"',pass='"+pass+"',sf='"+sf+"',bm='"+bm+"',sex='"+sex+"',sr='"+sr+"',mz='"+mz+"',jg='"+jg+"',jtcs='"+jtcs+"',jbgz='"+jbgz+"',zw='"+zw+"',zc='"+zc+"',xl='"+xl+"',jfqk='"+jfqk+"',zyjl='"+zyjl+"',shjz='"+shjz+"'where id='"+id+"'"; 
   out.println(sql);
   stmt.executeUpdate(sql);
}
catch(SQLException e)
{
   out.println(e.getMessage());
}
stmt.close();
conn.close();
session.setAttribute("flag","1");
response.sendRedirect("66.jsp?id="+id);
%>