目录
BookEditServlet 点击修改时,获取要修改的图书id
updatebook.jsp 修改界面 在页面显示原有图书信息
列:实现图书增删改查和分页显示图书信息
效果截图:
添加图书
分页显示
上传图片
修改
实现
导包
数据库连接
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;
public class DBUTils {
public static String driver;
public static String url;
public static String user;
public static String password;
public static Properties prop;
static {
try {
prop = new Properties();
prop.load(Thread.currentThread().getContextClassLoader().getResourceAsStream("db.properties"));
driver = prop.getProperty("driver");
url = prop.getProperty("url");
user = prop.getProperty("username");
password = prop.getProperty("password");
System.out.println(
"driver" + driver + "\n" + "url" + url + "\n" + "username" + user + "\n" + "password" + password);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
public static Connection getConn() {
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, password);
System.out.println("conn" + conn);
return conn;
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return null;
}
}
db.properties
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/00web?characterEncoding=UTF-8
username=root
password=123
UploadServlet图片上传
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileUploadException;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import com.demo.po.Book;
import com.demo.service.BookService;
import com.demo.service.BookServiceImpl;
import sun.nio.ch.FileKey;
/**
* Servlet implementation class UploadServlet
*/
public class UploadServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
private BookService bookService=new BookServiceImpl();
/**
* 解析上传的图片路径 图片的信息
*/
// aaa.do
protected void doPost(HttpServletRequest request, HttpServletResponse resp) throws IOException, ServletException {
request.setAttribute("message", "");
request.setAttribute("path", "");
String path;
String filename = null;
// 设置上传图片的保存路径
String savePath = this.getServletContext().getRealPath("/images");
File file = new File(savePath);
// 判断上传文件的保存目录是否存在
if (!file.exists() && !file.isDirectory()) {
System.out.println(savePath + "目录不存在,需要创建");
// 创建目录
file.mkdir();
}
DiskFileItemFactory factory = new DiskFileItemFactory();
// 2、创建一个文件上传解析器
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setHeaderEncoding("UTF-8");
// 3、判断提交上来的数据是否是上传表单的数据
if (!ServletFileUpload.isMultipartContent(request)) {
// 按照传统方式获取数据
return;
}
try {
List<FileItem> list = upload.parseRequest(request);
System.out.println("----list"+list.toString());// 文件的路径 以及保存的路径
for (FileItem item : list) {
filename = item.getName();// 获得一个项的文件名称
if (filename == null || filename.trim().equals("")) {// 如果為空則跳過
continue;
}
// 報錯 需要過濾文件名稱 java.io.FileNotFoundException:
// G:\测试02\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\FaceUp\WEB-INF\images\C:\Users\Ray\Pictures\2.jpeg
// (文件名、目录名或卷标语法不正确。)
filename = filename.substring(filename.lastIndexOf("\\") + 1);
// System.out.print(filename);
if (filename.substring(filename.lastIndexOf(".") + 1).equals("png")
|| filename.substring(filename.lastIndexOf(".") + 1).equals("jpg")
|| filename.substring(filename.lastIndexOf(".") + 1).equals("jpeg")) {
InputStream in = item.getInputStream();// 获取上传的输入流
FileOutputStream out = new FileOutputStream(savePath + "\\" + filename);// 指 定web-inf目錄下的images文件
request.setAttribute("path", "images" + "\\" + filename);
System.out.println("-------图片的路径:"+savePath+ "\\" + filename);
path=savePath+ "\\" + filename;
int len = 0;
byte buffer[] = new byte[1024];
while ((len = in.read(buffer)) > 0)// 每次讀取
{
out.write(buffer, 0, len);
}
in.close();
out.close();
item.delete();
request.setAttribute("message", "上传成功");
/* //获取