📄 updatestu-1.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" import="java.sql.*" errorPage="errorpage.jsp" %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="updateObject" scope="page" class="BeanPage.loginBean"/>
<html>
<head>
<title>无标题文档</title>
</head>
<body>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<div align="center">
<p>
<%
String preName = request.getParameter("preTextName");
byte preN[] = preName.getBytes("ISO-8859-1");
preName = new String(preN);
String preNum = request.getParameter("preTextNum");
String afterName = request.getParameter("afterTextName");
byte afterN[] = afterName.getBytes("ISO-8859-1");
afterName = new String(afterN);
String afterNum = request.getParameter("afterTextNum");
String sqlOne = "select * from stu_login where name ='"+preName+"'and number ='"+preNum+"'";
ResultSet Rs = updateObject.executeQuery(sqlOne);
//out.print(Rs);
if(Rs.next()){
String sqlTwo = "update stu_login set name = ?, number = ? where number ='"+preNum+"'";
;
Connection con;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){
out.println(e);
}
try {
con=DriverManager.getConnection("jdbc:odbc:login");
Statement stmt = con.createStatement();
stmt.executeUpdate("delete from stu_login where name='"+preName+"' and number = '"+preNum+"'");
String password = "123456";
stmt.executeUpdate("insert into stu_login values ('"+afterName+"','"+afterNum+"','"+password+"')");
out.println("modify success!");
}catch(SQLException e){
out.println(e);
}
}else{//
out.println("the information wrong , please modify!");
}
%>
</p>
<p>
<input name="button" type=button onClick=window.history.go(-1) value=倒退>
</p>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -