dealmodify.jsp

来自「j2ee实现简单的bbs功能」· JSP 代码 · 共 35 行

JSP
35
字号
<%@ page language="java" import="java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<jsp:useBean id = "dBean" scope="session" class="BeanLink.DBBean"/>
<html>
<head>
<title>注册</title>
</head>
<body>
<center>
<%
String sdriver="sun.jdbc.odbc.JdbcOdbcDriver";
String sconn="jdbc:odbc:mydb";
String suser="";
String spass="";
String tablename="user";

String idStr = request.getParameter("id");
long id = Long.parseLong(idStr);

String password = request.getParameter("mypass");
String email = request.getParameter("email");
String purviewStr = request.getParameter("purview");
int purview = Integer.parseInt(purviewStr);
String sql  = "update "+tablename+" set password='"+password+"',email='"+email+"',purview="+purview+" where id="+id;	
System.out.println(sql);
dBean.openConn(sdriver,sconn,suser,spass);
dBean.executeUpdate(sql);
session.putValue("email",email);
dBean.closeConn();
response.sendRedirect("userlist.jsp");

%>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?