xiugai2.jsp

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

<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<%
request.setCharacterEncoding("GBK");
String str=request.getParameter("id");
String value="";
String sql="insert into rsbd values('"+str;
for(int i=1;i<=5;i++)
{
	value="a"+i;
	if(request.getParameter(value)!=null)
	{
		sql=sql+"','"+"1";
	}
	else
	{
		sql=sql+"','"+"0";
	}
		
}
sql=sql+"','"+request.getParameter("a6");
sql+="')";
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);
    stmt.executeUpdate(sql);
}
catch(SQLException e)
{
   out.println(e.getMessage());
}
stmt.close();
conn.close();
session.setAttribute("flag1","1");
response.sendRedirect("66.jsp?id="+str);
//response.sendRedirect("44.jsp");
%>