adddepart.java

ftp管理。构造网络路径部分比较好。内部有数据库截图。。

package servlet; 

import java.io.IOException;
import common.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
/** 
 * @author 隋玉杰  E-mail: [e-mail]
 * @version 创建时间：Nov 24, 2008 1:43:56 AM 
 * 增加一个部门分类 
 */
public class AddDepart extends HttpServlet {

	public AddDepart() {
		super();
	}

	public void destroy() {
		super.destroy(); 
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("gbk");
		String department=request.getParameter("departname");
		int maxid=0;
		Connection conn = DAO.getConnection();
		Statement stmt=null;
		try {
			stmt = conn.createStatement();
			String sql = "select max(c_id) from t_depart";
			java.sql.ResultSet rs = stmt.executeQuery(sql);
			if (rs.next()) {
				maxid = rs.getInt(1);
			}
			maxid++;
			sql="insert into t_depart (c_id,c_departname) values ("+ maxid +",'"+department+"')";
			stmt.executeUpdate(sql);
			rs.close();
			stmt.close();
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		request.getSession().setAttribute("bumen", "aa");
		response.sendRedirect("model/admin/adminindex.jsp");
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		this.doGet(request, response);
	}
	public void init() throws ServletException {
	}

}