/*
* 用doPost来接收post传过来的数据并存入mysql数据库
*/
package servlet;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class addTeam extends HttpServlet {
protected void doPost(HttpServletRequest request,HttpServletResponse response)
throws IOException,ServletException{
request.setCharacterEncoding("GBK");//设置接收的字符集
//接收数据
String name = request.getParameter("name");
String slogan = request.getParameter("slogan");
String leader = request.getParameter("leader");
//保存到数据库
Connection cn = null;
PreparedStatement pst = null;
try {
Class.forName("com.mysql.jdbc.Driver");//加载MySQL驱动程序
//建立与数据库的连接
String url = "jdbc:mysql://localhost:3306/training";
String user = "root";
String password = "jakeyouxiang";
cn = DriverManager.getConnection(url,user,password);
pst = cn.prepareStatement("insert into team(name,slogan,leader) values (?,?,?)"); //创建PreparedStatement对象
//设置数据
pst.setString(1,name);
pst.setString(2,slogan);
pst.setString(3,leader);
pst.executeUpdate(); //向数据库增加数据
// 通过response向客户端应答,显示增加成功
response.setContentType("text/html;charset=GBK");
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>增加小组成功</title>");
out.println("</head>");
out.println("<body>");
out.println("<h1 align=center>增加小组成功</h1>");
out.println("<p><a href='../addTeam.html'>继续增加</a>");
out.println("<a href='viewteams'>显示小组</a>");
out.println("<a href='../index.html'>返回首页</a>");
out.println("</body>");
out.println("</html>");
} catch (Exception e) {
e.printStackTrace();
// 通过response向客户端应答,显示增加失败
response.setContentType("text/html;charset=GBK");
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>增加小组失败</title>");
out.println("</head>");
out.println("<body>");
out.println("<h1 align=center>增加小组失败</h1>");
out.println("<p><a href='../addTeam.html'>继续增加</a>");
out.println("<a href='viewteams'>显示小组</a>");
out.println("<a href='../index.html'>返回首页</a>");
out.println("</body>");
out.println("</html>");
}
finally {
try {
pst.close();
cn.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
}
}