package servlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
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 infoServlet
*/
@WebServlet(description = "infoServlet", urlPatterns = { "/infoServlet" })
public class infoServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public infoServlet() {
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
// doGet(request, response);
// 获取数据
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
String username = request.getParameter("username");
String password = request.getParameter("password");
String repassword = request.getParameter("repassWord");
String sex = request.getParameter("sex");
String age = request.getParameter("age");
String grade = request.getParameter("grade");
String hobby = null;
String[] hobbies=request.getParameterValues("hobby");
StringBuffer sb=new StringBuffer("");
if(hobbies!=null){
for(String h:hobbies){
sb.append(h+" ");
}
hobby=sb.toString();
}
Connection conn=null;
Statement stmt=null;
String sql = null;
//加载驱动
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/userdb","pqq","111111");
stmt=conn.createStatement();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// 存储数据
try{
sql="insert into info(username,password,repassword,sex,age,grade,hobby) values("+"'"+username+"',"+"'"
+password+"',"+"'"+repassword+"',"+"'"+sex
+"',"+"'"+age+"',"+"'"+grade+"',"+"'"+hobby+"')";
stmt.executeUpdate(sql);
// 请求转发
request.getRequestDispatcher("listInfo.jsp").forward(request, response);
}catch(Exception e){
e.printStackTrace();
System.out.println("信息添加失敗!");
}finally
{
try {
stmt.close();
conn.close();
} catch (Exception e1) {
e1.printStackTrace();
}
}
}
}
评论0