1.新建一个maven工程，选webapp模板
2.安装tomcat
https://tomcat.apache.org/download-80.cgi 下载解压到自定义目录上
ps:在全局变量加上JAVA_HOME变量指向JDK（例如:D:\Java\v1.8）,tomcat才能正常运行
3.eclipse配置server
Windows-->Preferences-->Server-->Runtime Environments
添加tomcat
4.增加tomcat的libary
工程右击--->Build Path --->Configure Build path
选择刚刚加到eclipse的tomcat
5.编写jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="${pageContext.request.contextPath}/saveUserInfo" method="GET">
username:<input type="text" name="username"></input><br/>
adress:<input type="text" name="address"></input>
<input type="submit" value="保存"/>
</form>
</body>
</html>
6.编写映射到servlet接口类的配置文件，web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<servlet>
<servlet-name>hello</servlet-name>
<servlet-class>amie.servlet.helloServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>hello</servlet-name>
<url-pattern>/saveUserInfo</url-pattern>
</servlet-mapping>
</web-app>
7.编写servlet类
从上面可以得到，tomcat服务器的路径“/saveUserInfo”已经映射到“amie.servlet.helloServlet”这个类上了
package amie.servlet; import java.io.IOException; import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse; import jdbc.jdbc; public class helloServlet extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setCharacterEncoding("gbk");
String username = new String(request.getParameter("username").getBytes("UTF8"));
String address = new String(request.getParameter("address").getBytes("UTF8"));
jdbc mj = new jdbc();
try {
mj.insert(username, address);
response.getWriter().println("写入成功");
} catch (Exception e) {
response.getWriter().print(e);
}
}
}
doGet、doPost等方法会对应路径“/saveUserInfo”的GET、POST的方法
8.编写jdbc
我们上面用了一个jdbc.jdbc类的insert方法
package jdbc; import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement; public class jdbc {
public void insert(String name, String address) throws Exception{
String url = "jdbc:mysql://localhost:3306/20171113";
String userName = "root";
String password = "";
Connection conn = DriverManager.getConnection(url,userName,password);
String sql = "INSERT INTO user(username,address) VALUES(?,?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, name);
ps.setString(2, address);
ps.execute();
conn.close();
}
}
这里值得一提的是：jdbc的mysql驱动（mysql-connector-java-x.x.x-bin）一定要加在jre\lib\ext下,因为此时已经运行在tomcat上脱离了eclipse，runtime的依赖包一定要到java的安装目录下获取。
9.运行
项目右击，run as --> run on server
保存后
数据库也成功存入数据
