servlet入门实例(含mysql增查功能)

package com.serverlet; import java.io.IOException; import java.io.PrintWriter; 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.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class AddUser extends HttpServlet { protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=utf-8"); String userId= request.getParameter("userId"); String userName=request.getParameter("userName"); String userAge=request.getParameter("userAge"); PrintWriter out = response.getWriter(); Connection conn = null; try { // 获取链接 Class.forName("com.mysql.jdbc.Driver"); //我的数据库没有设密码 conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mybatis?user=root&password="); Statement stat = conn.createStatement(); // 执行sql String sql = "insert into t_user (userId,userName,userAge) values(?,?,?)"; PreparedStatement pstmt; pstmt = (PreparedStatement) conn.prepareStatement(sql); pstmt.setString(1, userId); pstmt.setString(2, userName); pstmt.setString(3, userAge); int t = pstmt.executeUpdate(); if(t>0){ System.out.println("我是AddUser,数据添加成功！！！"); out.println("我是AddUser,数据添加成功！！！"); }else{ System.out.println("我是AddUser,数据添加失败！！！"); out.println("我是AddUser,数据添加失败！！！"); } if (stat != null) stat.close(); if (pstmt != null) pstmt.close(); if (conn != null) conn.close(); } catch (SQLException e) { e.printStackTrace(); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally{ out.close(); System.out.println("我是AddUser doGet()方法！用来处理Get请求"); } } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { System.out.println("我是AddUser doPost()方法！用来处理post请求"); doGet(request, response); } public void destroy() { super.destroy(); System.out.println("我是AddUser destroy()方法！用来进行销毁实例的工作"); } public void init() throws ServletException { System.out.println("我是AddUser init()方法！用来进行初始化工作"); } }