用jsp做的简单blog(博客)

package com.blog.service; import java.io.BufferedInputStream; import java.io.BufferedOutputStream; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.sql.Timestamp; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.List; import java.util.Map; import javax.servlet.jsp.jstl.sql.Result; import com.blog.model.Photo; public class PhotoService { public static int insertPhoto(Photo p) { String sql="insert into photo values(?,default,?)"; return DBManager.executeUpdate(sql, p.getAddr(),p.getDesc()); } /**删除数据库中的照片路径*/ public static int deletePhoto(int id) { String sql="delete from photo where id=?"; return DBManager.executeUpdate(sql, id); } /**根据id查询照片*/ public static Photo getPhoto(int id) { String sql="select * from photo where id=?"; Result result=DBManager.executeQuery(sql, id); Map row=result.getRows()[0]; String addr=(String)row.get("addr"); SimpleDateFormat sdf=new SimpleDateFormat("yyyy年MM月dd日 HH:mm:ss"); String createTime=sdf.format(row.get("createTime")); String description=(String)row.get("description"); return new Photo(id,addr,createTime,description); } /**最新照片*/ public static List<Photo> getNewPhotoes(){ String sql="select top 8 * from photo order by createTime desc"; Result result=DBManager.executeQuery(sql); List<Photo> photoList=null; if(result.getRowCount()>0) { Map[] rows=result.getRows(); photoList=new ArrayList<Photo>(); SimpleDateFormat sdf=new SimpleDateFormat("yyyy年MM月dd日 HH:mm:ss"); for(Map row:rows) { int id=(Integer)row.get("id"); String addr=(String)row.get("addr"); Timestamp date=(Timestamp)row.get("createTime"); String createTime=sdf.format(date); String desc=(String)row.get("description"); Photo photo=new Photo(id,addr,createTime,desc); photoList.add(photo); } } return photoList; } public static List<Photo> getAllPhotoes(){ String sql="select * from photo"; Result result=DBManager.executeQuery(sql); List<Photo> photoList=null; if(result.getRowCount()>0) { Map[] rows=result.getRows(); photoList=new ArrayList<Photo>(); SimpleDateFormat sdf=new SimpleDateFormat("yyyy年MM月dd日 HH:mm:ss"); for(Map row:rows) { int id=(Integer)row.get("id"); String addr=(String)row.get("addr"); Timestamp date=(Timestamp)row.get("createTime"); String createTime=sdf.format(date); String desc=(String)row.get("description"); Photo photo=new Photo(id,addr,createTime,desc); photoList.add(photo); } } return photoList; } /**删除服务器中保存的照片*/ public static boolean removePhoto(File file) { if(file!=null&&file.exists()) { return file.delete(); } return false; } /**上传本地照片到服务器*/ public static boolean uploadPhoto(String photo,String newPhoto) { File f=new File(photo); BufferedInputStream bis=null; BufferedOutputStream bos=null; File newF=new File(newPhoto); try { bis=new BufferedInputStream(new FileInputStream(f)); bos=new BufferedOutputStream(new FileOutputStream(newF)); byte[] b=new byte[1024]; int i=0; while((i=bis.read(b))!=-1) { bos.write(b); } bos.flush(); return true; } catch (FileNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { try { bos.close(); bis.close(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return false; } }