急!! 怎么判断一条sql语句是否被执行成功??
老板要最后执行成功了返回“success”,失败返回“fail”
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String strReturn = "fail";
String method = request.getParameter("method");
if("add".equals(method)){
String driverName = request.getParameter("name");
String driverTel = request.getParameter("tel");
String driverCardId = request.getParameter("cardId");
addDriver(driverName,driverTel,driverCardId);
strReturn = "success"; //这里写法老板说有问题,不能这样赋值。
}
PrintWriter out = response.getWriter();
out.println(strReturn);
out.flush();
out.close();
}
public void addDriver(String driverName,String driverTel,String driverCardId){
DriverSql driverSql = new DriverSql();
driverSql.addDriver(driverName, driverCardId, driverTel);
}
public class DriverSql {
JDBCconnection jdbcconn = new JDBCconnection();
public void addDriver(String name,String cardId,String phone){
jdbcconn.getConn();
Date date = new Date();
SimpleDateFormat dateToStr = new SimpleDateFormat ("yyyy-MM-dd HH:mm");
String strDate = dateToStr.format(date);
System.out.println("date:"+strDate);
String sql = "insert into driver (name,cardId,phone,regtime) " +
"values ('"+name+"', '"+cardId + "', '"+phone + "', '"+strDate+"')";
Statement stmt = jdbcconn.getStmt();
try {
stmt.executeUpdate(sql);//这附近需要怎么写,可以得到一个boolean类型的值。
} catch (SQLException e) {
e.printStackTrace();
}
jdbcconn.closeConn();
}
}
就是怎样在 DriverSql 里给 addDriver方法写成String类型的返回值,