本文介绍了如果存在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);更多推荐
如果存在ID则更新记录否则插入值
发布评论