📄 servlet2.java
字号:
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import com.jxee.blessing.*;
public class servlet2 extends HttpServlet {
static final private String CONTENT_TYPE = "text/html; charset=gb2312";
private ServletConfig config;
/**
* 初始化servlet
*/
final public void init(ServletConfig config) throws ServletException {
this.config = config;
}
final public ServletConfig getServletConfig() {
return config;
}
/**
* 处理 GET 类型请求
*/
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.println("<HTML>");
out.println("<BODY BGCOLOR='white'>");
out.println("<H1>Blessing : Servlet 例子2</H1>");
out.println("<HR><BR>");
out.println("请使用POST方法.");
out.println("</BODY>");
out.println("</HTML>");
}
/**
* 处理 POST 类型请求
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.println("<HTML>");
out.println("<BODY BGCOLOR='white'>");
out.println("<H1>Blessing : Servlet 例子2</H1>");
out.println("<HR>");
FileManager filemanager = new FileManager();
filemanager.init();
filemanager.setSavePath("/upload");
filemanager.upload(request);
out.println("请求上传文件数:" + filemanager.getPageFileCount());
out.println("<br>");
out.println("上传成功文件数:" + filemanager.getSuccessFileCount());
UploadFile uploadFile = new UploadFile();
uploadFile = filemanager.getUploadFile("FILE1");
if (uploadFile != null ){
if (uploadFile.isSuccess()) {
//数据库处理
String jdbcDriver = "com.mysql.jdbc.Driver";
String jdbcURL = "jdbc:mysql://localhost:3306/test";
String user = "root";
String password = "";
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = null;
try {
//注册驱动程序，并连接数据库
Class.forName(jdbcDriver).newInstance();
Connection conn = DriverManager.getConnection(jdbcURL, user, password);
//删除已经存在的图片
sql = "DELETE FROM FILES WHERE ID = 1";
pstmt = conn.prepareStatement(sql);
pstmt.executeUpdate();
//读取图片文件，存入数据库
File file = new File(uploadFile.getFilePath());
FileInputStream fis = new FileInputStream(file);
BufferedInputStream in = new BufferedInputStream(fis);
sql = "INSERT INTO FILES VALUES(?,?,?)";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1,1);
pstmt.setString(2,uploadFile.getFileName());
pstmt.setBinaryStream(3, in, in.available());
pstmt.executeUpdate();
fis.close();
in.close();
file.delete();
//关闭数据库连接
rs.close();
pstmt.close();
conn.close();
}catch (Exception e) {
System.out.println(e.toString());
}
//如果是图片，则显示该图片.请确认已经修改servlet2a.java文件
if (uploadFile.getFileExt().equals("jpg")||uploadFile.getFileExt().equals("gif")){
out.println("<br>");
out.println("<hr>");
out.println("你上传的图片是：");
out.println("<br>");
out.println("<img border='0' src='../blessing/servlet2a?id=1' >");
}
}
}
out.println("</BODY>");
out.println("</HTML>");
}
/**
* 注销servlet
*/
public void destroy () {
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -