📄 modification_jsp.java
字号:
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
public final class modification_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
private static java.util.Vector _jspx_dependants;
public java.util.List getDependants() {
return _jspx_dependants;
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html;charset=gb2312");
pageContext = _jspxFactory.getPageContext(this, request, response,
null, true, 8192, true);
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\r\n\r\n<html>\r\n<body>\r\n");
String Username=request.getParameter("Username");
String Password=request.getParameter("Password");
String Password1=request.getParameter("Password1");
String Password2=request.getParameter("Password2");
if(Username==null||Username.equals(""))
{
out.println("请输入姓名!!!<br>");
out.println("<A href=modification.html>返回</A><br>");
}
if(Password==null||Password1==null||Password2==null||Password.equals("")||Password1.equals("")||Password2.equals("")||!Password1.equals(Password2))
{
out.println("密码输入非法!!!<br>");
out.println("<A href=modification.html>返回</A><br>");
}
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String URL="jdbc:odbc:bookshop";
Connection conn=DriverManager.getConnection(URL);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from UserInfo";
ResultSet rs=stmt.executeQuery(sql);
int i=0;
int j=0;
while(rs.next())
{
if(Username.equals(rs.getString("UserName"))&&Password.equals(rs.getString("PassWord")))
{
i++;
break;
}
j++;
}
if(i==0)
{
out.println("用户名或密码错误");
}
else
{
rs.absolute(j+1);
rs.updateString("PassWord",Password1);
rs.updateRow();
rs.close();
out.println("用户名修改成功");
}
stmt.close();
conn.close();
}
catch(ClassNotFoundException ex){
out.println(ex.getMessage());
}
catch(SQLException ex){
out.println(ex.getMessage());
}
out.write("\r\n\r\n</body>\r\n</html>\r\n\r\n ");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (pageContext != null) pageContext.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -