静态提交页面:addTeam.html
转到servlet处理的页面:addTeam.java
以此就实现了从静态页面的提交到servlet处理的并返回显示的过程。其中分层不是很明显,每句都要写pw.println();甚是麻烦,因此选择jsp来实现表现和代码内容的分离是很明智的选择。
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>增加小组</title>
</head>
<body>
<h1 align="center">增加小组</h1>
<form action="servlet/addteam" method="post">
<p>组名:<input type="text" name="name">
<p>口号:<input type="text" name="slogan">
<p>组长:<input type="text" name="leader">
<p><input type="submit" value="确定">
<input type="reset" value="重填">
</form>
<a href="index.html">返回首页</a>
</body>
</html>
转到servlet处理的页面:addTeam.java
/*
* 用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();
}
}
}
}
以此就实现了从静态页面的提交到servlet处理的并返回显示的过程。其中分层不是很明显,每句都要写pw.println();甚是麻烦,因此选择jsp来实现表现和代码内容的分离是很明智的选择。
静态提交页面地址:http://127.0.0.1:8080/team/addTeam.html
servlet返回页面地址:http://127.0.0.1:8080/team/servlet/addteam