servicv层:Connection conn = DBUtil.getConnection();
try {
conn.setAutoCommit(false);
dao.Add(conn);
conn.commit();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.closeConn(conn);
}
dao层:public void Add(Connection conn) {
System.out.println("1");
PreparedStatement stat = null;
String sql = "insert into test(id) value(?)";
try {
stat = conn.prepareStatement(sql);
stat.setInt(1, 1);
stat.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}