强制转换的字符值无效

vjrehmav  于 2021-07-24  发布在  Java
关注(0)|答案(0)|浏览(331)

我一直收到这个错误, net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::5.0.0-SNAPSHOT data exception: invalid character value for cast . 我不知道如何修复它我已经尝试从我的sql查询的值中去掉主键,我不确定数据是否不兼容或者我是否以某种方式声明它是错误的请帮助。我正在尝试将gui中的值插入到现有数据库中。
这是我的密码

  1. String racename, noofswimmers, avgtime, raceontime, tod, winid;
  2. racename = txtracename.getText();
  3. noofswimmers = txtnoswimmers.getText();
  4. avgtime = txtavgtime.getText();
  5. raceontime = txtraceontime.getText();
  6. tod = txttod.getText();
  7. winid = txtwinid.getText();
  8. try {
  9. Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
  10. con = DriverManager.getConnection("jdbc:ucanaccess://C:/Users/Calvin/Documents/SwimGala.accdb");
  11. pst = con.prepareStatement("insert into tblRace(RaceName,NoSwimmers,AvgTime,RaceOnTime,TimeOfDay,WinID)values(?,?,?,?,?,?)");
  12. pst.setString(0,racename);
  13. pst.setString(1,noofswimmers);
  14. pst.setString(2,avgtime);
  15. pst.setString(3,raceontime);
  16. pst.setString(4,tod);
  17. pst.setString(5,winid);
  18. pst.executeUpdate();
  19. JOptionPane.showMessageDialog(this,"Record added");
  20. } catch (ClassNotFoundException ex) {
  21. Logger.getLogger(Tabl.class.getName()).log(Level.SEVERE, null, ex);
  22. JOptionPane.showMessageDialog(this,ex);
  23. } catch (SQLException ex) {
  24. Logger.getLogger(Tabl.class.getName()).log(Level.SEVERE, null, ex);
  25. JOptionPane.showMessageDialog(this,ex);
  26. }

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题