浏览器网址添加参数，发送请求给数据库

http://localhost:8080/MyWebPro/servlet/myfir?参数名1=参数值1&参数名2=参数值2

http://localhost:8080/MyWebPro/servlet/myfir?stu_num=stu005&stu_name=Tom&stu_sex=男2&email=Tom@163.com

package com.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;


import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


public  class MyServlet extends HttpServlet {
// 定义一个方法 doGet 有两个参数 请求和返回
    
    public void doGet(HttpServletRequest req,HttpServletResponse res) throws IOException {
        //浏览器后面拼接的参数 http://localhost:8080/MyWebPro/servlet/myfir?stu_num=stu005&stu_name=Tom&stu_sex=男2&email=Tom@163.com
            String stu_num=req.getParameter("stu_num");
            String stu_name=req.getParameter("stu_name");
            String stu_sex=req.getParameter("stu_sex");
            String email=req.getParameter("email");
            res.setContentType("text/html;charset=UTF-8"); //设置相应信息的类型和编码
            //res.setCharacterEncoding("UTF-8");
            PrintWriter out=res.getWriter();//返回的数据
            out.write("添加学生数据成功");
           


        try {
            Class.forName("com.mysql.jdbc.Driver");//加载驱动
            System.out.println("加载数据库驱动成功");
            String dbUrl="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8";//数据库是test
            
            Connection conn=DriverManager.getConnection(dbUrl,"root","111111");//建立与数据库的连接  
            System.out.println("连接数据库成功");
            String sql="insert into stu_info (stu_num,stu_name,stu_sex,email)values('"+stu_num+"','"+stu_name+"','"+stu_sex+"','"+email+"')";
            System.out.println(sql);
            Statement stmt=conn.createStatement();//执行sql语句并检查结果
            stmt.executeUpdate(sql);//执行sql
            System.out.println("插入到数据库成功");
            
            conn.close();
            System.out.println("关闭数据库成功");
            
            
        }catch(Exception e) {
            e.printStackTrace();//利用try catch 捕获异常  即便数据库修改失败页面也返回 请求成功
            
            
        }
        

            
    }

}

在浏览器发送请求

执行Tomcat服务

 

查询数据库内数据 成功新增了一条数据