java executeupdate_执行完executeUpdate()方法…-体系课

如题：

Servlet代码如下：

package jdbcHomeWork;

import java.io.IOException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import com.mchange.v2.c3p0.ComboPooledDataSource;

/**

* 添加课程的Servlet

*/

@WebServlet("/addCourseServlet")

public class addCourseServlet extends HttpServlet {

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

//  获取请求参数

String name=(String) request.getParameter("name");

String category=(String) request.getParameter("category");

String desp=(String) request.getParameter("desp");

//  封装到课程对象中

Course cou=new Course(name,category,desp);

System.out.println(cou.toString());

//  添加课程

boolean flag=Service.addCourse(cou);

if(flag) {

System.out.println("addCourse方法返回true");

request.getRequestDispatcher("/showCoursesServlet").forward(request, response);

}

else

System.out.println("addCourse方法返回false");

}

Service代码如下：

package jdbcHomeWork;

import java.sql.Connection;

import java.sql.PreparedStatement;

public class Service {

/**

* 添加课程的方法

*

* @param cou

* @return

*/

public static boolean addCourse(Course cou) {

// 添加成功标识

boolean flag = false;

// 数据库连接对象

Connection conn = null;

// 预编译SQL对象

PreparedStatement pstmt = null;

// SQL语句

String sql = "insert into course(name,category,desp,createTime) values(?,?,?,(select now()))";

try {

//   获得数据库连接

conn=ConnectionUtil.getConnection();

System.out.println("获得数据库连接");

//   预编译SQL得到PrepareStatement对象

pstmt=conn.prepareStatement(sql);

System.out.println("预编译SQL得到PrepareStatement对象");

//   给pstmt设置参数

pstmt.setString(1, cou.getName());

pstmt.setString(2, cou.getCategory());

pstmt.setString(3, cou.getDesp());

System.out.println("给pstmt设置参数");

//   执行SQL语句

int i=pstmt.executeUpdate();

System.out.println("SQL语句执行完");

if(i>0) {

flag=true;

System.out.println("插入成功");

}

else

System.out.println("插入失败");

} catch (Exception e) {

e.printStackTrace();

} finally {

//   资源释放

ConnectionUtil.release(conn, pstmt);

}

return flag;

}

}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

doGet(request, response);

}

}

执行后数据库能查到添加的新纪录

控制台输出如下

可以看出在执行executeUpdate方法后，后面的代码就没有继续执行了