Java web 开发一个论坛系统

1、创建数据库，设计表的结构，系统应能够存储用户信息、用户发布的问题、问题的回答等相关数据；

	public void init() {
		String driver = "com.mysql.cj.jdbc.Driver";
		String dburl = "jdbc:mysql://127.0.0.1:3306/qm?useSSL=false&serverTimezone=UTC";
		String username = "root";
		String password = "root";
		try {
			Class.forName(driver); // 加载驱动程序
			// 创建连接对象
			dbconn = DriverManager.getConnection(dburl, username, password);

		} catch (ClassNotFoundException e1) {
			System.out.println(e1);
			getServletContext().log("驱动程序类找不到！");
		} catch (SQLException e2) {
			System.out.println(e2);
		}
	}

---

2、用户登陆：通过查询数据库内的user表内判断输入的用户密码是否正确； 

 	public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String username = request.getParameter("username");
		String password = request.getParameter("password");

		try {
			String sql = "SELECT * FROM user WHERE username = ?";

			PreparedStatement pstmt = dbconn.prepareStatement(sql);

			pstmt.setString(1, username);

			ResultSet rst = pstmt.executeQuery();

			if (rst.next()) {
				User user = new User(rst.getLong("user_id"), rst.getString("username"), rst.getString("password"));

				// 账号密码正确
				if (username.equals(user.getUsername()) && password.equals(user.getPassword())) {
					// 将用户存放在ses