📄 updatingservlet.java
字号:
package dcfs;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class for Servlet: UpdatingServlet
*
*/
public class UpdatingServlet extends javax.servlet.http.HttpServlet implements
javax.servlet.Servlet {
private static final long serialVersionUID = 1L;
public UpdatingServlet() {
super();
}
public void destroy() {
super.destroy();
}
protected void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
// 从修改页面的表单中获得用户修改后的信息，并将这些信息存入对应的变量中，以便执行数据操作
String id = request.getParameter("id");
String password = request.getParameter("password");
String username = new String(request.getParameter("username").getBytes(
"ISO-8859-1"), "GB2312");
String sex = request.getParameter("sex");
String school = new String(request.getParameter("school").getBytes(
"ISO-8859-1"), "GB2312");
String major = request.getParameter("major");
major = new String(major.getBytes("ISO-8859-1"), "GB2312");
String phone = request.getParameter("phone");
String email = request.getParameter("email");
String hobbies = request.getParameter("兴趣");
String address = new String(request.getParameter("address").getBytes(
"ISO-8859-1"), "GB2312");
String introduce = request.getParameter("introduce");
introduce = new String(introduce.getBytes("ISO-8859-1"), "GB2312");
// 设置页面的属性
response.setContentType("text/html");
response.setCharacterEncoding("GBK");
PrintWriter out = response.getWriter();
out.print("<html>");
out.print("<head>");
out.println("<title>信息修改成功</title>");
out.println("</head>");
out.println("<body>");
// 声明数据库连接的相关对象
Connection con;
Statement sql_update;
ResultSet rs;
// 定义数据库更新操作语句
String stmt = "insert into user_info(ID号,密码,姓名,性别,学校,专业,电话,邮箱,兴趣,住址,自我简介,上次登录时间,登录次数) values('"
+ id
+ "','"
+ password
+ "','"
+ username
+ "','"
+ sex
+ "','"
+ school
+ "','"
+ major
+ "','"
+ phone
+ "','"
+ email
+ "','"
+ hobbies
+ "','"
+ address
+ "','"
+ introduce
+ "',sysdate,1)";
// 加载数据库驱动程序
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
System.out.println("ClassNotFound~~~~~~");
}
// 建立与数据库的连接
try {
con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:orcl", "hongshuai",
"hongshuai");
System.out.println("数据库连接成功！");
sql_select = con.createStatement();
sql = con.createStatement();
// 执行数据库SQL语句，查询数据库中是否为相同的id号用户
rs = sql_select.executeQuery(stmt_select);
if (rs.next()) {
String id_db = rs.getString("ID号");
if (id.equals(id_db)) {
out.print("该用ID号已经被注册，请换用其他的ID号！！<br>");
out.println("</body>");
out.println("</html>");
out.flush();
out.close();
}
} else {
// 执行数据库SQL语句，向数据库中插入注册用户的信息
sql.execute(stmt);
out.print("祝贺你已经注册<br>");
out.print("你的ID号为：" + id + "<br>");
out.print("你的密码为：" + password + "<br>");
out.println("</body>");
out.println("</html>");
out.close();
}
// 关闭数据库连接
con.close();
System.out.println("数据库已经关闭!~~~");
} catch (SQLException ex) {
System.out.println("SQL，注册出错！");
}
}
public void init() throws ServletException {
super.init();
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -