editzs1.jsp

来自「--- --^_^-------------- 广师公寓中心 1.请装上」· JSP 代码 · 共 46 行

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<%
if(session.getAttribute("login")== null)
  {%>
  <jsp:forward page="login.jsp"/>
  <%}
%>
<%
request.setCharacterEncoding("gb2312");
String id1=request.getParameter("id");
String xuehao1=request.getParameter("textfield1");
String name1=request.getParameter("textfield2");
String age1=request.getParameter("textfield3");
String sex1=request.getParameter("textfield");
String zhuanye1=request.getParameter("textfield4");
String build1=request.getParameter("textfield5");
String sushe1=request.getParameter("textfield6");
%>

<%
try{  
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{  
out.print(e);
}
try{  
String strDirPath=application.getRealPath(request.getRequestURI());   
strDirPath=strDirPath.substring(0,strDirPath.lastIndexOf('\\'))+"\\";  
strDirPath=application.getRealPath("ODBC/gongyu.mdb");  
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+strDirPath; 
Connection conn = DriverManager.getConnection(url);  
Statement stmt = conn.createStatement();
String sql="update student set xuehao='" + xuehao1 + "',name='" + name1 + "',age='" + age1 + "',sex='" + sex1 + "',zhuanye='" + zhuanye1 + "',build='" + build1 + "',sushe='" + sushe1 + "' where id="+ id1;
stmt.executeUpdate(sql);
stmt.close();  
conn.close();
}
catch(Exception ex)
{  
out.print(ex);
}
%>			   		 
<jsp:forward page="zs.jsp"/>