jsp实现仿QQ空间新建多个相册名称并向相册中添加照片功能
程序员文章站
2023-10-20 12:38:51
工具:eclipse,oracle,smartupload.jar;语言:jsp,java;数据存储:oracle。
实现功能介绍:
主要是新建相册,可以建多个相册,在...
工具:eclipse,oracle,smartupload.jar;语言:jsp,java;数据存储:oracle。
实现功能介绍:
主要是新建相册,可以建多个相册,在相册中添加多张照片,删除照片,删除相册,当相册下有照片时先删除照片才能删除相册。
因为每个相册和照片要有所属人,所以顺带有登录功能。
声明:只是后端实现代码,前台无任何样式,代码测试可行,仅供参考。
代码:
数据库连接帮助类:
public class jdbchelper { public static final string driver = "oracle.jdbc.driver.oracledriver"; public static final string url = "jdbc:oracle:thin:@localhost:1521:xxxx"; public static final string dbname = "scott"; public static final string password = "xxxx"; public static connection getconn() throws exception{ class.forname(driver); connection conn = drivermanager.getconnection(url, dbname, password); return conn; } }
图片上传时,要修改图片名称,防止上传重名图片将上一张覆盖,这里的做法是将图片名改为由用户id和精确到毫秒的时间组成,修改图片名的帮助类:
public class photoname { private string ip; public photoname(string ip) { super(); this.ip = ip; } public string getip() { return ip; } public void setip(string ip) { this.ip = ip; } public string gettime(){ date date = new date(); dateformat df = new simpledateformat("yyyymmddhhmmsssss"); return df.format(date); } public string getphotoname(){ return this.ip + this.gettime(); } }
实现所有这些的接口类:
public interface updao { /** * 创建相册名称 * */ public int crealbum(albumpojo ap); /** *显示所创建的所有相册名称 */ public list<albumpojo> findallalbum(int id); public list<photopojo> findallphoto(int id); /** * 上传照片 */ public int upphoto(photopojo pp); /** * 删除相册 * @param id 相册id * @return */ public int delalbum(int id); /** * 删除照片 * @param id 照片id * @return */ public int delphoto(int id); /** * 登录 * @param username * @param password * @return */ public userpojo login(string username,string password); }
接口的具体实现类:
public class updaoimpl implements updao { /* (non-javadoc) * @see cn.jvsun.dao.updao#crealbum(cn.jvsun.pojo.albumpojo) * 创建相册名称 */ public int crealbum(albumpojo ap) { int albumnum=this.getalbumnum(); connection conn = null; preparedstatement pstate = null; try { conn=jdbchelper.getconn(); conn.setautocommit(false); string sql="insert into album(id,a_name,user_id)values(?,?,?)"; pstate = conn.preparestatement(sql); pstate.setint(1, albumnum); pstate.setstring(2,ap.geta_name()); pstate.setint(3, ap.getuser_id()); pstate.execute(); conn.commit(); } catch (exception e) { e.printstacktrace(); try { conn.rollback();//出问题就撤回,全不提交 } catch (sqlexception e1) { e1.printstacktrace(); } }finally{ try { pstate.close(); conn.close(); } catch (sqlexception e) { e.printstacktrace(); } } return albumnum; } /* (non-javadoc) * @see cn.jvsun.dao.updao#upphoto(java.lang.string, java.lang.string, int) * 上传照片 */ public int upphoto(photopojo pp) { int pnum=this.getphotonum(); connection conn = null; preparedstatement pstate = null; try { conn=jdbchelper.getconn(); conn.setautocommit(false); string sql="insert into photo(id,p_name,p_url,p_albumid)values(?,?,?,?)"; pstate = conn.preparestatement(sql); pstate.setint(1, pnum); pstate.setstring(2,pp.getp_name()); pstate.setstring(3, pp.getp_url()); pstate.setint(4, pp.getp_albumid()); pstate.execute(); conn.commit(); } catch (exception e) { e.printstacktrace(); try { conn.rollback();//出问题就撤回,全不提交 } catch (sqlexception e1) { e1.printstacktrace(); } }finally{ try { pstate.close(); conn.close(); } catch (sqlexception e) { e.printstacktrace(); } } return pnum; } /* (non-javadoc) * @see cn.jvsun.dao.updao#delalbum(int) * 删除相册 */ public int delalbum(int id) { int result=0; connection conn = null; preparedstatement pstate = null; string sql="delete from album where id="+id+""; try { conn=jdbchelper.getconn(); pstate = conn.preparestatement(sql); result=pstate.executeupdate(); } catch (sqlexception e) { e.printstacktrace(); } catch (exception e) { // todo auto-generated catch block e.printstacktrace(); }finally{ try { pstate.close(); conn.close(); } catch (sqlexception e) { // todo auto-generated catch block e.printstacktrace(); } } return result; } /* (non-javadoc) * @see cn.jvsun.dao.updao#delphoto(int) * 删除照片 */ public int delphoto(int id) { int result=0; connection conn = null; preparedstatement pstate = null; string sql="delete from photo where id="+id+""; try { conn=jdbchelper.getconn(); pstate = conn.preparestatement(sql); result=pstate.executeupdate(); } catch (sqlexception e) { e.printstacktrace(); } catch (exception e) { // todo auto-generated catch block e.printstacktrace(); }finally{ try { pstate.close(); conn.close(); } catch (sqlexception e) { // todo auto-generated catch block e.printstacktrace(); } } return result; } /* (non-javadoc) * @see cn.jvsun.dao.updao#login(java.lang.string, java.lang.string) * 用户登录 */ public userpojo login(string username, string password) { userpojo user=null; connection conn = null; preparedstatement pstate = null; resultset res = null; try { conn=jdbchelper.getconn(); string sql="select id,username from userinfo where username=? and password=?"; pstate = conn.preparestatement(sql); pstate.setstring(1, username); pstate.setstring(2, password); res = pstate.executequery(); while(res.next()){ user=new userpojo(res.getint(1),username,null); } } catch (exception e) { e.printstacktrace(); }finally{ try { res.close(); pstate.close(); conn.close(); } catch (sqlexception e) { e.printstacktrace(); } } return user; } /** * 相册序列号 */ public int getalbumnum(){ int albumnum=-1; connection conn = null; preparedstatement pstate = null; resultset res = null; try { conn=jdbchelper.getconn(); string sql="select aid.nextval from dual"; pstate=conn.preparestatement(sql); res=pstate.executequery(); while(res.next()){ albumnum=res.getint(1); } } catch (exception e) { e.printstacktrace(); }finally{ try { res.close(); pstate.close(); conn.close(); } catch (sqlexception e) { e.printstacktrace(); } } return albumnum; } /** *照片序列号 */ public int getphotonum(){ int photonum=-1; connection conn = null; preparedstatement pstate = null; resultset res = null; try { conn=jdbchelper.getconn(); string sql="select pid.nextval from dual"; pstate=conn.preparestatement(sql); res=pstate.executequery(); while(res.next()){ photonum=res.getint(1); } } catch (exception e) { e.printstacktrace(); }finally{ try { res.close(); pstate.close(); conn.close(); } catch (sqlexception e) { e.printstacktrace(); } } return photonum; } /* (non-javadoc) * @see cn.jvsun.dao.updao#findall() * 显示所创建的相册名 */ public list<albumpojo> findallalbum(int id) { list<albumpojo> list= new arraylist<albumpojo>(); connection conn = null; preparedstatement pstate = null; resultset res = null; try { conn=jdbchelper.getconn(); string sql="select id,a_name,user_id from album where user_id=?"; pstate = conn.preparestatement(sql); pstate.setint(1, id); res = pstate.executequery(); while(res.next()){ albumpojo ap=new albumpojo(res.getint(1),res.getstring(2),res.getint(3)); list.add(ap); } } catch (exception e) { e.printstacktrace(); }finally{ try { res.close(); pstate.close(); conn.close(); } catch (sqlexception e) { e.printstacktrace(); } } return list; } /* (non-javadoc) * @see cn.jvsun.dao.updao#findallphoto(int) * 显示照片 */ public list<photopojo> findallphoto(int aid) { list<photopojo> list= new arraylist<photopojo>(); connection conn = null; preparedstatement pstate = null; resultset res = null; try { conn=jdbchelper.getconn(); string sql="select id,p_name,p_url from photo where p_albumid=?"; pstate = conn.preparestatement(sql); pstate.setint(1, aid); res = pstate.executequery(); while(res.next()){ photopojo pojo=new photopojo(res.getint(1),res.getstring(2),res.getstring(3), aid); list.add(pojo); } } catch (exception e) { e.printstacktrace(); }finally{ try { res.close(); pstate.close(); conn.close(); } catch (sqlexception e) { e.printstacktrace(); } } return list; } }
用户,相册,照片三个pojo类:
/** * 用户实体类 * */ public class userpojo implements serializable{ private static final long serialversionuid = 7554548269035753256l; private int id; private string username; private string password; public int getid() { return id; } public void setid(int id) { this.id = id; } public string getusername() { return username; } public void setusername(string username) { this.username = username; } public string getpassword() { return password; } public void setpassword(string password) { this.password = password; } public userpojo(int id, string username, string password) { super(); this.id = id; this.username = username; this.password = password; } public userpojo(string username, string password) { this.username = username; this.password = password; } public userpojo() { super(); // todo auto-generated constructor stub } }
/** * 相册实体类 * */ public class albumpojo implements serializable{ private int id; private string a_name; private int user_id; public int getid() { return id; } public void setid(int id) { this.id = id; } public string geta_name() { return a_name; } public void seta_name(string a_name) { this.a_name = a_name; } public int getuser_id() { return user_id; } public void setuser_id(int user_id) { this.user_id = user_id; } public albumpojo(int id, string a_name, int user_id) { super(); this.id = id; this.a_name = a_name; this.user_id = user_id; } public albumpojo(string a_name, int user_id) { this.a_name = a_name; this.user_id = user_id; } public albumpojo() { super(); // todo auto-generated constructor stub } }
/** *照片实体类 * */ public class photopojo implements serializable{ private static final long serialversionuid = 5937149639009957458l; private int id; private string p_name; private string p_url; private int p_albumid; public int getid() { return id; } public void setid(int id) { this.id = id; } public string getp_name() { return p_name; } public void setp_name(string p_name) { this.p_name = p_name; } public string getp_url() { return p_url; } public void setp_url(string p_url) { this.p_url = p_url; } public int getp_albumid() { return p_albumid; } public void setp_albumid(int p_albumid) { this.p_albumid = p_albumid; } public photopojo(int id, string p_name, string p_url, int p_albumid) { super(); this.id = id; this.p_name = p_name; this.p_url = p_url; this.p_albumid = p_albumid; } public photopojo(string p_name, string p_url, int p_albumid) { this.p_name = p_name; this.p_url = p_url; this.p_albumid = p_albumid; } public photopojo() { super(); // todo auto-generated constructor stub } }
login.jsp实现登录
<%@ page language="java" import="java.util.*" pageencoding="utf-8"%> <%@ page import="cn.jvsun.dao.impl.*" %> <%@ page import="cn.jvsun.pojo.*" %> <%@ page import="cn.jvsun.dao.*" %> <% string path = request.getcontextpath(); string basepath = request.getscheme()+"://"+request.getservername()+":"+request.getserverport()+path+"/"; %> <!doctype html public "-//w3c//dtd html 4.01 transitional//en"> <html> <head> <base href="<%=basepath%>" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" > <title>login</title> </head> <body> <% request.setcharacterencoding("utf-8"); string action=request.getparameter("action"); updao ud=new updaoimpl(); string username=request.getparameter("username"); string password=request.getparameter("password"); userpojo pojo=ud.login(username, password); if("log".equals(action)){ if(pojo==null){ %> <h1>登录失败</h1> <% }else{ request.getsession().setattribute("username", username); request.getsession().setattribute("userid", pojo.getid()); response.sendredirect("index.jsp"); } } %> <form action="login.jsp?action=log" method="post"> <input type="text" name="username" placeholder="请输入用户名"/> <input type="password" name="password" placeholder="请输入密码"/> <input type="submit"/> </form> </body> </html>
index.jsp实现显示相册
代码如下:
<%@ page language="java" import="java.util.*" pageencoding="utf-8"%> <%@ page import="cn.jvsun.dao.impl.*" %> <%@ page import="cn.jvsun.pojo.*" %> <%@ page import="cn.jvsun.dao.*" %> <% string path = request.getcontextpath(); string basepath = request.getscheme()+"://"+request.getservername()+":"+request.getserverport()+path+"/"; %> <!doctype html public "-//w3c//dtd html 4.01 transitional//en"> <html> <head> <base href="<%=basepath%>" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" > <title>person message</title> </head> <body> <center>相册界面</center> 当前用户:<%=request.getsession().getattribute("username")%> <br> <a href="cre.jsp" rel="external nofollow" >去创建相册</a><br> 我的所有相册:<br> <% int userid=(integer)request.getsession().getattribute("userid"); updao dao=new updaoimpl(); list<albumpojo> list=dao.findallalbum(userid); for(albumpojo pojo:list){ %> <tr> <a>相册id:</a><td><%=pojo.getid() %></td> <a>相册名称:</a><td><%=pojo.geta_name() %></td> <a>创建者id:</a><td><%=pojo.getuser_id() %></td> <td><a href="up.jsp?aid=<%=pojo.getid() %>" rel="external nofollow" >添加照片</a></td> <td><a href="show.jsp?phid=<%=pojo.getid() %>" rel="external nofollow" >查看照片</a></td> <td><a href="del.jsp?aid=<%=pojo.getid() %>" rel="external nofollow" >删除相册</a></td> </tr><br> <% } %> </body> </html>
cre.jsp创建相册
<%@ page language="java" import="java.util.*" pageencoding="utf-8"%> <%@ page import="cn.jvsun.dao.impl.*" %> <%@ page import="cn.jvsun.pojo.*" %> <%@ page import="cn.jvsun.dao.*" %> <% string path = request.getcontextpath(); string basepath = request.getscheme()+"://"+request.getservername()+":"+request.getserverport()+path+"/"; %> <!doctype html public "-//w3c//dtd html 4.01 transitional//en"> <html> <head> <base href="<%=basepath%>" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" > <title>up photo</title> </head> <body> <% request.setcharacterencoding("utf-8"); string action=request.getparameter("action"); updao ud=new updaoimpl(); string tocre=request.getparameter("cre"); int userid=(integer)request.getsession().getattribute("userid"); if("cre".equals(action)){ albumpojo ap=new albumpojo(tocre,userid); int anum=ud.crealbum(ap); if(anum!=-1){ response.sendredirect("index.jsp"); }else{ %> <h1>创建相册失败</h1> <% } } %> <form action="cre.jsp?action=cre" method="post"> <input type="text" name="cre" placeholder="请输入您要创建的相册名称"/> <input type="submit" value="确定"> </form> </body> </html>
up.jsp上传照片
<%@ page language="java" import="java.util.*" pageencoding="utf-8"%> <%@ page import="cn.jvsun.dao.impl.*" %> <%@ page import="cn.jvsun.pojo.*" %> <%@ page import="cn.jvsun.dao.*" %> <%@ page import="cn.jvsun.tools.*" %> <%@page import="org.lxh.smart.*" %> <% string path = request.getcontextpath(); string basepath = request.getscheme()+"://"+request.getservername()+":"+request.getserverport()+path+"/"; %> <!doctype html public "-//w3c//dtd html 4.01 transitional//en"> <html> <head> <base href="<%=basepath%>" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" > <title>上传照片</title> </head> <body> <% int aid=integer.parseint(request.getparameter("aid")); %> <form action="upcheck.jsp" method="post" enctype="multipart/form-data"> <input type="hidden" name="aid" value="<%=aid %>"/> <input type="file" name="photo"/> <input type="submit" value="确认上传"/> </form> </body> </html>
upcheck.jsp上传照片的处理页
<%@ page language="java" import="java.util.*" pageencoding="utf-8"%> <%@ page import="cn.jvsun.dao.impl.*" %> <%@ page import="cn.jvsun.pojo.*" %> <%@ page import="cn.jvsun.dao.*" %> <%@ page import="cn.jvsun.tools.*" %> <%@page import="org.lxh.smart.*" %> <!doctype html public "-//w3c//dtd html 4.01 transitional//en"> <html> <head> <title></title> </head> <body> <% string ip = request.getremoteaddr(); ip = ip.replaceall(":",""); photoname pn=new photoname(ip); string pname = pn.getphotoname();//照片名字,是由ip加当前时间组成 smartupload smartupload = new smartupload();//实例化上传操作的对象 //初始化上传文件 smartupload.initialize(pagecontext); //准备上传 smartupload.upload(); int albumid=integer.parseint(smartupload.getrequest().getparameter("aid")); //取得文件的后缀 string endname = smartupload.getfiles().getfile(0).getfileext(); //文件保存的路径 /*string p_url = getservletcontext().getrealpath("/")+ "file/"+pname+"."+endname;*/ string p_url="k:/workspace/xiangce/webroot/file/"+pname+"."+endname; //保存文件 smartupload.getfiles().getfile(0).saveas(p_url); updao ad=new updaoimpl(); photopojo pojo=new photopojo(pname+"."+endname,p_url,albumid); int photonum=ad.upphoto(pojo); if(photonum != -1){ request.getsession().setattribute("phid", albumid); response.sendredirect("show.jsp"); } else { %> 上传失败 <% } %> </body> </html>
show.jsp显示照片及信息页:
代码如下:
<%@ page language="java" import="java.util.*" pageencoding="utf-8"%> <%@ page import="cn.jvsun.dao.impl.*" %> <%@ page import="cn.jvsun.pojo.*" %> <%@ page import="cn.jvsun.dao.*" %> <% string path = request.getcontextpath(); string basepath = request.getscheme()+"://"+request.getservername()+":"+request.getserverport()+path+"/"; %> <!doctype html public "-//w3c//dtd html 4.01 transitional//en"> <html> <head> <base href="<%=basepath%>" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" > <title>my jsp 'show.jsp' starting page</title> </head> <body> <center>相册界面</center> 当前用户:<%=request.getsession().getattribute("username")%> <br> <% int phid=(integer)request.getsession().getattribute("phid"); updao dao=new updaoimpl(); list<photopojo> list=dao.findallphoto(phid); for(photopojo pojo:list){ %> <tr> <a>照片id:</a><td><%=pojo.getid() %></td><br> <a>照片名称:</a><td><%=pojo.getp_name() %></td><br> <a>照片路径:</a><td><%=pojo.getp_url() %></td><br> <a>照片所属相册名称:</a><td><%=pojo.getp_albumid() %></td><br> <td><img src="<%=path%>/file/<%=pojo.getp_name() %>" width="100" height="100"/></td> <a href="photo_del.jsp?pid=<%=pojo.getid() %>" rel="external nofollow" >删除照片:</a></td><br> </tr><br> <%} %> </body> </html>
photo_del.jsp删除照片
<%@ page language="java" import="java.util.*" pageencoding="utf-8"%> <%@ page import="cn.jvsun.dao.impl.*" %> <%@ page import="cn.jvsun.pojo.*" %> <%@ page import="cn.jvsun.dao.*" %> <% string path = request.getcontextpath(); string basepath = request.getscheme()+"://"+request.getservername()+":"+request.getserverport()+path+"/"; %> <!doctype html public "-//w3c//dtd html 4.01 transitional//en"> <html> <head> <base href="<%=basepath%>" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" > <title>del</title> </head> <body> <% int pid=integer.parseint(request.getparameter("pid")); int result=0; updao dao=new updaoimpl(); result=dao.delphoto(pid); if(result==1){ out.println("<script>alert('删除成功');window.location.href('show.jsp');</script>"); }else{ out.println("<script>alert('出错了');window.location.href('show.jsp');</script>"); } %> </body> </html>
del.jsp删除相册
<%@ page language="java" import="java.util.*" pageencoding="utf-8"%> <%@ page import="cn.jvsun.dao.impl.*" %> <%@ page import="cn.jvsun.pojo.*" %> <%@ page import="cn.jvsun.dao.*" %> <% string path = request.getcontextpath(); string basepath = request.getscheme()+"://"+request.getservername()+":"+request.getserverport()+path+"/"; %> <!doctype html public "-//w3c//dtd html 4.01 transitional//en"> <html> <head> <base href="<%=basepath%>" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" > <title>del</title> </head> <body> <% int aid=integer.parseint(request.getparameter("aid")); int result=0; updao dao=new updaoimpl(); result=dao.delalbum(aid); if(result==1){ out.println("<script>alert('删除成功');window.location.href('index.jsp');</script>"); }else{ out.println("<script>alert('删除失败,请先把相册中的照片删掉');window.location.href('index.jsp');</script>"); } %> </body> </html>
数据库的建表语句:
-- create table create table userinfo ( id number, username varchar2(30), password varchar2(30) ) tablespace users pctfree 10 initrans 1 maxtrans 255 storage ( initial 64 minextents 1 maxextents unlimited ); -- create/recreate primary, unique and foreign key constraints alter table userinfo add constraint pid primary key (id) disable; --上传者 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -- create table create table album ( id number not null, a_name varchar2(30), user_id number ) tablespace users pctfree 10 initrans 1 maxtrans 255 storage ( initial 64 minextents 1 maxextents unlimited ); -- create/recreate primary, unique and foreign key constraints alter table album add constraint al_pid primary key (id) using index tablespace users pctfree 10 initrans 2 maxtrans 255 storage ( initial 64k minextents 1 maxextents unlimited ); alter table album add constraint userid foreign key (user_id) references userinfo (id) disable; --相册表 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -- create table create table photo ( id number, p_name varchar2(30), p_url varchar2(50), p_albumid number(30) ) tablespace users pctfree 10 initrans 1 maxtrans 255 storage ( initial 64 minextents 1 maxextents unlimited ); -- create/recreate primary, unique and foreign key constraints alter table photo add constraint alb_id foreign key (p_albumid) references album (id); --相片表
好了,所有代码就写完了,切记,需要smartupload.jar包,没有的童鞋可以去下载:
以上所述是小编给大家介绍的jsp实现仿qq空间新建多个相册名称并向相册中添加照片功能,希望对大家有所帮助
下一篇: 一小偷类!!有兴趣的可以看看