开发工具:eclipse
数据库:MySQL
服务器:tomcat7.0
配置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_4_0.xsd" id="WebApp_ID" version="4.0">
<display-name>struts-hibernate-CRUD</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
<filter>
<filter-name>SetCharacterEncodingFilter</filter-name>
<filter-class>filter.SetCharacterEncodingFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>SetCharacterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<filter>
<filter-name>struts2</filter-name>
<!-- <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class> -->
<filter-class>filter.UeditorFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>struts2</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>
配置struts:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
"http://struts.apache.org/dtds/struts-2.0.dtd">
<struts>
<constant name = "struts.devMode" value = "true" />
<!-- <constant name="struts.action.excludePattern" value="/ueditor/.*" /> -->
<package name = "strutsNewsWorld" extends = "hibernate-default" namespace="/">
<!--显示新闻-->
<action name = "listAll" class = "com.zz.action.NewsAction" method = "listAll">
<result name = "success">/list_news.jsp</result>
<result name = "error"> /Error.jsp</result>
</action>
<action name = "showNews" class = "com.zz.action.NewsAction" method = "listAll">
<result name = "success">/index.jsp</result>
<result name = "error"> /Error.jsp</result>
</action>
<action name = "news1" class = "com.zz.action.NewsAction" method = "listAll">
<result name = "success">/news.jsp</result>
<result name = "error"> /Error.jsp</result>
</action>
<action name = "news2" class = "com.zz.action.NewsAction" method = "listAll">
<result name = "success">/news2.jsp</result>
<result name = "error"> /Error.jsp</result>
</action>
<action name = "news3" class = "com.zz.action.NewsAction" method = "listAll">
<result name = "success">/news3.jsp</result>
<result name = "error"> /Error.jsp</result>
</action>
<action name = "news4" class = "com.zz.action.NewsAction" method = "listAll">
<result name = "success">/news4.jsp</result>
<result name = "error"> /Error.jsp</result>
</action>
<action name = "new" class = "com.zz.action.NewsAction" method = "listAll">
<result name = "success">/article.jsp</result>
<result name = "error"> /Error.jsp</result>
</action>
<!--添加新闻-->
<action name = "insertNews" class = "com.zz.action.NewsAction" method = "insertNews">
<result name = "success" type="chain">listAll</result>
<result name = "error"> /Error.jsp</result>
</action>
<!--查询新闻-->
<action name = "findNews" class = "com.zz.action.NewsAction" method = "findById">
<result name = "success">/updatenews.jsp</result>
<result name = "error"> /Error.jsp</result>
</action>
<action name = "getNews" class = "com.zz.action.NewsAction" method = "findById">
<result name = "success">/article.jsp</result>
<result name = "error"> /Error.jsp</result>
</action>
<!--修改新闻-->
<action name = "updateNews" class = "com.zz.action.NewsAction" method = "updateNews">
<result name = "success" type="chain">listAll</result>
<result name = "error"> /Error.jsp</result>
</action>
<!--删除新闻-->
<action name = "deleteNews" class = "com.zz.action.NewsAction" method = "deleteNews">
<result name = "success" type="chain">listAll</result>
<result name = "error"> /Error.jsp</result>
</action>
<!--登陆-->
<action name="login" class="com.zz.action.LoginAction" method="execute">
<result name="success" type="chain">listAll</result>
<result name="error">/login.jsp</result>
</action>
</package>
<!-- <constant name="struts.enable.DynamicMethodInvocarion" value="true"></constant>-->
</struts>
配置hibernate.cfg.xml:
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class"> com.mysql.jdbc.Driver </property>
<property name="connection.url"> jdbc:mysql://localhost:3306/test?characterEncoding=utf-8</property>
<!-- <property name="connection.useUnicode">true</property>-->
<property name="connection.characterEncoding">UTF-8</property>
<property name="hibernate.connection.username">root</property>
<property name="connection.password">123456</property>
<property name="connection.pool_size">1</property>
<!--<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>-->
<property name="show_sql">true</property>
<mapping class="com.zz.entity.News" />
</session-factory>
</hibernate-configuration>
实体类News:
package com.zz.entity;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
//An entity representing Game Record
@Entity
@Table(name = "News")
public class News {
private int id;
private String category;
private String title;
private String content;
@Id
@GeneratedValue
@Column(name = "id")
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
@Column(name = "title")
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
@Column(name = "content")
public String getContent() {
return content;
}
public void setContent(String content) {
this.content = content;
}
@Column(name = "category")
public String getCategory() {
return category;
}
public void setCategory(String category) {
// TODO Auto-generated method stub
this.category = category;
}
@Override
public String toString() {
StringBuilder builder = new StringBuilder();
builder.append("News [id=").append(id).append(", title=").append(title).append(", content=").append(content).append(", category=").append(category)
.append("]");
return builder.toString();
}
}
LoginAction:
package com.zz.action;
import com.opensymphony.xwork2.ActionSupport;
public class LoginAction extends ActionSupport{
private static final long serialVersionUID = 1L;
private String name;
private String password;
public String execute()
{
if("zzdoreen".equals(this.name) && "zz8986123".equals(this.password))
return "success";
else
return "error";
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
NewsAction:
package com.zz.action;
import com.opensymphony.xwork2.ActionSupport;
public class LoginAction extends ActionSupport{
private static final long serialVersionUID = 1L;
private String name;
private String password;
public String execute()
{
if("zzdoreen".equals(this.name) && "zz8986123".equals(this.password))
return "success";
else
return "error";
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
dao层:
创建类NewsDAO:
package com.zz.dao;
import java.util.List;
import com.zz.entity.News;
//DataAccess layer for game table in the database;
public interface NewsDAO {
public void insertNews(News news);
public void updateNews(News news);
public void deleteNews(int id);
public News findById(int id);
public List<News> listAll();
public boolean isIdPresent(int id);
}
创建接口NewsDAOImpl:
package com.zz.dao;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.Transaction;
import com.googlecode.s2hibernate.struts2.plugin.annotations.SessionTarget;
import com.googlecode.s2hibernate.struts2.plugin.annotations.TransactionTarget;
import com.zz.entity.News;
//Implementation of dataAccessLayer
public class NewsDAOImpl implements NewsDAO {
//These objects are injected using the Full Hibernate Plug-in 1.4 GA.
@SessionTarget
Session session;
@TransactionTarget
Transaction transaction;
@Override
public void insertNews(News news) {
try {
session.save(news);
} catch (Exception e) {
transaction.rollback();
e.printStackTrace();
}
}
@Override
public void updateNews(News news) {
try {
session.clear();
session.update(news);
} catch (Exception e) {
transaction.rollback();
e.printStackTrace();
session.close();
}
}
@Override
public void deleteNews(int id) {
try {
News news = (News) session.get(News.class, id);
session.delete(news);
} catch (Exception e) {
transaction.rollback();
e.printStackTrace();
}
}
@Override
public News findById(int id) {
session.clear();
return (News) session.get(News.class, id);
}
@SuppressWarnings("unchecked")
@Override
public List<News> listAll() {
return session.createQuery("from News").list(); //The table name is Entity class name representing database table
}
public boolean isIdPresent(int id) {
News news = (News) session.get(News.class, id);
if(news==null) {
return false;
}else{
return true;
}
}
}
我还有两个过滤器 一个是解决编码问题的,一个是解决struts2和富文本编辑器冲突的
package filter;
import java.io.IOException;
import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletRequestWrapper;
public class SetCharacterEncodingFilter implements Filter{
class Request extends HttpServletRequestWrapper
{
public Request(HttpServletRequest request) {
super(request);
}
public String toUTF8(String input) {
try {
byte[] bytes = input.getBytes("ISO8859-1");
return new String(bytes, "utf-8");
} catch (Exception ex) {
}
return null;
}
private HttpServletRequest getHttpServletRequest()
{
return (HttpServletRequest) super.getRequest();
}
public String getParameter(String name)
{
return
toUTF8(getHttpServletRequest().getParameter(name));
}
public String[] getParameterValues(String name)
{
String values[] =getHttpServletRequest().getParameterValues(name);
if (values != null) {
for (int i = 0; i < values.length; i++) {
values[i] = toUTF8(values[i]);
}
}
return values;
}
}
public void destroy() {
}
public void doFilter(ServletRequest request, ServletResponse
response,FilterChain chain) throws IOException, ServletException {
HttpServletRequest httpreq = (HttpServletRequest) request;
if (httpreq.getMethod().equals("POST")) {
request.setCharacterEncoding("utf-8");
} else {
request = new Request(httpreq);
}
chain.doFilter(request, response);
}
public void init(FilterConfig filterConfig) throws
ServletException {
}
}
package filter;
import java.io.IOException;
import javax.servlet.FilterChain;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter;
public class UeditorFilter extends StrutsPrepareAndExecuteFilter{
public void doFilter(ServletRequest req, ServletResponse res,
FilterChain chain) throws IOException, ServletException{
HttpServletRequest request =(HttpServletRequest) req;
String url =request.getRequestURI();
if (url.contains("/ueditor/jsp/controller.jsp")) {
chain.doFilter(req, res);
}else{
super.doFilter(req, res, chain);
}
}
}
主页面显示:
管理员界面:
源码下载:https://download.youkuaiyun.com/download/qq_41341769/10808124
GitHub下载地址: https://github.com/zzdoreen/Struts2-Hibernate-News (☆▽☆)(疯狂明示!!!)