各位前辈,我在做练习时发现an=1,但数据就是出不上去,如果输入重复数据an=-1
/**
*
*/
package qh.cic;import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;import qh.Log;
public class UserRegDAO {
int insert(UserRegPO user){
Connection conn=null;
try{
conn=DbUtil.getConnection();
String sql="insert into user_reg values(?,?,?,?)";
PreparedStatement pstmt=conn.prepareStatement(sql);
pstmt.setString(1, user.getUserId());
pstmt.setString(2, user.getName());
pstmt.setString(3, user.getPassword());
pstmt.setString(4, user.getUserType());
int an=pstmt.executeUpdate();
return an;
}catch (Exception e) {
e.printStackTrace();
return -1;
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void main(String[] args) {
UserRegPO user=new UserRegPO("zhanglu1", "张璐", "zhanglu", "学生");
UserRegDAO dao=new UserRegDAO();
int a=dao.insert(user);
Log.getLog().info("a="+a);
}
}
/**
*
*/
package qh.cic;import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;import qh.Log;
public class UserRegDAO {
int insert(UserRegPO user){
Connection conn=null;
try{
conn=DbUtil.getConnection();
String sql="insert into user_reg values(?,?,?,?)";
PreparedStatement pstmt=conn.prepareStatement(sql);
pstmt.setString(1, user.getUserId());
pstmt.setString(2, user.getName());
pstmt.setString(3, user.getPassword());
pstmt.setString(4, user.getUserType());
int an=pstmt.executeUpdate();
return an;
}catch (Exception e) {
e.printStackTrace();
return -1;
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void main(String[] args) {
UserRegPO user=new UserRegPO("zhanglu1", "张璐", "zhanglu", "学生");
UserRegDAO dao=new UserRegDAO();
int a=dao.insert(user);
Log.getLog().info("a="+a);
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货