前言
这个项目是我上学时做的期末作业作品，当时没有源代码管理的习惯，所以源码已经丢失，仅留下这篇笔记。原文发在了 CSDN 上，最近在整理博客，所以手动整理在了这里。
项目文档
项目运行截图
项目用到的相关知识
JSP 动态页面，CSS 样式，Struts2，Hibernate，SQL Server
项目运行步骤
在 Myeclipse 里发布项目，并启动 Tomcat。
打开 Chrome，在地址栏输入 http://localhost:8080/项目名/
输入数据库内预存的用户名密码，以及当前生成的验证码即可登录。
项目构建步骤
新建项目
构建 Struts2 环境。将 Struts2 所需的 jar 包拷入 WebRoot->WEB-INF->lib 中
在src目录下创建 struts.xml
内容如下：
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.5//EN"
"http://struts.apache.org/dtds/struts-2.5.dtd">
<struts>
<package name="default" extends="struts-default">
</package>
<constant name="struts.i18n.encoding" value="UTF-8"></constant>
</struts>
将 WebRoot->WEB-INF->web.xml 内容修改如下：
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
<display-name>aa</display-name>
<!-- Filters -->
<!-- START SNIPPET: filter -->
<filter>
<filter-name>action</filter-name>
<filter-class>org.apache.struts2.dispatcher.filter.StrutsPrepareAndExecuteFilter</filter-class>
</filter>
<!-- END SNIPPET: filter -->
<filter-mapping>
<filter-name>action</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<welcome-file-list>
<welcome-file>login.jsp</welcome-file>
</welcome-file-list>
</web-app>
将 SQL Server 驱动拷入 WebRoot->WEB-INF->lib 中。（sqljdbc42.jar）
建立数据库
右键数据库 -> 新建数据库
打开数据库AA，点击新建查询。
输入如下 SQL 语句。
create table userTable
(
id int identity(1,1) primary key not null,
username varchar(20) not null,
password varchar(50) not null,
email varchar(20) not null,
birthday date not null,
idnumber varchar(20) not null,
sex varchar(10) not null,
qualify varchar(50) not null
)
create table musicTable
(
id int identity(1,1) primary key not null,
uploader varchar(20) not null,
songtitle varchar(30) not null,
singer varchar(30) not null,
songimg varchar(20) not null,
audiolength varchar(20) not null,
songarea varchar(20) not null
)
insert into userTable values('root','root0000','root@163.com','1995-01-06','140211199701253265','男','大学本科')
insert into userTable values('root1','root10000','root1@163.com','1995-02-06','140211199801253265','女','大学本科')
insert into userTable values('root2','root20000','root2@163.com','1995-03-06','140211199901253265','男','专科')
insert into userTable values('root3','root30000','root3@163.com','1995-04-06','140211199001253265','女','大学本科')
insert into userTable values('root4','root40000','root4@163.com','1995-05-06','140211199701253265','男','大学本科')
insert into musicTable values('root','圣诞又至','鹿晗','1.jpg','04:40','内地')
insert into musicTable values('root1','狐狸','薛之谦','2.jpg','03:40','内地')
insert into musicTable values('root2','绒花','韩红','3.jpg','04:40','内地')
insert into musicTable values('root3','感觉自己是巨星','毛不易','4.jpg','04:30','内地')
insert into musicTable values('root4','易燃易爆炸','陈粒','5.jpg','04:40','内地')
insert into musicTable values('root','我在未来等你','齐秦','6.jpg','03:40','港台')
insert into musicTable values('root1','灰色 ','徐佳莹','7.jpg','04:40','港台')
insert into musicTable values('root2','叙述','毛不易','8.jpg','04:30','港台')
insert into musicTable values('root3','他不知道','陈志朋','9.jpg','03:40','港台')
insert into musicTable values('root4','凤凰于飞','林俊杰','10.jpg','04:43','港台')
insert into musicTable values('root','We Are The Brave','Lenka','11.jpg','04:40','欧美')
insert into musicTable values('root1','Thuunder','Dragons','12.jpg','03:40','欧美')
insert into musicTable values('root2','Perfect Duct','Beyonce','13.jpg','04:43','欧美')
insert into musicTable values('root3','Again Noah','Cyrus ','14.jpg','04:40','欧美')
insert into musicTable values('root4','Stir Fry','Migos','15.jpg','03:40','欧美')
insert into musicTable values('root','道','宇多田','16.jpg','04:30','日本')
insert into musicTable values('root1','Welcome To Tokyo','三代目','17.jpg','04:40','日本')
insert into musicTable values('root2','恋','星野源','18.jpg','04:40','日本')
insert into musicTable values('root3','极乐净土','GarniDelia','19.jpg','04:40','日本')
insert into musicTable values('root4','GoodBye Happiness','宇多田','20.jpg','04:40','日本')
insert into musicTable values('root','苦恼','Gary','21.jpg','04:40','韩国')
insert into musicTable values('root1','Birthday Remix','朴宰范','22.jpg','04:40','韩国')
insert into musicTable values('root2','Do My Thing','Beon','23.jpg','04:40','韩国')
insert into musicTable values('root3','Hello','SecenTeen','24.jpg','04:40','韩国')
insert into musicTable values('root4','I Just Red ','Velvet','25.jpg','04:40','韩国')
单击执行
右键登录名 -> 新建登录名
单击确定
连接对象资源管理器
Myeclipse连接数据库
右键 -> new
在src目录下建立四个包：action、bean、config、method
配置 Hibernate 环境
Hibernate 自动关联数据库
结束之后，目录是这样。
在 WebRoot 目录下建立 JSP 页面：
- add.jsp
- del.jsp
- error.jsp
- hongkong.jsp
- japan.jsp
- korea.jsp
- local.jsp
- login.jsp
- main.jsp
- prelogout.jsp
- register.jsp
- registersucc.jsp
- result.jsp
- update.jsp
- usa.jsp
各页面内容如下：
add.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>主页</title>
<link rel="stylesheet" type="text/css" href="css/style1.css">
</head>
<body>
<div class="head">
<div class="headcenter">
<div class="logo-box">
<a class="logo" ref="#"><img width="97" height="60" src="img/logo.png"></a>
</div>
<div class="search-box">
<div class="search bar7">
<s:form action="search">
<input type="text" placeholder="请输入歌曲名称..." name="keyString">
<button type="submit"></button>
</s:form>
</div>
</div>
<div class="center-box"></div>
<div class="reset">
<ul>
<li>
<a href="prelogout.jsp">注销</a>
</li>
</ul>
</div>
</div>
</div>
<div class="banner">
<div class="banner-center">
<div class="banner-li-box">
<ul>
<li><s:a href="find">首页</s:a></li>
<li><s:a href="local">流行</s:a></li>
<li><s:a href="hongkong">摇滚</s:a></li>
<li><s:a href="usa">民族</s:a></li>
<li><s:a href="japan">轻音乐</s:a></li>
<li><s:a href="korea">蓝调</s:a></li>
</ul>
</div>
</div>
<div class="banner-li-box-center"></div>
<div class="downandadd">
<ul>
<li>
<a href="createMusicList">下载</a>
</li>
<li>
<a href="add.jsp">添加</a>
</li>
</ul>
</div>
</div>
<div class="main">
<div class="main-center">
<div class="center-up-up">
<h2>添加歌曲</h2>
</div>
<div class="center-up">
<div class="song-box">
<s:form id="formf" method="post" theme="simple" action="upload"
enctype="multipart/form-data">
<table>
<tr>
<td>歌曲名称:<s:textfield id="inp" label="歌曲名称" name="music.songtitle"></s:textfield>
</td>
</tr>
<tr>
<td>歌手名字:<s:textfield id="inp" label="歌手名字" name="music.singer"></s:textfield></td>
</tr>
<tr>
<td>歌曲封面:<s:file id="inp" label="歌曲封面" name="upload" /></td>
</tr>
<tr>
<td>歌曲地区:<s:select id="inp" list="#{'内地':'内地','港台':'港台','欧美':'欧美','日本':'日本','韩国':'韩国'}" headerValue="请选择歌曲地区" name="music.songarea">
</s:select></td>
</tr>
<tr>
<td>歌曲时长:<s:textfield id="inp" label="歌曲时长" name="music.audiolength"></s:textfield></td>
</tr>
<tr>
<td>上传用户:<s:textfield id="inp" label="上传用户" name="music.uploader"></s:textfield></td>
</tr>
<tr>
<td><s:submit id="submit" value="添加" /></td>
</tr>
</table>
</s:form>
</div>
</div>
<div class="center-down">
</div>
</div>
</div>
<div class="footer">
<h4>王骏©期末作品</h4>
</div>
</body>
</html>
del.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>主页</title>
<link rel="stylesheet" type="text/css" href="css/style1.css">
</head>
<body>
<div class="head">
<div class="headcenter">
<div class="logo-box">
<a class="logo" href="#"><img width="97" height="60" src="img/logo.png"></a>
</div>
<div class="search-box">
<div class="search bar7">
<s:form action="search">
<input type="text" placeholder="请输入歌曲名称..." name="keyString">
<button type="submit"></button>
</s:form>
</div>
</div>
<div class="center-box"></div>
<div class="reset">
<ul>
<li>
<a href="prelogout.jsp">注销</a>
</li>
</ul>
</div>
</div>
</div>
<div class="banner">
<div class="banner-center">
<div class="banner-li-box">
<ul>
<li><s:a href="find">首页</s:a></li>
<li><s:a href="local">流行</s:a></li>
<li><s:a href="hongkong">摇滚</s:a></li>
<li><s:a href="usa">民族</s:a></li>
<li><s:a href="japan">轻音乐</s:a></li>
<li><s:a href="korea">蓝调</s:a></li>
</ul>
</div>
</div>
<div class="banner-li-box-center"></div>
<div class="downandadd">
<ul>
<li>
<a href="createMusicList">下载</a>
</li>
<li>
<a href="add.jsp">添加</a>
</li>
</ul>
</div>
</div>
<div class="main">
<div class="main-center">
<div class="center-up-up">
<h2>是否确定删除歌曲?</h2>
</div>
<div class="center-up">
<div class="song-box">
<s:form id="formf" method="post" action="del">
<table>
<tr>
<td><s:textfield id="inp" label="歌曲所在页码" name="pageNum"></s:textfield></td>
</tr>
<tr>
<td><s:textfield id="inp" label="歌曲id" name="music.id"></s:textfield></td>
</tr>
<tr>
<td><s:submit id="submit" value="确定删除" /></td>
</tr>
</table>
</s:form>
</div>
</div>
<div class="center-down">
</div>
</div>
</div>
<div class="footer">
<h4>王骏©期末作品</h4>
</div>
</body>
</html>
error.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html>
<html>
<head>
<title>error</title>
</head>
<body>
error!
</body>
</html>
hongkong.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>hongkong</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
<div class="head">
<div class="headcenter">
<div class="logo-box">
<a class="logo" ref="#"><img width="97" height="60" src="img/logo.png"></a>
</div>
<div class="search-box">
<div class="search bar7">
<s:form action="search">
<input type="text" placeholder="请输入歌曲名称..." name="keyString">
<button type="submit"></button>
</s:form>
</div>
</div>
<div class="center-box"></div>
<div class="reset">
<ul>
<li>
<a href="prelogout.jsp">注销</a>
</li>
</ul>
</div>
</div>
</div>
<div class="banner">
<div class="banner-center">
<div class="banner-li-box">
<ul>
<li><s:a href="find">首页</s:a></li>
<li><s:a href="local">流行</s:a></li>
<li><s:a href="hongkong">摇滚</s:a></li>
<li><s:a href="usa">民族</s:a></li>
<li><s:a href="japan">轻音乐</s:a></li>
<li><s:a href="korea">蓝调</s:a></li>
</ul>
</div>
</div>
<div class="banner-li-box-center"></div>
<div class="downandadd">
<ul>
<li>
<a href="createMusicList">下载</a>
</li>
<li>
<a href="add.jsp">添加</a>
</li>
</ul>
</div>
</div>
<div class="main">
<div class="main-center">
<div class="center-up-up">
<h2>摇滚 共有<s:property value="Amount2" />首歌曲</h2>
</div>
<div class="center-up">
<div class="song-box">
<s:iterator value="list" var="music">
<div class="song">
<div class="one">
<img alt="图片"
src="${pageContext.servletContext.contextPath}/img/${songimg}" /></div>
<div class="two">
<div class="two-1">
<h4><s:property value="#music.songtitle" /></h4>
</div>
<div class="two-2">
<h4><s:property value="#music.singer" /></h4>
</div>
<div class="two-3">
<h4><s:property value="#music.uploader" /> <s:property value="#music.audiolength" /></h4>
</div>
</div>
<div class="three">
<div class="three-1">
<div class="update"><s:a href="preupdate?music.id=%{#music.id}&pageNum=%{pageNum}">修改</s:a></div>
</div>
<div class="three-2">
<div class="delete"> <s:a href="predel?music.id=%{#music.id}&pageNum=%{pageNum}">删除</s:a></div>
</div>
</div>
</div>
</s:iterator>
</div>
</div>
<div class="center-down">
<ul>
<li>
<a>第<s:property value="pageNum2" />页|共<s:property
value="totalpage2" />页
</a>
</li>
<li>
<s:url var="firstpage" action="hongkong">
<s:param name="pageNum2">1</s:param>
<s:param name="username">
<s:property value="user.username" />
</s:param>
</s:url> <s:a href="%{firstpage}">首页</s:a>
</li>
<li>
<s:if test="pageNum2!=1">
<s:url var="prePage2" action="hongkong">
<s:param name="pageNum2">
<s:property value="pageNum2-1" />
</s:param>
<s:param name="username">
<s:property value="user.username" />
</s:param>
</s:url>
<s:a href="%{prePage}">上一页</s:a>
</s:if>
</li>
<li>
<s:if test="pageNum2!=totalpage2">
<s:url var="nextPage" action="hongkong">
<s:param name="pageNum2">
<s:property value="pageNum2+1" />
</s:param>
<s:param name="username">
<s:property value="user.username" />
</s:param>
</s:url>
<s:a href="%{nextPage}">下一页</s:a>
</s:if>
</li>
<li>
<s:url var="lastPage2" action="hongkong">
<s:param name="pageNum2">
<s:property value="totalpage2" />
</s:param>
<s:param name="username">
<s:property value="user.username" />
</s:param>
</s:url> <s:a href="%{lastPage}">末页</s:a>
</li>
</ul>
</div>
</div>
</div>
<div class="footer">
<h4>王骏©期末作品</h4>
</div>
</body>
</html>
japan.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>japan</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
<div class="head">
<div class="headcenter">
<div class="logo-box">
<a class="logo" ref="#"><img width="97" height="60" src="img/logo.png"></a>
</div>
<div class="search-box">
<div class="search bar7">
<s:form action="search">
<input type="text" placeholder="请输入歌曲名称..." name="keyString">
<button type="submit"></button>
</s:form>
</div>
</div>
<div class="center-box"></div>
<div class="reset">
<ul>
<li>
<a href="prelogout.jsp">注销</a>
</li>
</ul>
</div>
</div>
</div>
<div class="banner">
<div class="banner-center">
<div class="banner-li-box">
<ul>
<li><s:a href="find">首页</s:a></li>
<li><s:a href="local">流行</s:a></li>
<li><s:a href="hongkong">摇滚</s:a></li>
<li><s:a href="usa">民族</s:a></li>
<li><s:a href="japan">轻音乐</s:a></li>
<li><s:a href="korea">蓝调</s:a></li>
</ul>
</div>
</div>
<div class="banner-li-box-center"></div>
<div class="downandadd">
<ul>
<li>
<a href="createMusicList">下载</a>
</li>
<li>
<a href="add.jsp">添加</a>
</li>
</ul>
</div>
</div>
<div class="main">
<div class="main-center">
<div class="center-up-up">
<h2>轻音乐 共有<s:property value="Amount3" />首歌曲</h2>
</div>
<div class="center-up">
<div class="song-box">
<s:iterator value="list" var="music">
<div class="song">
<div class="one">
<img alt="图片"
src="${pageContext.servletContext.contextPath}/img/${songimg}" /></div>
<div class="two">
<div class="two-1">
<h4><s:property value="#music.songtitle" /></h4>
</div>
<div class="two-2">
<h4><s:property value="#music.singer" /></h4>
</div>
<div class="two-3">
<h4><s:property value="#music.uploader" /> <s:property value="#music.audiolength" /></h4>
</div>
</div>
<div class="three">
<div class="three-1">
<div class="update"><s:a href="preupdate?music.id=%{#music.id}&pageNum=%{pageNum}">修改</s:a></div>
</div>
<div class="three-2">
<div class="delete"> <s:a href="predel?music.id=%{#music.id}&pageNum=%{pageNum}">删除</s:a></div>
</div>
</div>
</div>
</s:iterator>
</div>
</div>
<div class="center-down">
<ul>
<li>
<a>第<s:property value="pageNum4" />页|共<s:property
value="totalpage4" />页
</a>
</li>
<li>
<a>共<s:property
value="totalpage" />页</a>
</li>
<li>
<s:url var="firstpage" action="japan">
<s:param name="pageNum4">1</s:param>
</s:url> <s:a href="%{firstpage}">首页</s:a>
</li>
<li>
<s:if test="pageNum4!=1">
<s:url var="prePage" action="japan">
<s:param name="pageNum4">
<s:property value="pageNum4-1" />
</s:param>
</s:url>
<s:a href="%{prePage}">上一页</s:a>
</s:if>
</li>
<s:if test="pageNum4!=totalpage4">
<s:url var="nextPage" action="japan">
<s:param name="pageNum4">
<s:property value="pageNum4+1" />
</s:param>
</s:url>
<s:a href="%{nextPage}">下一页</s:a>
</s:if>
</li>
<li>
<s:url var="lastPage" action="japan">
<s:param name="pageNum4">
<s:property value="totalpage4" />
</s:param>
</s:url> <s:a href="%{lastPage}">末页</s:a>
</li>
</ul>
</div>
</div>
</div>
<div class="footer">
<h4>王骏©期末作品</h4>
</div>
</body>
</html>
korea.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>korea</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
<div class="head">
<div class="headcenter">
<div class="logo-box">
<a class="logo" ref="#"><img width="97" height="60" src="img/logo.png"></a>
</div>
<div class="search-box">
<div class="search bar7">
<s:form action="search">
<input type="text" placeholder="请输入歌曲名称..." name="keyString">
<button type="submit"></button>
</s:form>
</div>
</div>
<div class="center-box"></div>
<div class="reset">
<ul>
<li>
<a href="prelogout.jsp">注销</a>
</li>
</ul>
</div>
</div>
</div>
<div class="banner">
<div class="banner-center">
<div class="banner-li-box">
<ul>
<li><s:a href="find">首页</s:a></li>
<li><s:a href="local">流行</s:a></li>
<li><s:a href="hongkong">摇滚</s:a></li>
<li><s:a href="usa">民族</s:a></li>
<li><s:a href="japan">轻音乐</s:a></li>
<li><s:a href="korea">蓝调</s:a></li>
</ul>
</div>
</div>
<div class="banner-li-box-center"></div>
<div class="downandadd">
<ul>
<li>
<a href="createMusicList">下载</a>
</li>
<li>
<a href="add.jsp">添加</a>
</li>
</ul>
</div>
</div>
<div class="main">
<div class="main-center">
<div class="center-up-up">
<h2>蓝调 共有<s:property value="Amount4" />首歌曲</h2>
</div>
<div class="center-up">
<div class="song-box">
<s:iterator value="list" var="music">
<div class="song">
<div class="one">
<img alt="图片"
src="${pageContext.servletContext.contextPath}/img/${songimg}" /></div>
<div class="two">
<div class="two-1">
<h4><s:property value="#music.songtitle" /></h4>
</div>
<div class="two-2">
<h4><s:property value="#music.singer" /></h4>
</div>
<div class="two-3">
<h4><s:property value="#music.uploader" /> <s:property value="#music.audiolength" /></h4>
</div>
</div>
<div class="three">
<div class="three-1">
<div class="update"><s:a href="preupdate?music.id=%{#music.id}&pageNum=%{pageNum}">修改</s:a></div>
</div>
<div class="three-2">
<div class="delete"> <s:a href="predel?music.id=%{#music.id}&pageNum=%{pageNum}">删除</s:a></div>
</div>
</div>
</div>
</s:iterator>
</div>
</div>
<div class="center-down">
<ul>
<li>
<a>第<s:property value="pageNum5" />页|共<s:property
value="totalpage5" />页
</a>
</li>
<li>
<s:url var="firstpage" action="korea">
<s:param name="pageNum5">1</s:param>
</s:url> <s:a href="%{firstpage}">首页</s:a>
</li>
<li>
<s:if test="pageNum5!=1">
<s:url var="prePage" action="korea">
<s:param name="pageNum5">
<s:property value="pageNum5-1" />
</s:param>
</s:url>
<s:a href="%{prePage}">上一页</s:a>
</s:if>
</li>
<li>
<s:if test="pageNum5!=totalpage5">
<s:url var="nextPage" action="korea">
<s:param name="pageNum5">
<s:property value="pageNum5+1" />
</s:param>
</s:url>
<s:a href="%{nextPage}">下一页</s:a>
</s:if>
</li>
<li>
<s:url var="lastPage" action="korea">
<s:param name="pageNum5">
<s:property value="totalpage5" />
</s:param>
</s:url> <s:a href="%{lastPage}">末页</s:a>
</li>
</ul>
</div>
</div>
</div>
<div class="footer">
<h4>王骏©期末作品</h4>
</div>
</body>
</html>
local.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>local</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
<div class="head">
<div class="headcenter">
<div class="logo-box">
<a class="logo" ref="#"><img width="97" height="60"
src="img/logo.png"></a>
</div>
<div class="search-box">
<div class="search bar7">
<s:form action="search">
<input type="text" placeholder="请输入歌曲名称..." name="keyString">
<button type="submit"></button>
</s:form>
</div>
</div>
<div class="center-box"></div>
<div class="reset">
<ul>
<li><a href="prelogout.jsp">注销</a></li>
</ul>
</div>
</div>
</div>
<div class="banner">
<div class="banner-center">
<div class="banner-li-box">
<ul>
<li><s:a href="find">首页</s:a></li>
<li><s:a href="local">流行</s:a></li>
<li><s:a href="hongkong">摇滚</s:a></li>
<li><s:a href="usa">民族</s:a></li>
<li><s:a href="japan">轻音乐</s:a></li>
<li><s:a href="korea">蓝调</s:a></li>
</ul>
</div>
</div>
<div class="banner-li-box-center"></div>
<div class="downandadd">
<ul>
<li><a href="createMusicList">下载</a></li>
<li><a href="add.jsp">添加</a></li>
</ul>
</div>
</div>
<div class="main">
<div class="main-center">
<div class="center-up-up">
<h2>
流行 共有
<s:property value="Amount1" />
首歌曲
</h2>
</div>
<div class="center-up">
<div class="song-box">
<s:iterator value="list" var="music">
<div class="song">
<div class="one">
<img alt="图片"
src="${pageContext.servletContext.contextPath}/img/${songimg}" />
</div>
<div class="two">
<div class="two-1">
<h4>
<s:property value="#music.songtitle" />
</h4>
</div>
<div class="two-2">
<h4>
<s:property value="#music.singer" />
</h4>
</div>
<div class="two-3">
<h4>
<s:property value="#music.uploader" />
<s:property value="#music.audiolength" />
</h4>
</div>
</div>
<div class="three">
<div class="three-1">
<div class="update">
<s:a href="preupdate?music.id=%{#music.id}&pageNum=%{pageNum}">修改</s:a>
</div>
</div>
<div class="three-2">
<div class="delete">
<s:a href="predel?music.id=%{#music.id}&pageNum=%{pageNum}">删除</s:a>
</div>
</div>
</div>
</div>
</s:iterator>
</div>
</div>
<div class="center-down">
<ul>
<li><a>第<s:property value="pageNum1" />页|共<s:property
value="totalpage1" />页
</a></li>
<li><s:url var="firstpage" action="local">
<s:param name="pageNum1">1</s:param>
<s:param name="username">
<s:property value="user.username" />
</s:param>
</s:url> <s:a href="%{firstpage}">首页</s:a></li>
<li><s:if test="pageNum1!=1">
<s:url var="prePage" action="local">
<s:param name="pageNum1">
<s:property value="pageNum1-1" />
</s:param>
<s:param name="username">
<s:property value="user.username" />
</s:param>
</s:url>
<s:a href="%{prePage}">上一页</s:a>
</s:if></li>
<li><s:if test="pageNum1!=totalpage1">
<s:url var="nextPage" action="local">
<s:param name="pageNum1">
<s:property value="pageNum1+1" />
</s:param>
<s:param name="username">
<s:property value="user.username" />
</s:param>
</s:url>
<s:a href="%{nextPage}">下一页</s:a>
</s:if></li>
<li><s:url var="lastPage" action="local">
<s:param name="pageNum1">
<s:property value="totalpage1" />
</s:param>
<s:param name="username">
<s:property value="user.username" />
</s:param>
</s:url> <s:a href="%{lastPage}">末页</s:a></li>
</ul>
</div>
</div>
</div>
<div class="footer">
<h4>王骏©期末作品</h4>
</div>
</body>
</html>
login.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<link rel="stylesheet" type="text/css" href="css/style2.css">
<title>login</title>
<script type="text/javascript">
function refresh() {
//IE存在缓存,需要new Date()实现更换路径的作用
document.getElementById("image").src = "createImageAction.action?+ Math.random()" + new Date();
}
</script>
</head>
<body>
<div class="head">
<div class="head-center">
<div class="logo-box">
<a class="logo" href="#"><img width="97" height="60"
src="img/logo.png"></a>
</div>
</div>
</div>
<div class="middle">
<div class="middle-center">
<div class="welcom">
<s:form cssClass="form" action="login" method="post" theme="simple">
<div class="one">
<s:textfield cssClass="one-button" placeholder="用户名" name="user.username"></s:textfield>
</div>
<div class="one">
<s:password cssClass="one-button" placeholder="密码" name="user.password"></s:password>
</div>
<div class="one">
<div class="one-left"><s:textfield cssClass="one-left-button" placeholder="验证码" name="checkCode" maxlength="4" /></div>
<div class="one-right"><s:a cssClass="one-right-button" href="javascript:refresh()">
<img id="image" src="createImageAction.action" />
</s:a></div>
</div>
<div class="one">
<div class="one-left"><s:submit id="submit" cssClass="one-left-button" value="登录" /></div>
<div class="one-rr"><s:a cssClass="one-right-button" href="register.jsp">注册</s:a></div>
</div>
</s:form>
</div>
</div>
</div>
<div class="footer">
<div class="foot">
<div class="foot-two">
<div class="error-left"><s:fielderror class="error"/> </div>
<h4>王骏©期末作品</h4>
</div>
</div>
</div>
</body>
</html>
main.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>主页</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
<div class="head">
<div class="headcenter">
<div class="logo-box">
<a class="logo" ref="#"><img width="97" height="60" src="img/logo.png"></a>
</div>
<div class="search-box">
<div class="search bar7">
<s:form action="search">
<input type="text" placeholder="请输入歌曲名称..." name="keyString">
<button type="submit"></button>
</s:form>
</div>
</div>
<div class="center-box"></div>
<div class="reset">
<ul>
<li>
<a href="prelogout.jsp">注销</a>
</li>
</ul>
</div>
</div>
</div>
<div class="banner">
<div class="banner-center">
<div class="banner-li-box">
<ul>
<li><s:a href="find">首页</s:a></li>
<li><s:a href="local">流行</s:a></li>
<li><s:a href="hongkong">摇滚</s:a></li>
<li><s:a href="usa">民族</s:a></li>
<li><s:a href="japan">轻音乐</s:a></li>
<li><s:a href="korea">蓝调</s:a></li>
</ul>
</div>
</div>
<div class="banner-li-box-center"></div>
<div class="downandadd">
<ul>
<li>
<a href="createMusicList">下载</a>
</li>
<li>
<a href="add.jsp">添加</a>
</li>
</ul>
</div>
</div>
<div class="main">
<div class="main-center">
<div class="center-up-up">
<h2>主页 共有<s:property value="Amount" />首歌曲</h2>
</div>
<div class="center-up">
<div class="song-box">
<s:iterator value="list" var="music">
<div class="song">
<div class="one">
<img width="66px" height="66px" alt="图片"
src="${pageContext.servletContext.contextPath}/img/${songimg}" /></div>
<div class="two">
<div class="two-1">
<h4><s:property value="#music.songtitle" /></h4>
</div>
<div class="two-2">
<h4><s:property value="#music.singer" /></h4>
</div>
<div class="two-3">
<h4><s:property value="#music.uploader" /> <s:property value="#music.audiolength" /></h4>
</div>
</div>
<div class="three">
<div class="three-1">
<div class="update"><s:a href="preupdate?music.id=%{#music.id}&pageNum=%{pageNum}">修改</s:a></div>
</div>
<div class="three-2">
<div class="delete"> <s:a href="predel?music.id=%{#music.id}&pageNum=%{pageNum}">删除</s:a></div>
</div>
</div>
</div>
</s:iterator>
</div>
</div>
<div class="center-down">
<ul>
<li>
<a>第<s:property value="pageNum" />页</a>
</li>
<li>
<a>共<s:property
value="totalpage" />页</a>
</li>
<li>
<s:url var="firstpage" action="find">
<s:param name="pageNum">1</s:param>
<s:param name="username">
<s:property value="user.username" />
</s:param>
</s:url> <s:a href="%{firstpage}">首页</s:a>
</li>
<li>
<s:if test="pageNum!=1">
<s:url var="prePage" action="find">
<s:param name="pageNum">
<s:property value="pageNum-1" />
</s:param>
<s:param name="username">
<s:property value="user.username" />
</s:param>
</s:url>
<s:a href="%{prePage}">上一页</s:a>
</s:if>
</li>
<li>
<s:if test="pageNum!=totalpage">
<s:url var="nextPage" action="find">
<s:param name="pageNum">
<s:property value="pageNum+1" />
</s:param>
<s:param name="username">
<s:property value="user.username" />
</s:param>
</s:url>
<s:a href="%{nextPage}">下一页</s:a>
</s:if>
</li>
<li>
<s:url var="lastPage" action="find">
<s:param name="pageNum">
<s:property value="totalpage" />
</s:param>
<s:param name="username">
<s:property value="user.username" />
</s:param>
</s:url> <s:a href="%{lastPage}">末页</s:a>
</li>
</ul>
</div>
</div>
</div>
<div class="footer">
<h4>王骏©期末作品</h4>
</div>
</body>
</html>
prelogout.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta charset="utf-8">
<link rel="stylesheet" type="text/css" href="css/style4.css">
<meta http-equiv="refresh" content="3; url='login.jsp'">
<title>register</title>
</head>
<body>
<div class="head">
<div class="head-center">
<div class="logo-box">
<a class="logo" href="#"><img width="97" height="60"
src="img/logo.png"></a>
</div>
</div>
</div>
<div class="middle">
<div class="middle-center">
<div class="welcom">
<h3>3秒后，跳转到登录页面。</h3>
</div>
</div>
</div>
<div class="footer">
<div class="foot">
<div class="foot-two">
<div class="error-left">
<s:fielderror class="error" />
</div>
<h4>王骏©期末作品</h4>
</div>
</div>
</div>
</body>
</html>
register.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta charset="utf-8">
<link rel="stylesheet" type="text/css" href="css/style4.css">
<title>register</title>
</head>
<body>
<div class="head">
<div class="head-center">
<div class="logo-box">
<a class="logo" href="#"><img width="97" height="60"
src="img/logo.png"></a>
</div>
</div>
</div>
<div class="middle">
<div class="middle-center">
<div class="welcom">
<s:form cssClass="form" action="register" method="post"
theme="simple">
<div class="one">
<s:textfield cssClass="one-button" placeholder="用户名" label="用户名"
name="user.username"></s:textfield>
</div>
<div class="one">
<s:password cssClass="one-button" placeholder="密码" label="密码"
name="user.password"></s:password>
</div>
<div class="one">
<div class="one-left">
<s:select cssClass="one-left-button" placeholder="性别"
list="#{'男':'男','女':'女'}" label="性別" headerValue="请选择性別"
name="user.sex">
</s:select>
</div>
<div class="one-left">
<s:select cssClass="one-right-button" placeholder="学历"
list="#{'大学本科':'大学本科','专科':'专科','硕士研究生':'硕士研究生','博士研究生':'博士研究生'}"
label="学历" headerValue="请选择歌曲地区" name="user.qualify">
</s:select>
</div>
</div>
<div class="one">
<s:textfield cssClass="one-button" placeholder="邮箱地址"
name="user.email"></s:textfield>
</div>
<div class="one">
<s:textfield cssClass="one-button" placeholder="出生日期"
name="user.birthday"></s:textfield>
</div>
<div class="one">
<s:textfield cssClass="one-button" placeholder="身份证号"
name="user.idnumber"></s:textfield>
</div>
<div class="one">
<div class="one-left">
<s:submit id="submit" cssClass="one-left-button" value="注册" />
</div>
</div>
</s:form>
</div>
</div>
</div>
<div class="footer">
<div class="foot">
<div class="foot-two">
<div class="error-left">
<s:fielderror class="error" />
</div>
<h4>王骏©期末作品</h4>
</div>
</div>
</div>
</body>
</html>
registersucc.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="refresh" content="3; url='login.jsp'">
<title>跳转</title>
</head>
<body>
<a>注册成功！3秒后跳转到登录页面。</a>
</body>
</html>
result.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>主页</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
<div class="head">
<div class="headcenter">
<div class="logo-box">
<a class="logo" ref="#"><img width="97" height="60" src="img/logo.png"></a>
</div>
<div class="search-box">
<div class="search bar7">
<s:form action="search">
<input type="text" placeholder="请输入歌曲名称..." name="keyString">
<button type="submit"></button>
</s:form>
</div>
</div>
<div class="center-box"></div>
<div class="reset">
<ul>
<li>
<a href="prelogout.jsp">注销</a>
</li>
</ul>
</div>
</div>
</div>
<div class="banner">
<div class="banner-center">
<div class="banner-li-box">
<ul>
<li><s:a href="find">首页</s:a></li>
<li><s:a href="local">流行</s:a></li>
<li><s:a href="hongkong">摇滚</s:a></li>
<li><s:a href="usa">民族</s:a></li>
<li><s:a href="japan">轻音乐</s:a></li>
<li><s:a href="korea">蓝调</s:a></li>
</ul>
</div>
</div>
<div class="banner-li-box-center"></div>
<div class="downandadd">
<ul>
<li>
<a href="createMusicList">下载</a>
</li>
<li>
<a href="add.jsp">添加</a>
</li>
</ul>
</div>
</div>
<div class="main">
<div class="main-center">
<div class="center-up-up">
<h2>搜索结果 找到<s:property value="Amount6" />首歌曲</h2>
</div>
<div class="center-up">
<div class="song-box">
<s:iterator value="list" var="music">
<div class="song">
<div class="one">
<img alt="图片"
src="${pageContext.servletContext.contextPath}/img/${songimg}" /></div>
<div class="two">
<div class="two-1">
<h4><s:property value="#music.songtitle" /></h4>
</div>
<div class="two-2">
<h4><s:property value="#music.singer" /></h4>
</div>
<div class="two-3">
<h4><s:property value="#music.uploader" /> <s:property value="#music.audiolength" /></h4>
</div>
</div>
<div class="three">
<div class="three-1">
<div class="update"><s:a href="preupdate?music.id=%{#music.id}&pageNum=%{pageNum}">修改</s:a></div>
</div>
<div class="three-2">
<div class="delete"> <s:a href="predel?music.id=%{#music.id}&pageNum=%{pageNum}">删除</s:a></div>
</div>
</div>
</div>
</s:iterator>
</div>
</div>
<div class="center-down">
</div>
</div>
</div>
<div class="footer">
<h4>王骏©期末作品</h4>
</div>
</body>
</html>
update.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>主页</title>
<link rel="stylesheet" type="text/css" href="css/style1.css">
</head>
<body>
<div class="head">
<div class="headcenter">
<div class="logo-box">
<a class="logo" ref="#"><img width="97" height="60" src="img/logo.png"></a>
</div>
<div class="search-box">
<div class="search bar7">
<s:form action="search">
<input type="text" placeholder="请输入歌曲名称..." name="keyString">
<button type="submit"></button>
</s:form>
</div>
</div>
<div class="center-box"></div>
<div class="reset">
<ul>
<li>
<a href="prelogout.jsp">注销</a>
</li>
</ul>
</div>
</div>
</div>
<div class="banner">
<div class="banner-center">
<div class="banner-li-box">
<ul>
<li><s:a href="find">首页</s:a></li>
<li><s:a href="local">流行</s:a></li>
<li><s:a href="hongkong">摇滚</s:a></li>
<li><s:a href="usa">民族</s:a></li>
<li><s:a href="japan">轻音乐</s:a></li>
<li><s:a href="korea">蓝调</s:a></li>
</ul>
</div>
</div>
<div class="banner-li-box-center"></div>
<div class="downandadd">
<ul>
<li>
<a href="createMusicList">下载</a>
</li>
<li>
<a href="add.jsp">添加</a>
</li>
</ul>
</div>
</div>
<div class="main">
<div class="main-center">
<div class="center-up-up">
<h2>修改歌曲</h2>
</div>
<div class="center-up">
<div class="song-box">
<s:form id="formf" action="update">
<table>
<tr>
<td><s:hidden id="inp" label="歌曲ID" name="music.id"></s:hidden></td>
</tr>
<tr>
<td><s:hidden id="inp" label="歌曲所在页码" name="pageNum"></s:hidden></td>
</tr>
<tr>
<td><s:textfield id="inp" label="歌曲名称" name="music.songtitle"></s:textfield>
</td>
</tr>
<tr>
<td><s:textfield id="inp" label="歌手名字" name="music.singer"></s:textfield></td>
</tr>
<tr>
<td><s:select id="inp" label="歌曲风格" list="#{'流行':'流行','摇滚':'摇滚','民族':'民族','轻音乐':'轻音乐','蓝调':'蓝调'}" headerValue="请选择歌曲风格" name="music.songarea">
</s:select></td></td>
</tr>
<tr>
<td><s:submit id="submit" value="修改" /></td>
</tr>
</table>
</s:form>
</div>
</div>
<div class="center-down">
</div>
</div>
</div>
<div class="footer">
<h4>王骏©期末作品</h4>
</div>
</body>
</html>
usa.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE htm
l>
<html>
<head>
<meta charset="utf-8">
<title>usa</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
<div class="head">
<div class="headcenter">
<div class="logo-box">
<a class="logo" ref="#"><img width="97" height="60"
src="img/logo.png"></a>
</div>
<div class="search-box">
<div class="search bar7">
<s:form action="search">
<input type="text" placeholder="请输入歌曲名称..." name="keyString">
<button type="submit"></button>
</s:form>
</div>
</div>
<div class="center-box"></div>
<div class="reset">
<ul>
<li><a href="prelogout.jsp">注销</a></li>
</ul>
</div>
</div>
</div>
<div class="banner">
<div class="banner-center">
<div class="banner-li-box">
<ul>
<li><s:a href="find">首页</s:a></li>
<li><s:a href="local">流行</s:a></li>
<li><s:a href="hongkong">摇滚</s:a></li>
<li><s:a href="usa">民族</s:a></li>
<li><s:a href="japan">轻音乐</s:a></li>
<li><s:a href="korea">蓝调</s:a></li>
</ul>
</div>
</div>
<div class="banner-li-box-center"></div>
<div class="downandadd">
<ul>
<li><a href="createMusicList">下载</a></li>
<li><a href="add.jsp">添加</a></li>
</ul>
</div>
</div>
<div class="main">
<div class="main-center">
<div class="center-up-up">
<h2>
民族 共有
<s:property value="Amount2" />
首歌曲
</h2>
</div>
<div class="center-up">
<div class="song-box">
<s:iterator value="list" var="music">
<div class="song">
<div class="one">
<img alt="图片"
src="${pageContext.servletContext.contextPath}/img/${songimg}" />
</div>
<div class="two">
<div class="two-1">
<h4>
<s:property value="#music.songtitle" />
</h4>
</div>
<div class="two-2">
<h4>
<s:property value="#music.singer" />
</h4>
</div>
<div class="two-3">
<h4>
<s:property value="#music.uploader" />
<s:property value="#music.audiolength" />
</h4>
</div>
</div>
<div class="three">
<div class="three-1">
<div class="update">
<s:a href="preupdate?music.id=%{#music.id}&pageNum=%{pageNum}">修改</s:a>
</div>
</div>
<div class="three-2">
<div class="delete">
<s:a href="predel?music.id=%{#music.id}&pageNum=%{pageNum}">删除</s:a>
</div>
</div>
</div>
</div>
</s:iterator>
</div>
</div>
<div class="center-down">
<ul>
<li><a>第<s:property value="pageNum3" />页|共<s:property
value="totalpage3" />页
</a></li>
<li><s:url var="firstpage" action="usa">
<s:param name="pageNum3">1</s:param>
<s:param name="username">
<s:property value="user.username" />
</s:param>
</s:url> <s:a href="%{firstpage}">首页</s:a></li>
<li><s:if test="pageNum3!=1">
<s:url var="prePage" action="usa">
<s:param name="pageNum3">
<s:property value="pageNum3-1" />
</s:param>
<s:param name="username">
<s:property value="user.username" />
</s:param>
</s:url>
<s:a href="%{prePage}">上一页</s:a>
</s:if></li>
<li><s:if test="pageNum!=totalpage">
<s:url var="nextPage" action="usa">
<s:param name="pageNum3">
<s:property value="pageNum3+1" />
</s:param>
<s:param name="username">
<s:property value="user.username" />
</s:param>
</s:url>
<s:a href="%{nextPage}">下一页</s:a>
</s:if></li>
<li><s:url var="lastPage" action="usa">
<s:param name="pageNum3">
<s:property value="totalpage3" />
</s:param>
<s:param name="username">
<s:property value="user.username" />
</s:param>
</s:url> <s:a href="%{lastPage}">末页</s:a></li>
</ul>
</div>
</div>
</div>
<div class="footer">
<h4>王骏©期末作品</h4>
</div>
</body>
</html>
在 WebRoot 目录建立 CSS 文件夹，新建 CSS 文件：
- style.css
- style1.css
- style2.css
- style3.css
style.css
[genuitec-file-id="wc1-1"],[genuitec-lp-path="/ss/WebRoot/css/style.css"],[genuitec-lp-enabled=false]{
/* for codelive */
}
body {
background: rgb(250,250,250);
margin: 0px;
padding: 0px;
font-size: 15px;
font-family: 'Microsoft Yahei', Tahoma, Helvetica, Arial, sans-serif;
}
.head {
100%;
height: 60px;
min- 1000px;
background: #222;
text-align: center;
}
.headcenter {
1000px;
margin: 0 auto;
background: #222;
}
.logo-box {
margin: 0px;
padding: 0px;
97px;
height: 60px;
float: left;
}
.search-box {
360px;
height: 60px;
margin: 0px;
padding: 0px;
background: #222;
float: left;
}
.center-box {
483px;
height: 60px;
margin: 0px;
padding: 0px;
background: #222;
float: left;
}
div.search {
padding:10px 0;
}
form {
position:relative;
262px;
margin:0 auto;
}
input,button {
border:none;
outline:none;
}
input {
100%;
height:32px;
color: rgb(252,250,232);
}
button {
height:0px;
0px;
color: rgb(252,250,232);
cursor:pointer;
position:absolute;
}
.bar7 form {
height:20px;
}
.bar7 input {
250px;
border-radius:42px;
border:1px solid rgb(102,204,0);
background:#222;
transition:.3s linear;
float:right;
}
.bar7 input:focus {
300px;
}
.bar7 button {
background:none;
right: 45px;
top: 7px;
}
.bar7 button:before {
content:"Search";
font-family:FontAwesome;
color:rgb(252,250,232);
}
.reset {
60px;
height: 60px;
margin: 0px;
padding: 0px;
background: #222;
float: left;
}
.banner {
100%;
height: 38px;
min- 1000px;
background: #222;
text-align: center;
}
.banner-center {
1000px;
margin: 0 auto;
background: #222;
}
.banner-li-box {
480px;
height: 38px;
margin: 0px;
padding: 0px;
background: #222;
float: left;
}
.banner-li-box ul li a {
display: block;
padding: 9px 6px 11px 6px;
margin: 0px;
}
.banner-li-box a:link,
.banner-li-box a:visited {
color: #fff;
text-decoration: none;
}
.banner-li-box a:hover {
color: rgb(102,204,0);
text-decoration: none;
background: url(../img/hover.png) no-repeat;
}
.banner-li-box-center {
360px;
height: 38px;
margin: 0px;
padding: 0px;
background: #222;
float: left;
}
.downandadd {
160px;
height: 38px;
margin: 0px;
padding: 0px;
background: #222;
float: left;
}
.downandadd ul {
list-style-type: none;
padding: 0px;
margin: 0px;
}
.downandadd ul li {
float: left;
text-align: center;
80px;
}
.downandadd ul li a {
display: block;
padding: 9px 6px 11px 6px;
margin: 0px;
}
.downandadd a:link,
.downandadd a:visited {
color: #fff;
text-decoration: none;
}
.downandadd a:hover {
color: rgb(102,204,0);
text-decoration: none;
background: url(../img/hover.png) no-repeat;
}
.reset ul {
list-style-type: none;
padding: 0px;
margin: 0px;
}
.reset ul li {
float: left;
text-align: center;
60px;
}
.reset ul li a {
display: block;
padding: 20px 6px 11px 6px;
margin: 0px;
}
.reset a:link,
.reset a:visited {
color: #fff;
text-decoration: none;
}
.reset a:hover {
color: rgb(102,204,0);
text-decoration: none;
}
.banner-li-box ul {
list-style-type: none;
padding: 0px;
margin: 0px;
}
.banner-li-box ul li {
float: left;
text-align: center;
80px;
}
.main {
100%;
height: 580px;
min- 1000px;
background: rgba(250, 250, 250,0);
text-align: center;
}
.main-center {
1000px;
margin: 0 auto;
background: rgba(255, 255, 255,0);
}
.center-up-up {
1000px;
height: 50px;
margin: 0px;
padding: 0px;
background: rgb(250, 250, 250);
float: left;
}
.center-up-up h2{
float: left;
}
.center-up {
1000px;
height: 480px;
margin: 0px;
padding: 0px;
background: url(../img/bac.png);
border-radius: 5px 5px 5px 5px;
float: left;
}
.center-down {
1000px;
height: 40px;
margin: 0px;
padding: 0px;
background: #222;
color: #fff;
float: left;
border-radius: 5px 5px 5px 5px;
}
.center-down ul {
list-style-type: none;
padding: 0px;
margin: 0px;
}
.center-down ul li {
float: left;
text-align: center;
60px;
}
.center-down ul li a {
display: block;
padding: 9px 6px 11px 6px;
margin: 0px;
}
.center-down a:link,
.center-down a:visited {
color: #fff;
text-decoration: none;
}
.center-down a:hover {
color: rgb(102,204,0);
text-decoration: none;
background: url(../img/hoverdown.png) no-repeat;
}
.footer {
100%;
height: 60px;
min- 1000px;
background: #222;
text-align: center;
}
.footer h4{
color: #fff;
}
.song-box {
990px;
height: 470px;
margin: 5px 5px;
padding: 0px;
background: rgba(255,255,255,0);
float: left;
}
.song {
margin: 3.5px 2.5px 3px 3.5px;
padding: 0px;
487px;
height: 150px;
border:0.1px solid #222;
background: url(../img/songbac.png) no-repeat;
float: left;
border-radius: 5px;
}
.one {
150px;
height: 150px;
margin: 0px;
padding: 0px;
background: rgba(255,255,255,0.7);
float: left;
border-radius: 5px 0px 0px 5px;
}
.one img {
150px;
height: 150px;
border-radius: 5px 0px 0px 5px;
}
.two {
187px;
height: 150px;
margin: 0px;
padding: 0px;
background: rgba(255,255,255,0.7);
float: left;
}
.three {
150px;
height: 150px;
margin: 0px;
padding: 0px;
background: rgba(255,255,255,0.7);
float: left;
border-radius: 0px 5px 5px 0px;
}
.two-1 {
187px;
height: 50px;
margin: 0px;
padding: 0px;
background: rgba(255,255,255,0);
float: left;
}
.two-2 {
187px;
height: 50px;
margin: 0px;
padding: 0px;
background: rgba(255,255,255,0);
float: left;
}
.two-3 {
187px;
height: 50px;
margin: 0px;
padding: 0px;
background: rgba(255,255,255,0);
float: left;
}
.three-1 {
150px;
height: 75px;
margin: 0px;
padding: 0px;
background: rgba(255,255,255,0);
float: left;
border-radius: 0px 5px 0px 0px;
}
.three-2 {
150px;
height: 75px;
margin: 0px;
padding: 0px;
background: rgba(255,255,255,0);
float: left;
border-radius: 0px 0px 5px 0px;
}
.update{
margin: 20px 25px 20px 25px;
padding: 0px;
100px;
height: 35px;
border:1px solid #222;
background-color: rgba(255,255,255,0);
line-height: 30px;
text-align: center;
border-radius: 5px 5px 5px 5px;
}
.delete{
margin: 20px 25px 20px 25px;
padding: 0px;
100px;
height: 35px;
border:1px solid #222;
background-color: rgba(255,255,255,0);
line-height: 30px;
text-align: center;
border-radius: 5px 5px 5px 5px;
}
.update a {
display: block;
padding: 2.5px 2.5px 2.5px 2.5px;
margin: 0px;
border-radius: 3px 3px 3px 3px;
}
.update a:link,
.update a:visited {
color: #222;
text-decoration: none;
}
.update a:hover {
color: rgb(255,255,255);
text-decoration: none;
background: #222;
}
.delete a {
display: block;
padding: 2.5px 2.5px 2.5px 2.5px;
margin: 0px;
border-radius: 3px 3px 3px 3px;
}
.delete a:link,
.delete a:visited {
color: #222;
text-decoration: none;
}
.delete a:hover {
color: rgb(255,255,255);
text-decoration: none;
background: #222;
}
style1.css
[genuitec-file-id="wc1-2"],[genuitec-lp-path="/ss/WebRoot/css/style1.css"],[genuitec-lp-enabled=false]{
/* for codelive */
}
body {
background: rgb(250,250,250);
margin: 0px;
padding: 0px;
font-size: 15px;
font-family: 'Microsoft Yahei', Tahoma, Helvetica, Arial, sans-serif;
}
.head {
100%;
height: 60px;
min- 1000px;
background: #222;
text-align: center;
}
.headcenter {
1000px;
margin: 0 auto;
background: #222;
}
.logo-box {
margin: 0px;
padding: 0px;
97px;
height: 60px;
float: left;
}
.search-box {
360px;
height: 60px;
margin: 0px;
padding: 0px;
background: #222;
float: left;
}
.center-box {
483px;
height: 60px;
margin: 0px;
padding: 0px;
background: #222;
float: left;
}
div.search {
padding:10px 0;
}
form {
position:relative;
262px;
margin:0 auto;
}
input,button {
border:none;
outline:none;
}
input {
100%;
height:32px;
color: #222;
}
button {
height:0px;
0px;
color: rgb(252,250,232);
cursor:pointer;
position:absolute;
}
.bar7 form {
height:20px;
}
.bar7 input {
250px;
border-radius:42px;
border:1px solid rgb(102,204,0);
background:#222;
transition:.3s linear;
float:right;
}
.bar7 input:focus {
300px;
}
.bar7 button {
background:none;
right: 45px;
top: 7px;
}
.bar7 button:before {
content:"Search";
font-family:FontAwesome;
color:rgb(252,250,232);
}
.reset {
60px;
height: 60px;
margin: 0px;
padding: 0px;
background: #222;
float: left;
}
.banner {
100%;
height: 38px;
min- 1000px;
background: #222;
text-align: center;
}
.banner-center {
1000px;
margin: 0 auto;
background: #222;
}
.banner-li-box {
480px;
height: 38px;
margin: 0px;
padding: 0px;
background: #222;
float: left;
}
.banner-li-box ul li a {
display: block;
padding: 9px 6px 11px 6px;
margin: 0px;
}
.banner-li-box a:link,
.banner-li-box a:visited {
color: #fff;
text-decoration: none;
}
.banner-li-box a:hover {
color: rgb(102,204,0);
text-decoration: none;
background: url(../img/hover.png) no-repeat;
}
.banner-li-box-center {
360px;
height: 38px;
margin: 0px;
padding: 0px;
background: #222;
float: left;
}
.downandadd {
160px;
height: 38px;
margin: 0px;
padding: 0px;
background: #222;
float: left;
}
.downandadd ul {
list-style-type: none;
padding: 0px;
margin: 0px;
}
.downandadd ul li {
float: left;
text-align: center;
80px;
}
.downandadd ul li a {
display: block;
padding: 9px 6px 11px 6px;
margin: 0px;
}
.downandadd a:link,
.downandadd a:visited {
color: #fff;
text-decoration: none;
}
.downandadd a:hover {
color: rgb(102,204,0);
text-decoration: none;
background: url(../img/hover.png) no-repeat;
}
.reset ul {
list-style-type: none;
padding: 0px;
margin: 0px;
}
.reset ul li {
float: left;
text-align: center;
60px;
}
.reset ul li a {
display: block;
padding: 20px 6px 11px 6px;
margin: 0px;
}
.reset a:link,
.reset a:visited {
color: #fff;
text-decoration: none;
}
.reset a:hover {
color: rgb(102,204,0);
text-decoration: none;
}
.banner-li-box ul {
list-style-type: none;
padding: 0px;
margin: 0px;
}
.banner-li-box ul li {
float: left;
text-align: center;
80px;
}
.main {
100%;
height: 580px;
min- 1000px;
background: rgba(250, 250, 250,0);
text-align: center;
}
.main-center {
1000px;
margin: 0 auto;
background: rgba(255, 255, 255,0);
}
.center-up-up {
1000px;
height: 50px;
margin: 0px;
padding: 0px;
background: rgb(250, 250, 250);
float: left;
}
.center-up-up h2{
float: left;
}
.center-up {
1000px;
height: 480px;
margin: 0px;
padding: 0px;
background: url(../img/bac.png);
border-radius: 5px 5px 5px 5px;
float: left;
}
.center-down {
1000px;
height: 40px;
margin: 0px;
padding: 0px;
background: #222;
color: #fff;
float: left;
border-radius: 5px 5px 5px 5px;
}
.center-down ul {
list-style-type: none;
padding: 0px;
margin: 0px;
}
.center-down ul li {
float: left;
text-align: center;
60px;
}
.center-down ul li a {
display: block;
padding: 9px 6px 11px 6px;
margin: 0px;
}
.center-down a:link,
.center-down a:visited {
color: #fff;
text-decoration: none;
}
.center-down a:hover {
color: rgb(102,204,0);
text-decoration: none;
background: url(../img/hoverdown.png) no-repeat;
}
.footer {
100%;
height: 60px;
min- 1000px;
background: #222;
text-align: center;
}
.footer h4{
color: #fff;
}
.song-box {
990px;
height: 470px;
margin: 5px 5px;
padding: 0px;
background: rgba(255,255,255,0);
float: left;
}
.song {
margin: 3.5px 2.5px 3px 3.5px;
padding: 0px;
487px;
height: 150px;
border:0.1px solid #222;
background: url(../img/songbac.png) no-repeat;
float: left;
border-radius: 5px;
}
#submit{
margin:20px 0px 1px 0px;
height:38px;
display: block;
border:1px solid #222;
border-radius: 5px;
}
#submit:link,
#submit:visited {
color: #222;
text-decoration: none;
}
#submit:hover {
color: rgb(255,255,255);
text-decoration: none;
background: #222;
}
#inp{
border:1px solid #222;
border-radius: 5px;
185px;
height: 35px;
}
#formf{
margin:50px auto auto 350px;
}
.one {
150px;
height: 150px;
margin: 0px;
padding: 0px;
background: rgba(255,255,255,0.7);
float: left;
border-radius: 5px 0px 0px 5px;
}
.one img {
150px;
height: 150px;
border-radius: 5px 0px 0px 5px;
}
.two {
187px;
height: 150px;
margin: 0px;
padding: 0px;
background: rgba(255,255,255,0.7);
float: left;
}
.three {
150px;
height: 150px;
margin: 0px;
padding: 0px;
background: rgba(255,255,255,0.7);
float: left;
border-radius: 0px 5px 5px 0px;
}
.two-1 {
187px;
height: 50px;
margin: 0px;
padding: 0px;
background: rgba(255,255,255,0);
float: left;
}
.two-2 {
187px;
height: 50px;
margin: 0px;
padding: 0px;
background: rgba(255,255,255,0);
float: left;
}
.two-3 {
187px;
height: 50px;
margin: 0px;
padding: 0px;
background: rgba(255,255,255,0);
float: left;
}
.three-1 {
150px;
height: 75px;
margin: 0px;
padding: 0px;
background: rgba(255,255,255,0);
float: left;
border-radius: 0px 5px 0px 0px;
}
.three-2 {
150px;
height: 75px;
margin: 0px;
padding: 0px;
background: rgba(255,255,255,0);
float: left;
border-radius: 0px 0px 5px 0px;
}
.update{
margin: 20px 25px 20px 25px;
padding: 0px;
100px;
height: 35px;
border:1px solid #222;
background-color: rgba(255,255,255,0);
line-height: 30px;
text-align: center;
border-radius: 5px 5px 5px 5px;
}
.delete{
margin: 20px 25px 20px 25px;
padding: 0px;
100px;
height: 35px;
border:1px solid #222;
background-color: rgba(255,255,255,0);
line-height: 30px;
text-align: center;
border-radius: 5px 5px 5px 5px;
}
.update a {
display: block;
padding: 2.5px 2.5px 2.5px 2.5px;
margin: 0px;
border-radius: 3px 3px 3px 3px;
}
.update a:link,
.update a:visited {
color: #222;
text-decoration: none;
}
.update a:hover {
color: rgb(255,255,255);
text-decoration: none;
background: #222;
}
.delete a {
display: block;
padding: 2.5px 2.5px 2.5px 2.5px;
margin: 0px;
border-radius: 3px 3px 3px 3px;
}
.delete a:link,
.delete a:visited {
color: #222;
text-decoration: none;
}
.delete a:hover {
color: rgb(255,255,255);
text-decoration: none;
background: #222;
}
.areabutton{
margin: 0px 6px 0px -5px;
142px;
height: 35px;
border-radius: 3px 3px 3px 3px;
border: 1px solid #222;
background: rgba(2, 2, 2, 0);
}
style2.css
[genuitec-file-id="wc1-3"],[genuitec-lp-path="/ss/WebRoot/css/style2.css"],[genuitec-lp-enabled=false]{
/* for codelive */
}
.body {
background: blue;
margin: 0px;
padding: 0px;
font-size: 15px;
font-family: 'Microsoft Yahei', Tahoma, Helvetica, Arial, sans-serif;
}
.head {
100%;
height: 100px;
min- 1000px;
background: #fff;
text-align: center;
}
.head-center {
1000px;
margin: 0 auto;
background: #fff;
}
.logo-box {
margin: 0px;
padding: 0px;
97px;
height: 60px;
float: left;
}
.middle {
100%;
height: 330px;
min- 1000px;
background: #A6D4AF;
text-align: center;
}
.middle-center {
1000px;
margin: 0 auto;
background: url(../img/kk.png) no-repeat;
}
.welcom {
margin: 0px;
padding: 0px;
1000px;
height: 330px;
background: url(../img/TIM截图20171226230438.png);
}
.form {
/* margin: 0px 0px 0px 0px; */
/* padding: 0px; */
344px;
height: 330px;
/* float:float;
border-radius: 3px 3px 3px 3px;
border:1px solid #222; */
background:rgba(250,250,250,0.4);
}
.footer {
100%;
height: 60px;
min- 1000px;
background: #fff;
text-align: center;
}
.foot {
1000px;
margin: 0 auto;
background: #fff;
}
.foot-two {
margin: 0px;
padding: 0px;
1000px;
height: 60px;
background: #fff;
}
.error-left{
300px;
height: 60px;
float:left;
}
.one {
margin: 5px 0px 5px 20px;
padding: 25px 0px 0px 0px;
304px;
height: 38px;
background: rgba(2, 2, 2, 0);
/* border-radius: 3px 3px 3px 3px;
border:1px solid #222; */
}
.one-left {
margin: 5px 5px 5px 5px;
142px;
height: 38px;
background: rgba(2, 2, 2, 0);
/* border-radius: 3px 3px 3px 3px;
border:1px solid #222; */
float: left;
}
#submit{
145px;
height: 40px;
display: block;
border:1px solid #222;
border-radius: 3px 3px 3px 3px;
font-size: 18px;
font-family: 'Microsoft Yahei';
}
#submit:link,
#submit:visited {
color: #222;
text-decoration: none;
}
#submit:hover {
color: rgb(255,255,255);
text-decoration: none;
background: #222;
}
.one-right {
margin: 5px 5px 5px 5px;
142px;
height: 38px;
background: rgba(2, 2, 2, 0);
/* border-radius: 3px 3px 3px 3px;
border:1px solid #222; */
float: left;
}
.one-button {
304px;
height: 38px;
border-radius: 3px 3px 3px 3px;
border: 1px solid #222;
background: rgba(2, 2, 2, 0);
}
.one-left-button {
margin: 0px 6px 0px -5px;
142px;
height: 38px;
border-radius: 3px 3px 3px 3px;
border: 1px solid #222;
background: rgba(2, 2, 2, 0);
}
.one-right-button {
margin: 0px 0px 0px 6px;
142px;
height: 38px;
border-radius: 3px 3px 3px 3px;
border: 1px solid #222;
background: rgba(2, 2, 2, 0);
float: left;
}
.one-rr{
margin: 5px 5px 5px 5px;
142px;
height: 30px;
background: rgba(2, 2, 2, 0);
/* border-radius: 3px 3px 3px 3px;
border:1px solid #222; */
float: left;
font-size: 18px;
font-family: 'Microsoft Yahei';
}
.one-rr a:link,
.one-rr a:visited {
color: #222;
background:url(../img/registerb.png) np-repeat;
text-decoration: none;
}
.one-rr a:hover {
color: #222;
text-decoration: none;
background: url(../img/register.png) no-repeat;
}
.error{
list-style-type: none;
color:red;
}
style3.css
[genuitec-file-id="wc1-4"],[genuitec-lp-path="/ss/WebRoot/css/style4.css"],[genuitec-lp-enabled=false]{
/* for codelive */
}
.body {
background: blue;
margin: 0px;
padding: 0px;
font-size: 15px;
font-family: 'Microsoft Yahei', Tahoma, Helvetica, Arial, sans-serif;
}
.head {
100%;
height: 100px;
min- 1000px;
background: #fff;
text-align: center;
}
.head-center {
1000px;
margin: 0 auto;
background: #fff;
}
.logo-box {
margin: 0px;
padding: 0px;
97px;
height: 60px;
float: left;
}
.middle {
100%;
height: 330px;
min- 1000px;
background: #A6D4AF;
text-align: center;
}
.middle-center {
1000px;
margin: 0 auto;
background: url(../img/kk.png) no-repeat;
}
.welcom {
margin: 0px;
padding: 0px;
1000px;
height: 330px;
background: url(../img/TIM截图20171226230438.png);
}
.form {
/* margin: 0px 0px 0px 0px; */
/* padding: 0px; */
344px;
height: 330px;
/* float:float;
border-radius: 3px 3px 3px 3px;
border:1px solid #222; */
background:rgba(250,250,250,0.4);
}
.footer {
100%;
height: 60px;
min- 1000px;
background: #fff;
text-align: center;
}
.foot {
1000px;
margin: 0 auto;
background: #fff;
}
.foot-two {
margin: 0px;
padding: 0px;
1000px;
height: 60px;
background: #fff;
}
.error-left{
300px;
height: 60px;
float:left;
}
.one {
margin: 3px 0px 3px 20px;
padding: 8px 0px 0px 0px;
304px;
height: 35px;
background: rgba(2, 2, 2, 0);
/* border-radius: 3px 3px 3px 3px;
border:1px solid #222; */
}
.one-left {
margin: 5px 5px 5px 5px;
142px;
height: 35px;
background: rgba(2, 2, 2, 0);
/* border-radius: 3px 3px 3px 3px;
border:1px solid #222; */
float: left;
}
#submit{
145px;
height: 40px;
display: block;
border:1px solid #222;
border-radius: 3px 3px 3px 3px;
font-size: 18px;
font-family: 'Microsoft Yahei';
}
#submit:link,
#submit:visited {
color: #222;
text-decoration: none;
}
#submit:hover {
color: rgb(255,255,255);
text-decoration: none;
background: #222;
}
.one-right {
margin: 5px 5px 5px 5px;
142px;
height: 35px;
background: rgba(2, 2, 2, 0);
/* border-radius: 3px 3px 3px 3px;
border:1px solid #222; */
float: left;
}
.one-button {
304px;
height: 35px;
border-radius: 3px 3px 3px 3px;
border: 1px solid #222;
background: rgba(2, 2, 2, 0);
}
.one-left-button {
margin: 0px 6px 0px -5px;
142px;
height: 35px;
border-radius: 3px 3px 3px 3px;
border: 1px solid #222;
background: rgba(2, 2, 2, 0);
}
.one-right-button {
margin: 0px 0px 0px 6px;
142px;
height: 35px;
border-radius: 3px 3px 3px 3px;
border: 1px solid #222;
background: rgba(2, 2, 2, 0);
float: left;
}
.one-rr{
margin: 5px 5px 5px 5px;
142px;
height: 30px;
background: rgba(2, 2, 2, 0);
/* border-radius: 3px 3px 3px 3px;
border:1px solid #222; */
float: left;
font-size: 18px;
font-family: 'Microsoft Yahei';
}
.one-rr a:link,
.one-rr a:visited {
color: #222;
background:url(../img/registerb.png) np-repeat;
text-decoration: none;
}
.one-rr a:hover {
color: #222;
text-decoration: none;
background: url(../img/register.png) no-repeat;
}
.error{
list-style-type: none;
color:red;
}
新建 text 目录、img 目录。
在 src 目录下创建三个 java 类
- CreateImageAction.java
- MusicTableAction.java
- UserTable.java。
CreateImageAction.java
package action;
import java.awt.Color;
import java.awt.Font;
import java.awt.Graphics;
import java.awt.image.BufferedImage;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.util.Random;
import javax.imageio.ImageIO;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.apache.struts2.ServletActionContext;
import com.opensymphony.xwork2.ActionSupport;
public class CreateImageAction extends ActionSupport {
private ByteArrayInputStream inputStream;
private static int WIDTH = 142;
private static int HEIGHT = 38;
public ByteArrayInputStream getInputStream() {
return inputStream;
}
public void setInputStream(ByteArrayInputStream inputStream) {
this.inputStream = inputStream;
}
private static String createRandom() {
String str = "0123456789qwertyuiopasdfghjklzxcvbnm";
char[] rands = new char[4];
Random random = new Random();
for (int i = 0; i < 4; i++) {
rands[i] = str.charAt(random.nextInt(36));
}
return new String(rands);
}
private void drawBackground(Graphics g) {
// 画背景
g.setColor(new Color(166,212,175));
g.fillRect(0, 0, WIDTH, HEIGHT);
// 随机产生 120 个干扰点
for (int i = 0; i < 120; i++) {
int x = (int) (Math.random() * WIDTH);
int y = (int) (Math.random() * HEIGHT);
int red = (int) (Math.random() * 255);
int green = (int) (Math.random() * 255);
int blue = (int) (Math.random() * 255);
g.setColor(new Color(red, green, blue));
g.drawOval(x, y, 1, 0);
}
}
private void drawRands(Graphics g, String rands) {
g.setColor(new Color(42,76,43));
g.setFont(new Font(null, Font.BOLD, 40));
// 在不同的高度上输出验证码的每个字符
g.drawString("" + rands.charAt(0), 5, 30);
g.drawString("" + rands.charAt(1), 35, 30);
g.drawString("" + rands.charAt(2), 65, 30);
g.drawString("" + rands.charAt(3), 95, 30);
System.out.println(rands);
}
public String execute() throws Exception {
HttpServletResponse response = ServletActionContext.getResponse();
// 设置浏览器不要缓存此图片
response.setHeader("Pragma", "no-cache");
response.setHeader("Cache-Control", "no-cache");
response.setDateHeader("Expires", 0);
String rands = createRandom();
BufferedImage image = new BufferedImage(WIDTH, HEIGHT, BufferedImage.TYPE_INT_RGB);
Graphics g = image.getGraphics();
// 产生图像
drawBackground(g);
drawRands(g, rands);
// 结束图像 的绘制 过程， 完成图像
g.dispose();
ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
ImageIO.write(image, "jpeg", outputStream);
ByteArrayInputStream input = new ByteArrayInputStream(outputStream.toByteArray());
this.setInputStream(input);
HttpSession session = ServletActionContext.getRequest().getSession();
session.setAttribute("checkCode", rands);
input.close();
outputStream.close();
return SUCCESS;
}
}
MusicTableAction.java
package action;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import org.apache.struts2.ServletActionContext;
import org.hibernate.Query;
import org.hibernate.Session;
import com.opensymphony.xwork2.ActionSupport;
import bean.MusicTable;
import config.HibernateSessionFactory;
import method.CreateTxt;
import method.ListToString;
public class MusicTableAction extends ActionSupport {
private MusicTable music;
private List<MusicTable> list;
private List<Object[]> list3;
private char s = 's';
private int pageNum;
private int totalpage;
private int pageSize = 6;
private int Amount;
private InputStream fileInputStream;
private String downloadfileName;
private String tdfn;// truedownloadfilename哈哈哈哈
private int pageNum1;
private int totalpage1;
private int pageSize1 = 6;
private int Amount1;
private int pageNum2;
private int totalpage2;
private int pageSize2 = 6;
private int Amount2;
private int pageNum3;
private int totalpage3;
private int pageSize3 = 6;
private int Amount3;
private int pageNum4;
private int totalpage4;
private int pageSize4 = 6;
private int Amount4;
private int pageNum5;
private int totalpage5;
private int pageSize5 = 6;
private int Amount5;
private int pageNum6;
private int totalpage6;
private int pageSize6 = 6;
private int Amount6;
private File upload;
private String uploadFileName;
private String truepath;
private String name;
private String keyString;
// 对MusicTable的分页查询
public String find() {
System.out.println("进入find成功！");
Amount = getAmount();
this.totalpage = Amount % pageSize == 0 ? (Amount / pageSize) : (Amount / pageSize + 1);
if (pageNum <= 0) {
this.pageNum = 1;
}
if (pageNum > totalpage) {
this.pageNum = totalpage;
}
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
String hql = "from MusicTable";
Query query = session.createQuery(hql);
query.setFirstResult(((pageNum - 1) * pageSize));
query.setMaxResults(pageSize);
list = query.list();
System.out.println(list);
session.getTransaction().commit();
session.close();
return "success";
}
// 查询按local
public String local() {
System.out.println("进入local成功！");
Amount1 = getAmount1();
this.totalpage1 = Amount1 % pageSize1 == 0 ? (Amount1 / pageSize1) : (Amount1 / pageSize1 + 1);
if (pageNum1 <= 0) {
this.pageNum1 = 1;
}
if (pageNum1 > totalpage1) {
this.pageNum1 = totalpage1;
}
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
Query query = session.createQuery("from MusicTable where songarea = ?");
query.setFirstResult(((pageNum1 - 1) * pageSize1));
query.setMaxResults(pageSize1);
query.setParameter(0, "内地");
list = query.list();
session.getTransaction().commit();
session.close();
return SUCCESS;
}
// 查询按hongkong
public String hongkong() {
System.out.println("进入hongkong成功！");
Amount2 = getAmount2();
this.totalpage2 = Amount2 % pageSize2 == 0 ? (Amount2 / pageSize2) : (Amount2 / pageSize2 + 1);
if (pageNum2 <= 0) {
this.pageNum2 = 1;
}
if (pageNum2 > totalpage2) {
this.pageNum2 = totalpage2;
}
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
Query query = session.createQuery("from MusicTable where songarea = ?");
query.setFirstResult(((pageNum2 - 1) * pageSize2));
query.setMaxResults(pageSize2);
query.setParameter(0, "港台");
list = query.list();
session.getTransaction().commit();
session.close();
return SUCCESS;
}
// 查询按usa
public String usa() {
System.out.println("进入usa成功！");
Amount3 = getAmount3();
this.totalpage3 = Amount3 % pageSize3 == 0 ? (Amount3 / pageSize3) : (Amount3 / pageSize3 + 1);
if (pageNum3 <= 0) {
this.pageNum3 = 1;
}
if (pageNum3 > totalpage3) {
this.pageNum3 = totalpage3;
}
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
Query query = session.createQuery("from MusicTable where songarea = ?");
query.setFirstResult(((pageNum3 - 1) * pageSize3));
query.setMaxResults(pageSize3);
query.setParameter(0, "欧美");
list = query.list();
session.getTransaction().commit();
session.close();
return SUCCESS;
}
// 查询按japan
public String japan() {
System.out.println("进入japan成功！");
Amount4 = getAmount4();
this.totalpage4 = Amount4 % pageSize4 == 0 ? (Amount4 / pageSize4) : (Amount4 / pageSize4 + 1);
if (pageNum4 <= 0) {
this.pageNum4 = 1;
}
if (pageNum4 > totalpage4) {
this.pageNum4 = totalpage4;
}
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
Query query = session.createQuery("from MusicTable where songarea = ?");
query.setFirstResult(((pageNum4 - 1) * pageSize4));
query.setMaxResults(pageSize4);
query.setParameter(0, "日本");
list = query.list();
session.getTransaction().commit();
session.close();
return SUCCESS;
}
// 查询按korea
public String korea() {
System.out.println("进入korea成功！");
Amount5 = getAmount5();
this.totalpage5 = Amount5 % pageSize5 == 0 ? (Amount5 / pageSize5) : (Amount5 / pageSize5 + 1);
if (pageNum5 <= 0) {
this.pageNum5 = 1;
}
if (pageNum5 > totalpage5) {
this.pageNum5 = totalpage5;
}
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
Query query = session.createQuery("from MusicTable where songarea = ?");
query.setFirstResult(((pageNum5 - 1) * pageSize5));
query.setMaxResults(pageSize5);
query.setParameter(0, "韩国");
list = query.list();
session.getTransaction().commit();
session.close();
return SUCCESS;
}
// 添加
public String upload() throws Exception {
System.out.println("进入upload成功！");
String path = ServletActionContext.getServletContext().getRealPath("/");
InputStream is = new FileInputStream(upload);
String ext = uploadFileName.substring(uploadFileName.lastIndexOf("."));
name = System.currentTimeMillis() + ext;
OutputStream os = new FileOutputStream(path + "img/" + name);
byte buffer[] = new byte[1024];
int count = 0;
while ((count = is.read(buffer)) > 0) {
os.write(buffer, 0, count);
}
os.close();
is.close();
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
Query query = session.createQuery("select id from MusicTable");
MusicTable music1 = new MusicTable();
music1.setUploader(music.getUploader());
music1.setSongtitle(music.getSongtitle());
music1.setSinger(music.getSinger());
music1.setSongimg(name);
music1.setAudiolength(music.getAudiolength());
music1.setSongarea(music.getSongarea());
session.save(music1);
session.getTransaction().commit();
session.close();
return SUCCESS;
}
// 下载歌单
public String download() {
System.out.println("进入download成功！");
String pathdw = ServletActionContext.getServletContext().getRealPath("/");
File file = new File(pathdw + "/text/" + getTdfn());
downloadfileName = file.getName();// 获取文件名
try {
fileInputStream = new FileInputStream(file);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return SUCCESS;
}
// 对musicTable的投影查询根据id
public String createMusicList() {
System.out.println("进入createMusicList成功！");
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
Query query = session.createQuery(
"select new List(id,songtitle,singer,uploader,audiolength,songarea) from MusicTable music");
list3 = query.list();
CreateTxt createTxt = new CreateTxt();
ListToString listToString = new ListToString();
Date d = new Date();
System.out.println(d);
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
String dateNowStr = sdf.format(d);
System.out.println(dateNowStr);
try {
createTxt.creatTxtFile(dateNowStr + "SongList");
tdfn = dateNowStr + "SongList.txt";
createTxt.writeTxtFile(listToString.listToString(list3, s));
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
session.getTransaction().commit();
session.close();
return "success";
}
// 删除前
public String predel() {
return SUCCESS;
}
// 删除
public String del() {
System.out.println("进入del成功！");
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
MusicTable music2 = (MusicTable) session.load(MusicTable.class, music.getId());
session.delete(music2);
session.getTransaction().commit();
session.close();
return SUCCESS;
}
// 修改前
public String preupdate() {
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
String hql = "select songtitle,singer,songimg,songarea from MusicTable where id=" + music.getId();
Query query = session.createQuery(hql);
list = query.list();
for (Iterator iter = list.iterator(); iter.hasNext();) {
Object[] obj = (Object[]) iter.next();
music.setSongtitle((String) obj[0]);
music.setSinger((String) obj[1]);
music.setSongarea((String) obj[3]);
}
session.getTransaction().commit();
session.close();
return SUCCESS;
}
// 修改
public String update() {
System.out.println("进入update成功！");
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
MusicTable music3 = (MusicTable) session.load(MusicTable.class, music.getId());
music3.setSongtitle(music.getSongtitle());
music3.setSinger(music.getSinger());
music3.setSongarea(music.getSongarea());
session.update(music3);
session.getTransaction().commit();
session.close();
return SUCCESS;
}
// 按查询关键字
public String search() {
System.out.println("进入search成功！");
Amount6 = getAmount6();
this.totalpage6 = Amount6 % pageSize6 == 0 ? (Amount6 / pageSize6) : (Amount6 / pageSize6 + 1);
if (pageNum6 <= 0) {
this.pageNum6 = 1;
}
if (pageNum6 > totalpage6) {
this.pageNum6 = totalpage6;
}
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
Query query = session.createQuery("from MusicTable where songtitle like ?");
query.setFirstResult(((pageNum6 - 1) * pageSize6));
query.setMaxResults(pageSize6);
query.setParameter(0, "%" + getKeyString() + "%");
list = query.list();
session.getTransaction().commit();
session.close();
return SUCCESS;
}
// getters and setters
public MusicTable getMusic() {
return music;
}
public void setMusic(MusicTable music) {
this.music = music;
}
public List<MusicTable> getList() {
return list;
}
public void setList(List<MusicTable> list) {
this.list = list;
}
public int getPageNum() {
return pageNum;
}
public void setPageNum(int pageNum) {
this.pageNum = pageNum;
}
public int getTotalpage() {
return totalpage;
}
public void setTotalpage(int totalpage) {
this.totalpage = totalpage;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
public int getAmount() {
int i = 0;
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
String hql = "select count(*) from MusicTable";
Query query = session.createQuery(hql);
// 2、获取结果（结果为long类型）
Object obj = query.uniqueResult();
// 3、转化为long(类型为long，转为int会报错)
Long long1 = (Long) obj;
i = long1.intValue();
session.getTransaction().commit();
session.close();
return i;
}
public int getAmount1() {
int i = 0;
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
String hql = "select count(*) from MusicTable where songarea = '内地'";
Query query = session.createQuery(hql);
// 2、获取结果（结果为long类型）
Object obj = query.uniqueResult();
// 3、转化为long(类型为long，转为int会报错)
Long long1 = (Long) obj;
i = long1.intValue();
session.getTransaction().commit();
session.close();
return i;
}
public int getAmount2() {
int i = 0;
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
String hql = "select count(*) from MusicTable where songarea = '港台'";
Query query = session.createQuery(hql);
// 2、获取结果（结果为long类型）
Object obj = query.uniqueResult();
// 3、转化为long(类型为long，转为int会报错)
Long long1 = (Long) obj;
i = long1.intValue();
session.getTransaction().commit();
session.close();
return i;
}
public int getAmount3() {
int i = 0;
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
String hql = "select count(*) from MusicTable where songarea = '欧美'";
Query query = session.createQuery(hql);
// 2、获取结果（结果为long类型）
Object obj = query.uniqueResult();
// 3、转化为long(类型为long，转为int会报错)
Long long1 = (Long) obj;
i = long1.intValue();
session.getTransaction().commit();
session.close();
return i;
}
public int getAmount4() {
int i = 0;
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
String hql = "select count(*) from MusicTable where songarea = '日本'";
Query query = session.createQuery(hql);
// 2、获取结果（结果为long类型）
Object obj = query.uniqueResult();
// 3、转化为long(类型为long，转为int会报错)
Long long1 = (Long) obj;
i = long1.intValue();
session.getTransaction().commit();
session.close();
return i;
}
public int getAmount5() {
int i = 0;
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
String hql = "select count(*) from MusicTable where songarea = '韩国'";
Query query = session.createQuery(hql);
// 2、获取结果（结果为long类型）
Object obj = query.uniqueResult();
// 3、转化为long(类型为long，转为int会报错)
Long long1 = (Long) obj;
i = long1.intValue();
session.getTransaction().commit();
session.close();
return i;
}
public void setAmount(int amount) {
Amount = amount;
}
public int getPageNum1() {
return pageNum1;
}
public void setPageNum1(int pageNum1) {
this.pageNum1 = pageNum1;
}
public int getTotalpage1() {
return totalpage1;
}
public void setTotalpage1(int totalpage1) {
this.totalpage1 = totalpage1;
}
public int getPageSize1() {
return pageSize1;
}
public void setPageSize1(int pageSize1) {
this.pageSize1 = pageSize1;
}
public int getPageNum2() {
return pageNum2;
}
public void setPageNum2(int pageNum2) {
this.pageNum2 = pageNum2;
}
public int getTotalpage2() {
return totalpage2;
}
public void setTotalpage2(int totalpage2) {
this.totalpage2 = totalpage2;
}
public int getPageSize2() {
return pageSize2;
}
public void setPageSize2(int pageSize2) {
this.pageSize2 = pageSize2;
}
public int getPageNum3() {
return pageNum3;
}
public void setPageNum3(int pageNum3) {
this.pageNum3 = pageNum3;
}
public int getTotalpage3() {
return totalpage3;
}
public void setTotalpage3(int totalpage3) {
this.totalpage3 = totalpage3;
}
public int getPageSize3() {
return pageSize3;
}
public void setPageSize3(int pageSize3) {
this.pageSize3 = pageSize3;
}
public int getPageNum4() {
return pageNum4;
}
public void setPageNum4(int pageNum4) {
this.pageNum4 = pageNum4;
}
public int getTotalpage4() {
return totalpage4;
}
public void setTotalpage4(int totalpage4) {
this.totalpage4 = totalpage4;
}
public int getPageSize4() {
return pageSize4;
}
public void setPageSize4(int pageSize4) {
this.pageSize4 = pageSize4;
}
public int getPageNum5() {
return pageNum5;
}
public void setPageNum5(int pageNum5) {
this.pageNum5 = pageNum5;
}
public int getTotalpage5() {
return totalpage5;
}
public void setTotalpage5(int totalpage5) {
this.totalpage5 = totalpage5;
}
public int getPageSize5() {
return pageSize5;
}
public void setPageSize5(int pageSize5) {
this.pageSize5 = pageSize5;
}
public void setAmount1(int amount1) {
Amount1 = amount1;
}
public void setAmount2(int amount2) {
Amount2 = amount2;
}
public void setAmount3(int amount3) {
Amount3 = amount3;
}
public void setAmount4(int amount4) {
Amount4 = amount4;
}
public void setAmount5(int amount5) {
Amount5 = amount5;
}
public String getKeyString() {
return keyString;
}
public void setKeyString(String keyString) {
this.keyString = keyString;
}
public int getAmount6() {
int i = 0;
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
String hql = "select count(*) from MusicTable where songtitle like ?";
Query query = session.createQuery(hql);
query.setParameter(0, "%" + getKeyString() + "%");
// 2、获取结果（结果为long类型）
Object obj = query.uniqueResult();
// 3、转化为long(类型为long，转为int会报错)
Long long1 = (Long) obj;
i = long1.intValue();
session.getTransaction().commit();
session.close();
return i;
}
public int getPageNum6() {
return pageNum6;
}
public void setPageNum6(int pageNum6) {
this.pageNum6 = pageNum6;
}
public int getTotalpage6() {
return totalpage6;
}
public void setTotalpage6(int totalpage6) {
this.totalpage6 = totalpage6;
}
public int getPageSize6() {
return pageSize6;
}
public void setPageSize6(int pageSize6) {
this.pageSize6 = pageSize6;
}
public void setAmount6(int amount6) {
Amount6 = amount6;
}
public File getUpload() {
return upload;
}
public void setUpload(File upload) {
this.upload = upload;
}
public String getUploadFileName() {
return uploadFileName;
}
public void setUploadFileName(String uploadFileName) {
this.uploadFileName = uploadFileName;
}
public String getTruepath() {
return truepath;
}
public void setTruepath(String truepath) {
this.truepath = truepath;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public List<Object[]> getList3() {
return list3;
}
public void setList3(List<Object[]> list3) {
this.list3 = list3;
}
public char getS() {
return s;
}
public void setS(char s) {
this.s = s;
}
public InputStream getFileInputStream() {
return fileInputStream;
}
public void setFileInputStream(InputStream fileInputStream) {
this.fileInputStream = fileInputStream;
}
public String getDownloadfileName() {
return downloadfileName;
}
public void setDownloadfileName(String downloadfileName) {
this.downloadfileName = downloadfileName;
}
public String getTdfn() {
return tdfn;
}
public void setTdfn(String tdfn) {
this.tdfn = tdfn;
}
UserTable.java
package action;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpSession;
import org.apache.struts2.ServletActionContext;
import org.hibernate.Query;
import org.hibernate.Session;
import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
import bean.UserTable;
import config.HibernateSessionFactory;
public class UserTableAction extends ActionSupport {
private UserTable user;
private List<UserTable> list2;
private String checkCode;
// 登录
public String login() {
System.out.println("进入login成功！");
HttpSession session2 = ServletActionContext.getRequest().getSession();
boolean validated = false;
String usr = user.getUsername();
String pwd = user.getPassword();
String checkCode2 = (String) session2.getAttribute("checkCode");
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
String hql = "from UserTable WHERE username = ? AND password = ?";
try {
System.out.println(checkCode2);
List<UserTable> listx = session.createQuery(hql).setString(0, usr).setString(1, pwd).list();
if (usr.equals(listx.get(0)) && pwd.equals(listx.get(1)) && checkCode.equals(checkCode2))
validated = true;
ActionContext actionContext = ActionContext.getContext();
Map<String, Object> map = actionContext.getSession();
map.put(usr, user);
session.getTransaction().commit();
session.close();
return SUCCESS;
} catch (Exception e) {
return INPUT;
}
}
// 注册
public String register() {
System.out.println("进入register成功！");
Session session = HibernateSessionFactory.getSession();
session.beginTransaction();
Query query = session.createQuery("select id from UserTable");
UserTable user1 = new UserTable();
user1.setUsername(user.getUsername());
user1.setPassword(user.getPassword());
user1.setSex(user.getSex());
user1.setEmail(user.getEmail());
user1.setBirthday(user.getBirthday());
user1.setIdnumber(user.getIdnumber());
user1.setQualify(user.getQualify());
session.save(user1);
session.getTransaction().commit();
session.close();
return SUCCESS;
}
//登出
public String logout(){
System.out.println("进入logout成功！");
ActionContext actionContext = ActionContext.getContext();
Map<String, Object> map = actionContext.getSession();
map.remove(user);
return SUCCESS;}
// getters and setters
public UserTable getUser() {
return user;
}
public void setUser(UserTable user) {
this.user = user;
}
public List<UserTable> getList2() {
return list2;
}
public void setList2(List<UserTable> list2) {
this.list2 = list2;
}
public String getCheckCode() {
return checkCode;
}
public void setCheckCode(String checkCode) {
this.checkCode = checkCode;
}
}
在同目录下创建验证 XML 文件：
- UserTableAction-login-validation.xml
- UserTableAction-register-validation.xml
UserTableAction-login-validation.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE validators PUBLIC
"-//Apache Struts//XWork Validator 1.0.3//EN"
"http://struts.apache.org/dtds/xwork-validator-1.0.3.dtd">
<validators>
<!-- 检验username属性 -->
<field name="user.username">
<!-- 验证字符串不能为空，即必填 -->
<field-validator type="requiredstring">
<!-- 去空格 -->
<param name="trim">true</param>
<!-- 错误信息提示 -->
<message>请输入姓名</message>
</field-validator>
<!-- 指定name属性必须匹配的正则表达式 -->
<field-validator type="regex">
<param name="expression"><![CDATA[(\w{4,20})]]></param>
<!-- 错误信息提示 -->
<message>您输入的姓名只能是字母和数字，且长度在4到20之间</message>
</field-validator>
</field>
<!-- 检验password属性 -->
<field name="user.password">
<!-- 指定password属性必须满足必填规则 -->
<field-validator type="requiredstring">
<param name="trim">true</param>
<!-- 错误信息提示 -->
<message>请输入密码</message>
</field-validator>
<!-- 指定password属性必须匹配的正则表达式 -->
<field-validator type="regex">
<param name="expression"><![CDATA[(\w{6})]]></param>
<!-- 错误信息提示 -->
<message>您输入的密码必须为六位数字</message>
</field-validator>
</field>
<field name="checkCode">
<field-validator type="requiredstring">
<message>请输入验证码</message>
</field-validator>
<field-validator type="validationCodeValidator">
<param name="checkCode">
#session.checkCode
</param>
<message>验证码不正确</message>
</field-validator>
</field>
</validators>
UserTableAction-register-validation.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE validators PUBLIC
"-//Apache Struts//XWork Validator 1.0.3//EN"
"http://struts.apache.org/dtds/xwork-validator-1.0.3.dtd">
<validators>
<!-- 检验username属性 -->
<field name="user.username">
<!-- 验证字符串不能为空，即必填 -->
<field-validator type="requiredstring">
<!-- 去空格 -->
<param name="trim">true</param>
<!-- 错误信息提示 -->
<message>请输入姓名</message>
</field-validator>
<field-validator type="stringlength">
<param name="minLength">4</param>
<param name="maxLength">16</param>
<param name="trim">true</param>
<message>用户名必须为${minLength}至${maxLength}个字符！,当前为${user.username}
</message>
</field-validator>
</field>
<!-- 检验password属性 -->
<field name="user.password">
<!-- 指定password属性必须满足必填规则 -->
<field-validator type="requiredstring">
<param name="trim">true</param>
<!-- 错误信息提示 -->
<message>请输入密码</message>
</field-validator>
<field-validator type="stringlength">
<!--去掉前后的空格 -->
<param name="trim">true</param>
<param name="minLength">6</param>
<param name="maxLength">20</param>
<message>密码必须为${minLength}至${maxLength}个字符,当前为${user.password}
</message>
</field-validator>
</field>
<!-- 检验email属性 -->
<field name="user.email">
<!-- 验证字符串不能为空，即必填 -->
<field-validator type="requiredstring">
<!-- 去空格 -->
<param name="trim">true</param>
<!-- 错误信息提示 -->
<message>请输入邮箱地址！</message>
</field-validator>
<field-validator type="email">
<param name="expression"><![CDATA[(\w{6})]]></param>
<!-- 错误信息提示 -->
<message>必须输入有效的电子邮件地址！</message>
</field-validator>
</field>
<!-- 检验idnumber属性 -->
<field name="user.idnumber">
<field-validator type="stringlength">
<!-- 长度最小值 -->
<param name="minLength">18</param>
<!-- 长度最大值 -->
<param name="minLength">18</param>
<!-- 错误信息提示 -->
<message>身份证号必须为18位！</message>
</field-validator>
</field>
</validators>
修改 struts.xml 如下：
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.5//EN"
"http://struts.apache.org/dtds/struts-2.5.dtd">
<struts>
<package name="default" extends="struts-default">
<!-- ··························upload(add)·························· -->
<action name="upload" class="action.MusicTableAction" method="upload">
<result name="success" type="chain">
<param name="actionName">find</param>
</result>
</action>
<!-- ··························下载·························· -->
<action name="download" class="action.MusicTableAction" method="download">
<result type="stream">
<param name="contentType">application/octet-stream</param>
<param name="inputName">fileInputStream</param>
<param name="contentDisposition">attachment;filename="${downloadfileName}"</param>
<param name="bufferSize">1024</param>
</result>
</action>
<!-- ··························createMusicList·························· -->
<action name="createMusicList" class="action.MusicTableAction" method="createMusicList">
<result name="success" type="chain">
<param name="actionName">download</param>
</result>
</action>
<!-- ··························predel·························· -->
<action name="predel" class="action.MusicTableAction" method="predel">
<result name="success">
<param name="location">/del.jsp</param>
<param name="song.id">${music.id}</param>
</result>
</action>
<!-- ··························del·························· -->
<action name="del" class="action.MusicTableAction" method="del">
<result name="success" type="chain">
<param name="actionName">find</param>
<param name="song.id">${music.id}</param>
</result>
</action>
<!-- ··························preupdate·························· -->
<action name="preupdate" class="action.MusicTableAction"
method="preupdate">
<result name="success">
<param name="location">/update.jsp</param>
</result>
</action>
<!-- ··························update·························· -->
<action name="update" class="action.MusicTableAction" method="update">
<result name="success" type="chain">
<param name="actionName">find</param>
</result>
</action>
<!-- ··························login·························· -->
<action name="login" class="action.UserTableAction" method="login">
<result name="success" type="chain">
<param name="actionName">find</param>
<param name="username">${username}</param>
</result>
<result name="error">
<param name="location">/error.jsp</param>
</result>
<result name="input">/login.jsp</result>
</action>
<!-- ··························register·························· -->
<action name="register" class="action.UserTableAction" method="register">
<result name="success">/registersucc.jsp</result>
<result name="input">/register.jsp</result>
</action>
<!-- ··························logout·························· -->
<action name="logout" class="action.MusicTableAction" method="logout">
<result name="success">
<param name="location">/login.jsp</param>
</result>
</action>
<!-- ··························find·························· -->
<action name="find" class="action.MusicTableAction" method="find">
<result name="success">
<param name="location">/main.jsp</param>
</result>
</action>
<!-- ··························local·························· -->
<action name="local" class="action.MusicTableAction" method="local">
<result name="success">
<param name="location">/local.jsp</param>
</result>
</action>
<!-- ··························hongkong·························· -->
<action name="hongkong" class="action.MusicTableAction" method="hongkong">
<result name="success">
<param name="location">/hongkong.jsp</param>
</result>
</action>
<!-- ··························usa·························· -->
<action name="usa" class="action.MusicTableAction" method="usa">
<result name="success">
<param name="location">/usa.jsp</param>
</result>
</action>
<!-- ··························japan·························· -->
<action name="japan" class="action.MusicTableAction" method="japan">
<result name="success">
<param name="location">/japan.jsp</param>
</result>
</action>
<!-- ··························korea·························· -->
<action name="korea" class="action.MusicTableAction" method="korea">
<result name="success">
<param name="location">/korea.jsp</param>
</result>
</action>
<!-- ··························search·························· -->
<action name="search" class="action.MusicTableAction" method="search">
<result name="success">
<param name="location">/result.jsp</param>
</result>
</action>
<!-- ··························createImageAction·························· -->
<action name="createImageAction" class="action.CreateImageAction">
<result name="success" type="stream">
<param name="contentType">image/jpeg</param>
<param name="inputName">inputStream</param>
</result>
</action>
</package>
<constant name="struts.i18n.encoding" value="UTF-8"></constant>
</struts>
在 method 目录下新建两个类
- CreateTxt.java
- ListToString.java
CreateTxt.java
package method;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.PrintWriter;
import org.apache.struts2.ServletActionContext;
import action.MusicTableAction;
public class CreateTxt {
private String textpath;
private static String filenameTemp;
public boolean creatTxtFile(String name) throws IOException {
boolean flag = false;
filenameTemp = getTextpath() + name + ".txt";
File filename = new File(filenameTemp);
if (!filename.exists()) {
filename.createNewFile();
flag = true;
}
return flag;
}
public static boolean writeTxtFile(String newStr) throws IOException {
// 先读取原有文件内容，然后进行写入操作
boolean flag = false;
String filein = newStr + "\r\n";
String temp = "";
FileInputStream fis = null;
InputStreamReader isr = null;
BufferedReader br = null;
FileOutputStream fos = null;
PrintWriter pw = null;
try {
// 文件路径
File file = new File(filenameTemp);
// 将文件读入输入流
fis = new FileInputStream(file);
isr = new InputStreamReader(fis);
br = new BufferedReader(isr);
StringBuffer buf = new StringBuffer();
// 保存该文件原有的内容
for (int j = 1; (temp = br.readLine()) != null; j++) {
buf = buf.append(temp);
// System.getProperty("line.separator")
// 行与行之间的分隔符 相当于“\n”
buf = buf.append(System.getProperty("line.separator"));
}
buf.append(filein);
fos = new FileOutputStream(file);
pw = new PrintWriter(fos);
pw.write(buf.toString().toCharArray());
pw.flush();
flag = true;
} catch (IOException e1) {
// TODO 自动生成 catch 块
throw e1;
} finally {
if (pw != null) {
pw.close();
}
if (fos != null) {
fos.close();
}
if (br != null) {
br.close();
}
if (isr != null) {
isr.close();
}
if (fis != null) {
fis.close();
}
}
return flag;
}
public String getTextpath() {
System.out.println("这里是getTextpath！");
String p = ServletActionContext.getServletContext().getRealPath("/");
String q = p+"text/";
System.out.println(q);
return q;
}
public void setTextpath(String textpath) {
this.textpath = textpath;
}
}
ListToString.java
package method;
import java.util.List;
public class ListToString {
public String listToString(List<Object[]> list, char separator) {
StringBuilder sb = new StringBuilder();
for (int i = 0; i < list.size(); i++) {
sb.append(list.get(i));
if (i < list.size() - 1) {
sb.append(separator);
}
}
return sb.toString();
}
}
至此，项目建立完成，可发布至 Tomcat，并启动 Chrome 查看。