package com.i.servlet;

import java.io.IOException;

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.i.domain.Course;

import com.i.service.CourseManage;

import com.i.service.impl.CourseManageImpl;

@WebServlet("/InsertServlet")

public class InsertServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

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

//接受参数

String courseName = request.getParameter("coursename");

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

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

//封装数据

Course course=new Course();

course.setName(courseName);

course.setCategory(category);

course.setComment(desp);

//处理数据

CourseManage courseManager = new CourseManageImpl();

boolean flag = courseManager.addCourse(course);

if(flag) {

//成功跳转至显示所有课程页面

response.sendRedirect(request.getContextPath()+"/showCourse.jsp");

}else {

response.sendRedirect(request.getContextPath()+"/fail.jsp");

}

}

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

// TODO Auto-generated method stub

doGet(request, response);

}

}

package com.i.utils;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class JDBCUtils {

private static final ComboPooledDataSource dataSource = new ComboPooledDataSource();

public static Connection getConnection() throws SQLException {

Connection conn = dataSource.getConnection();

return conn;

}

/**

* 资源的释放

*/

public static void release(Statement stmt,Connection conn) {

if(stmt != null) {

try {

stmt.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

stmt = null;

}

if(conn != null) {

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

conn = null;

}

}

public static void release(ResultSet rs,Statement stmt,Connection conn) {

if(rs != null) {

try {

rs.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

rs = null;

}

if(stmt != null) {

try {

stmt.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

stmt = null;

}

if(conn != null) {

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

conn = null;

}

}

}