如果存在ID则更新记录否则插入值

本文介绍了如果存在ID则更新记录否则插入值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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

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);