这里的web.xml文件打开是没有...但依然可以执行,如何在web.xml文件中设置初始参数,并获取这个参数
不知道你这个问题是否已经解决, 如果还没有解决的话:重复 刚才 创建 Servlet 步骤 新建一个 Servlet 类名为 RegUser1Servlet 全选 删掉 复制 以下代码
package com.zlj.servlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class RegUser1Servlet
*/
@WebServlet("/RegUserServlet")
public class RegUser1Servlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public RegUser1Servlet() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
* response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
response.getWriter().append("Served at: ").append(request.getContextPath());
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
* response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");
Connection conn = null;
PreparedStatement pst = null;
// 1. 获取 表单 属性值
String username = request.getParameter("uname").trim().toLowerCase();
String password = request.getParameter("password").trim();
String sex = request.getParameter("gender").trim();
String question = request.getParameter("mibaoque").trim();
String answer = request.getParameter("mibaopass").trim();
String email = request.getParameter("email").trim();
String strSql = "insert into user(username,password,sex,question,answer,email) values(?,?,?,?,?,?)";
int flag = 0;
try {
Class.forName("com.mysql.jdbc.Driver"); // 驱动
String url = "jdbc:mysql://localhost:3306/testdb";
conn = DriverManager.getConnection(url, "root", "zhoulijun");
pst = conn.prepareStatement(strSql);
pst.setString(1, username);
pst.setString(2, password);
pst.setString(3, sex);
pst.setString(4, question);
pst.setString(5, answer);
pst.setString(6, email);
flag = pst.executeUpdate(); // executeUpdate 执行增删改 操作
pst.close();
conn.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(flag > 0) {
response.getWriter().println("<script>window.alert('注册成功')</script>");
}
response.sendRedirect("Login.jsp");
}
}
修改 数据库 的名称 和 自己数据库的密码