利用servlet将数据传到数据库
package com.controller;
/**
* 对某张表或某个模块的接口
*/
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
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 testController
*/
@WebServlet("/testController")
public class testController extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public testController() {
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());
System.out.println(request.getParameter("name"));
String name=request.getParameter("name");
if(name!=null) {
try {
//1 加载驱动
Class.forName("com.mysql.jdbc.Driver");
//2 连接数据库
Connection con=DriverManager.getConnection("jdbc:mysql://10.96.126.184:3306/hd", "root", "root");
//3 要执行的sql语句
String sql="INSERT into users (uid,uname,upwd) VALUE ('1-111565687356545652','"+name+"','6666')";
System.out.println(sql);
//4 创建执行sql语句的对象
Statement st = con.createStatement();
//5 执行sql语句
int temp =st.executeUpdate(sql);
System.out.println("返回的值:"+temp);
//6 关闭sql对象
st.close();
//7 关闭连接
con.close();
} catch ( SQLException | ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
/**
* @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);
}
}
界面及运行结果: