⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 updateservlet.java

📁 基于Servlet的用户注册与登录,后台利用Oracle数据库实现。
💻 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: UpdateServlet
 * 
 */
public class UpdateServlet extends javax.servlet.http.HttpServlet implements
		javax.servlet.Servlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	public UpdateServlet() {
		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 {

		// 设置页面属性
		response.setContentType("text/html");
		response.setCharacterEncoding("GBK");

		PrintWriter out = response.getWriter();
		//获得登录用户的ID号
		String id = request.getParameter("id");
		

		// 声明数据库连接的相关对象
		Connection con;
		Statement sql;
		ResultSet rs;

		String stmt = "select * from user_info where ID号='"+id+"'";
		
		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 = con.createStatement();
			//System.out.println("kkkkkkkkkkkk");
			rs = sql.executeQuery(stmt);
			//System.out.println("ssssssssssssss");

			if (rs.next()) {

				//String id = rs.getString("ID号");
				String password = rs.getString("密码");
				String username = rs.getString("姓名");
				String sex = rs.getString("性别");
				String school = rs.getString("学校");
				String major = rs.getString("专业");
				String phone = rs.getString("电话");
				String email = rs.getString("邮箱");
				String hobbies = rs.getString("兴趣");
				String address = rs.getString("住址");
				String introduce = rs.getString("自我简介");

				String display = "<html><head><title>个人信息</title></head>"
						+ "<form action='' method='post' name='form_update'>"
						+ "<br>"
						+ "<p> <font size='5' color='red'>用户信息修改页面</font></p><br>"
						+ "ID号：<input type='text' name='id' value=" + id
						+ " readonly><br>"
						+ "密码：<input type='text' name='password' value="
						+ password + "><br>" +
						// value="+password+"><br>" +
						// "确认密码：<input type='password' name='password_2'
						// value="+><br>
						"姓名：<input type='text' name='username' value="
						+ username + "><br>"
						+ "性别：<input type='text' name='sex' value=" + sex
						+ "><br>" +

						"学校：<input type='text' name='school' value=" + school
						+ "><br>" +

						"专业：<input type='text' name='major' value=" + major
						+ "><br>" +

						"电话号码：<input type='text' name='phone' value=" + phone
						+ "><br>"
						+ "邮箱地址：<input type='text' name='email' value=" + email
						+ "><br>" +

						"兴趣：<input type='text' name='hobby' value=" + hobbies
						+ "><br> " +
						// value="music">音乐&nbsp;&nbsp;
						// <input type="checkbox" name="hobby"
						// value="football">足球&nbsp;&nbsp;
						// <input type="checkbox" name="hobby"
						// value="neting">上网&nbsp;&nbsp;
						// <input type="checkbox" name="hobby"
						// value="read">看书&nbsp;&nbsp;
						// <input type="checkbox" name="hobby"
						// value="play">游戏<br>
						"住址：<input type='text' name='hobby' value=" + address
						+ "><br> " +
						// <option value="北京">北京</option>
						// <option value="上海">上海</option>
						// <option value="西安">西安</option>
						// <option value="广州">广州</option>
						// </select><br><br>
						"自我简介:<input type = 'text' name='introduce' value="
						+ introduce + "><br>" + "</body></html>";

				out.print(display);
			}

			// 关闭数据连接
			con.close();
			System.out.println("数据库已经关闭!~~~");
		} catch (SQLException ex) {
			System.out.println("SQL,Logon出错！！");
		}
	}

	public void init() throws ServletException {
		super.init();
	}
}

⌨️ 快捷键说明

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