📄 change_secc.jsp
字号:
<%@page contentType="text/html; charset=GBK" %>
<%@page import="java.sql.*"%>
<html>
<head>
<title>
修改
</title>
</head>
<%! Connection conn; %>
<%! Statement stmt; %>
<%! int i=0;%>
<%!String xuehao="",name="",sex="",age="",address="",sql;%>
<%
if(request.getParameter("xuehao")!=null)
{
xuehao=request.getParameter("xuehao");
}else{
xuehao="xuehao";
}
out.print(xuehao);
if(request.getParameter("name")!=null)
{
name=request.getParameter("name");
name=new String(name.getBytes("ISO-8859-1"));
}else{
name="";
}
out.print(name);
if(request.getParameter("sex")!=null)
{
sex=request.getParameter("sex");
sex=new String(sex.getBytes("ISO-8859-1"));
}else{
sex="";
}
out.print(sex);
if(request.getParameter("age")!=null)
{
age=request.getParameter("age");
}else{
age="";
}
i=Integer.parseInt(age);
out.print(i);
if(request.getParameter("address")!=null)
{
address=request.getParameter("address");
address=new String(address.getBytes("ISO-8859-1"));
}else{
address="";
}
out.print(address);
if(name.equals("")){
response.sendRedirect("error.jsp");
}
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:test");
sql="update class set name='"+name+"',sex='"+sex+"',age="+i+",address='"+address+"' where xuehao='"+xuehao+"'";
stmt.executeUpdate(sql);
stmt.close();
conn.close();
}catch(Exception e){
out.print(e.getMessage());
}
%>
<body bgcolor="#ffffff">
正在处理信息，请稍后......................
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -