没问题就执行,有问题就回滚,设置手动提交。
package Dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import DButil.DBConn;
import DButil.DBConn1;
import entity.User;
public class UerDao {
private static Connection conn = null;
private static PreparedStatement ps = null;
private static ResultSet rs = null;
public static void addUser(User u) {
String sql = "insert into tb_user (username,password)values ('"+u.getUsername()+"','"+u.getPassword()+"')";
conn=DBConn.getConnection();
try {
conn.setAutoCommit(false);
ps=conn.prepareStatement(sql);
ps.executeUpdate();
conn.commit();
System.out.println("添加成功");
} catch (SQLException e) {
e.printStackTrace();
if (conn!=null) {
try {
conn