java - 微软sql错误异常

Question

 try {
        //     con = dbConn.mySqlConnection();
            con = DatabaseConnection.getRAWConnection();
 String insertSqlTable = "insert into certification VALUES(?,?,?,?,?,?,CURRENT_TIMESTAMP,?)";
          pst = con.prepareStatement(insertSqlTable);
          pst.setInt(1, td.getEmpId());
        pst.setString(2, td.getRname());
        pst.setString(3, td.getStream());
        pst.setString(4, td.getCertificationType());
        pst.setString(5, td.getCertificationName());
        pst.setString(6, td.getCertificationDate());
        //pst.setTimestamp(7, timestamp);
        pst.setInt(7, td.getScore());

        int count = pst.executeUpdate();
        if (count >= 1) {
            con.commit();
            status = true;
        } else {
            System.out.println("Error occured while inserting certification details into database");
            con.rollback();
            status = false;
        }

我遇到以下异常:

com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: int is incompatible with datetime2

Answer 1

而不是这个

pst.setInt(7, td.getScore());

使用

pst.setInt(8, td.getScore());

第 7 参数已作为 CURRENT_TIMESTAMP 存在。您有兴趣将第 8 参数设置为 1。

更新

试试这个

try {
        //  con = dbConn.mySqlConnection();
            con = DatabaseConnection.getRAWConnection();
 String insertSqlTable = "insert into certification VALUES(?,?,?,?,?,?,?,?)";
        pst = con.prepareStatement(insertSqlTable);
        pst.setInt(1, td.getEmpId());
        pst.setString(2, td.getRname());
        pst.setString(3, td.getStream());
        pst.setString(4, td.getCertificationType());
        pst.setString(5, td.getCertificationName());
        pst.setString(6, td.getCertificationDate());
        java.sql.Timestamp date = new java.sql.Timestamp(new java.util.Date().getTime());
        pst.setTimestamp(7, date);
        pst.setInt(8, td.getScore());

        int count = pst.executeUpdate();
        if (count >= 1) {
            con.commit();
            status = true;
        } else {
            System.out.println("Error occured while inserting certification details into database");
            con.rollback();
            status = false;
        }

}