数据库问题，用MYSQL往表中插入数据出错(含错误代码)

2008-06-19 04:52:44 474 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

实战指南：基于华为Ascend NPU的大模型W8A8量化调优与精度提升本文提供了一份基于华为Ascend NPU进行大模型W8A8量化的实战调优指南。详细介绍了从环境搭建、使用msmodelslim框架进行基础量化，到通过离群值抑制、校准集优化和量化回退等关键技术提升精度的全流程。旨在帮助开发者在华为NPU硬件上实现模型推理的显著加速，同时有效控制精度损失。阅读详情

下面这个是我的表。用的是MySql数据库
create table booksInfo(bookid varchar(20), bookname varchar(30),bookauthor varchar(20),num int,publisher varchar(50) , begintime datetime);

而我在做往表中插入数据时出现错误，

错误代码：

 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '33'asdfasdf''1987-1-1')' at line 1com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '33'asdfasdf''1987-1-1')' at line 1

部分JAVA代码：



public void button2_actionPerformed(ActionEvent e){

		int sl;

		String bianhao = jtbianhao.getText().trim();

		String zuozhe = jtzuozhe.getText().trim();

		String shuliang = jtshuliang.getText().trim();

		String shuming = jtshuming.getText().trim();

		String chubanshe = jtchubanshe.getText().trim();

		String ruku = jtdate.getText().trim();

		if(bianhao.equals(""))

				JOptionPane.showMessageDialog(null, "图书编号不能为空，请继续填写```", "信息填写错误",

                        JOptionPane.ERROR_MESSAGE);

		else if (zuozhe.equals(""))

	           JOptionPane.showMessageDialog(null, "图书作者不能为空，请继续填写```", "信息填写错误",

	                                         JOptionPane.ERROR_MESSAGE);

		else if(shuliang.equals(""))

			JOptionPane.showMessageDialog(null, "图书数量不能为空，请继续填写```", "信息填写错误",

                    JOptionPane.ERROR_MESSAGE);

		else if(shuming.equals(""))

			JOptionPane.showMessageDialog(null, "图书名称不能为空，请继续填写```", "信息填写错误",

                    JOptionPane.ERROR_MESSAGE);

		else if(chubanshe.equals(""))

			JOptionPane.showMessageDialog(null, "出版社不能为空，请继续填写```", "信息填写错误",

                    JOptionPane.ERROR_MESSAGE);

		else if(ruku.equals(""))

			JOptionPane.showMessageDialog(null, "入库时间不能为空，请继续填写```", "信息填写错误",

                    JOptionPane.ERROR_MESSAGE);

		else{

			try {

				sl = Integer.parseInt(shuliang);

			} catch (NumberFormatException e1) {

				// TODO Auto-generated catch block

				e1.printStackTrace();

				 JOptionPane.showMessageDialog(null, "图书的 数量 只能是数字！！！，请继续填写```",

                         "数量填写错误",

                         JOptionPane.ERROR_MESSAGE);

				 return;

			}

			String sql = "insert into booksinfo (bookid,bookname,bookauthor,num,publisher,begintime) values(??????)";

			PreparedStatement pe=null;

	           ResultSet rs=null;

	           try {

				pe = db.conn.prepareStatement(sql);

				pe.setString(1, bianhao);

				pe.setString(2, shuming);

				pe.setString(3, zuozhe);

				pe.setInt(4, sl);

				pe.setString(5, chubanshe);

				pe.setString(6, ruku);

				if(db.add(pe)){

	                   db.myClose(1);

	                   JOptionPane.showMessageDialog(null, "增加成功");

				}

				else

	                   JOptionPane.showMessageDialog(null, "添加失败");

			} catch (SQLException e1) {

				// TODO Auto-generated catch block

				e1.printStackTrace();

			}

		}

		

	}

public boolean add(PreparedStatement pt)

   {



       int result=-1;

    try {

        result = pt.executeUpdate();



    } catch (SQLException ex) {

        System.out.println(ex.toString());

        ex.printStackTrace();

    }

    if(result>0)

       return true;

   else

       return false;

   }