如题：
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方法后，后面的代码就没有继续执行了
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/179821.html原文链接：https://javaforall.net
