Why stmt.executeUpdate returns 1 without inserting into the database

t123123

Why stmt.executeUpdate returns 1 without inserting into the database
I took the same sql statement and run it in the query analyzer of sql server, but the data was inserted normally.
Even more strange is if I run the program again and then run the same sql statement in the query analyzer, the automatic number of the inserted record is 2 larger than the previous one, that is, if the automatic number of a previous record is 27, the number of the inserted one is 29, but the one in the program is not inserted! Didn't return any error message, is this what happened? ? ?
Have you ever encountered such a situation?
I took the connection from the datasource and inserted it with a statement

卓越的心

slq posted ~! Also look at your connection. No problem!~

tellyou

Did you commit, is it normal

t123123

The connection is definitely no problem, because the connection is used before
The insertUser method in the User class:
public int insertUser(DataSource ds){
int result=0;
Connection conn;
try {
conn = ds.getConnection();
PreparedStatement pstmt=conn.prepareStatement("insert into tb_customer(username,password,cusTrueName,"+
"cusAddress, cusPostcode, cusProvince, cusCity, cusTel, cusEmail, cusCardType, cusCardNo) "+
"values(?,?,?,?,?,?,?,?,?,?,?)");
pstmt.setString(1,username);
pstmt.setString(2,password);
pstmt.setString(3,cusTrueName);
pstmt.setString(4,cusAddress);
pstmt.setString(5,cusPostcode);
pstmt.setString(6,cusProvince);
pstmt.setString(7,cusCity);
pstmt.setString(8,cusTel);
pstmt.setString(9,cusEmail);
pstmt.setString(10,cusCardType);
pstmt.setString(11,cusCardNo);
pstmt.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return result;
}
}

The execute method in registerAction:
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response){
The
RegisterForm registerForm = (RegisterForm) form;
The
String username=registerForm.getUsername();
String password=registerForm.getPassword();
String cusTrueName=registerForm.getCusTrueName();
String cusAddress=registerForm.getCusAddress();
String cusPostcode=registerForm.getCusPostcode();
String cusProvince=registerForm.getCusProvince();
String cusCity=registerForm.getCusCity();
String cusTel=registerForm.getCusTel();
String cusEmail=registerForm.getCusEmail();
String cusCardType=registerForm.getCusCardType();
String cusCardNo=registerForm.getCusCardNo();
The
ActionMessages errors=new ActionMessages();
DataSource ds=getDataSource(request);
DBUtil dbu=new DBUtil(ds);
if(UserDao.userExist(dbu,username)){
errors.add(ActionMessages.GLOBAL_MESSAGE,
new ActionMessage("errors.username.exist"));
if(!errors.isEmpty()){
saveErrors(request,errors);
}
dbu.close();
return mapping.findForward("failure");
}
dbu.close();
The
User user=new User(username,
password,
cusTrueName,
cusAddress,
cusPostcode,
cusProvince,
cusCity,
cusTel,
cusEmail,
cusCardType,
cusCardNo);

int result=0;
result=user.insertUser(ds);
if(result!=1){
errors.add(ActionMessages.GLOBAL_MESSAGE,
new ActionMessage("errors.insert.failed"));
if(!errors.isEmpty()){
saveErrors(request,errors);
}
return mapping.findForward("failure");
}
HttpSession session=request.getSession();
session.setAttribute("username",username);
The
return mapping.findForward("success");
}

}

t123123

Sorry, I just changed these two paragraphs just now. I accidentally commented out the executeUpdate of pstmt, so I didn’t paste it. It is the same to add executeUpdate before pstmt.

t123123

There is a new discovery, if I change the Connection conn = ds.getConnection() in insertUser to:
Class.forName("net.sourceforge.jtds.jdbc.Driver");
String URL="jdbc:jtds:sqlserver://localhost:1433/db_webshop;user=sa;password=";
Connection conn=DriverManager.getConnection(URL);
The rest is unchanged, so that data can be inserted, which shows that the connection conn = ds.getConnection() has a problem with the conn here, but this conn is not null, and I used this conn in the previous, it can connect to the database normally Yes, what's going on?

wdyssj

Data source configuration file

Is it configured to automatically submit to false,

neo6339

It feels like there is no submission.

t123123

My configuration file looks like this:
<data-source type="org.apache.commons.dbcp.BasicDataSource">
      <set-property property="driverClassName" value="net.sourceforge.jtds.jdbc.Driver"/>
      <set-property property="url" value="jdbc:jtds:sqlserver://localhost:1433/db_webshop"/>
      <set-property property="username" value="sa"/>
      <set-property property="password" value=""/>
      <set-property property="maxActive" value="10"/>
      <set-property property="maxWait" value="5000"/>
      
      <set-property property="minCount" value="4"/>
      <set-property property="maxCount" value="10"/>
      
      <set-property property="defaultAutoCommit" value="false"/>
      <set-property property="defaultReadOnly" value="false"/>
    </data-source>

wdyssj

<set-property property="defaultAutoCommit" value="false"/>

This requires you to submit things in the program [conn.commit()]

If nothing special, set it to true