如果存在ID则更新记录否则插入值 [英] Update a record if ID exist else Insert values

问题描述

如果记录存在，我正在尝试更新值，否则将值插入数据库。但是，这不起作用。我写了下面的代码。

I am trying to update a value if record exists else insert the values to database. However, that is not working. I have written the below code.

 String sqlCheck = "Select * from [UAP].[dbo].[UAP_EMPLOYEE] where EMP_EMPLOYEE_ID = '"+empId+"' ";
    PreparedStatement prpStatementCheck = conn.prepareStatement(sqlCheck);
    prpStatementCheck.setString(1, EMP_EMPLOYEE_ID);
    ResultSet rsCheck=prpStatementCheck.executeQuery();
    String check=null;

     while((rsCheck.next())
    {
         if(rsCheck.next()>0)
          update statement; 
         else
             Insert Statement; 
    }

推荐答案

由于EMP_EMPLOYEE_ID字段是INTEGER类型，请使用 setInt 而不是 setString ：

As EMP_EMPLOYEE_ID field is an INTEGER type, use setInt rather than setString:

String sqlCheck = "Select * from [UAP].[dbo].[UAP_EMPLOYEE] where EMP_EMPLOYEE_ID = ?";
PreparedStatement prpStatementCheck = conn.prepareStatement(sqlCheck);
prpStatementCheck.setInt(1, EMP_EMPLOYEE_ID);

这篇关于如果存在ID则更新记录否则插入值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！