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

工具：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空间新建多个相册名称并向相册中添加照片功能，希望对大家有所帮助