jdbc新增

最新推荐文章于 2025-05-12 09:09:44 发布

艳阳天_.

最新推荐文章于 2025-05-12 09:09:44 发布

阅读量555

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/MZ199290/article/details/54933059

本文介绍了一个使用Java Servlet进行数据库插入操作的例子。通过GET请求接收参数，并使用JDBC连接MySQL数据库完成数据的新增。文章展示了如何处理中文字符编码问题及异常情况。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
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 Servlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public Servlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

 
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html;charset=utf-8");
	    request.setCharacterEncoding("utf-8");
		String useName=request.getParameter("userName");
	 int  id= Integer.parseInt(request.getParameter("id"));
		  try {
			Class.forName("com.mysql.jdbc.Driver");
			  Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/school", "root", "ok");
			  Statement sm = con.createStatement();
			  String sql="insert into grade  values ('"+id+"','"+useName+"')"; 
			  if (sm.executeUpdate(sql)>0) {
				System.out.println("新增成功！！");
			}
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		  
		  
	}

	 
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html");
		 doGet(request, response);
	}

	 
}

 statement.execute("update 表名 set user_id='"+参数+"' where id='"+Id+"'");这种格式

注意新增的参数类型是是‘"+ +"’,否则会报 Data truncation: Out of range value adjusted for column 'GradeID' at row 1