欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

jsp实现仿QQ空间新建多个相册名称并向相册中添加照片功能

程序员文章站 2023-11-29 18:16:46
工具: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空间新建多个相册名称并向相册中添加照片功能,希望对大家有所帮助