?? addfile.java
字號:
package servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
import common.*;
/**
* @author 隋玉杰 E-mail: suiyj1158@hotmail.com
* @version 創建時間:Nov 24, 2008 2:17:13 AM
* 類說明
*/
public class AddFile extends HttpServlet {
public AddFile() {
super();
}
public void destroy() {
super.destroy();
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("gbk");
String c_id=request.getParameter("c_id");
String bumen_id=request.getParameter("bumenid");
String file_describe=request.getParameter("file_describe");//表單得到的軟件描述
String file_name=request.getParameter("file_name");//表單得到的軟件名稱
int type_id=Integer.parseInt(c_id);//把表單得到的String型的c_id轉換成int型
Connection conn=DAO.getConnection();
Statement stmt;
try {
stmt = conn.createStatement();
int maxid=0;//一個int類型,為得到最大id作準備
ResultSet rs=stmt.executeQuery("select max(c_id) from t_file");
if(rs.next()){
maxid=rs.getInt(1);
}
String sql="insert into t_file (c_id,c_name,c_describe,c_typeid,c_hits,c_jointime,c_lasttime,c_isdel,c_departid) values (?,?,?,?,0,getdate(),getdate(),1,?)";
PreparedStatement ps=conn.prepareStatement(sql);
ps.setInt(1,maxid+1);
ps.setString(2,file_name);
ps.setString(3,file_describe);
ps.setInt(4,type_id);
ps.setInt(5,Integer.parseInt(bumen_id));
ps.executeUpdate();
rs.close();
ps.close();
stmt.close();
conn.close();
response.sendRedirect("model/admin/adminindex.jsp?typeid="+type_id);
} catch (SQLException e) {
e.printStackTrace();
}
}
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 + -