?? add_type.java
字號:
package servlet;
import java.io.IOException;
import java.sql.*;
import common.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* @author 隋玉杰 E-mail: suiyj1158@hotmail.com
* @version 創建時間:Nov 19, 2008 9:21:20 AM
* 加一個分類
*/
public class add_type extends HttpServlet {
public add_type() {
super();
}
public void destroy() {
super.destroy();
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("GBK");
int fid = Integer.parseInt(request.getParameter("typeid"));
String type_name = request.getParameter("type_name");
String type_describe = request.getParameter("type_describe");
int msg = 0;
if (type_name != null) {
int id = 0;
Connection conn = DAO.getConnection();
Statement stmt;
try {
stmt = conn.createStatement();
java.sql.ResultSet rs = stmt
.executeQuery("select max(c_id) from t_type");
if (rs.next()) {
id = rs.getInt(1);
}
String sql = "insert into t_type (c_id,c_type_name,c_fid,c_describe,c_isdel) values (?,?,?,?,1)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1, id + 1);
ps.setString(2, type_name);
ps.setInt(3, fid);
ps.setString(4, type_describe);
ps.executeUpdate();
String realpath = request.getRealPath("/")
+ GetUrl.geturl(id + 1);
FileOperate fo = new FileOperate();
if (!fo.checkFolder(realpath)) {
sql = "delete from t_type where c_id=" + (id + 1);
stmt.executeUpdate(sql);
msg = 1;
}
ps.close();
rs.close();
stmt.close();
conn.close();
fo.createFolder(realpath);
} catch (SQLException e) {
e.printStackTrace();
}
if (msg == 1) {
request.getSession().setAttribute("error", "aaa");
response.sendRedirect("model/admin/add_type.jsp?typeid=" + fid);
}else
request.getSession().setAttribute("ok", "aaa");
response.sendRedirect("model/admin/adminindex.jsp?typeid=" + fid);
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doGet(request, response);
}
public void init() throws ServletException {
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -