SSH框架

package com.zl.entity;

import java.util.Date;

/**
 * Emp entity.
 * 
 * @author MyEclipse Persistence Tools
 */

public class Emp implements java.io.Serializable {

	// Fields

	private Long empno;
 
	private String ename;
	private String job;
	private Long mgr;
	private Date hiredate;
	private Double sal;
	private Double comm;

	// Constructors

	/** default constructor */
	public Emp() {
	}
   
	// Property accessors

	public Long getEmpno() {
		return this.empno;
	}

	public void setEmpno(Long empno) {
		this.empno = empno;
	}
 

	public String getEname() {
		return this.ename;
	}

	public void setEname(String ename) {
		this.ename = ename;
	}

	public String getJob() {
		return this.job;
	}

	public void setJob(String job) {
		this.job = job;
	}

	public Long getMgr() {
		return this.mgr;
	}

	public void setMgr(Long mgr) {
		this.mgr = mgr;
	}

	public Date getHiredate() {
		return this.hiredate;
	}

	public void setHiredate(Date hiredate) {
		this.hiredate = hiredate;
	}

	public Double getSal() {
		return this.sal;
	}

	public void setSal(Double sal) {
		this.sal = sal;
	}

	public Double getComm() {
		return this.comm;
	}

	public void setComm(Double comm) {
		this.comm = comm;
	}

}

注:applicationContext-action.xml,applicationContext-biz.xml,applicationContext-common.xml,applicationContext-dao.xml,hibernate.cfg.xml都放在src目录;




package com.zl.entity;

/**
 * Usertab entity.
 * 
 * @author MyEclipse Persistence Tools
 */

public class Usertab implements java.io.Serializable {

	// Fields

	private UsertabId id;

	// Constructors

	/** default constructor */
	public Usertab() {
	}

	/** full constructor */
	public Usertab(UsertabId id) {
		this.id = id;
	}

	// Property accessors

	public UsertabId getId() {
		return this.id;
	}

	public void setId(UsertabId id) {
		this.id = id;
	}

}

package com.zl.dao;

import java.util.List;

import com.zl.entity.Emp;

public interface EmpDao {
	
	public void addEmp(Emp  e);
	public void updateEmpByEmpNo(int empNo);
	public void deleteEmpByEmpNo(int empNo);
	public List<Emp>  selectAll();
}

package com.zl.dao.impl;

import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.zl.dao.EmpDao;
import com.zl.entity.Emp;

public class EmpDaoImpl extends  HibernateDaoSupport implements  EmpDao {

	public void addEmp(Emp e) {
		// TODO Auto-generated method stub
		
	}

	public void deleteEmpByEmpNo(int empNo) {
		// TODO Auto-generated method stub
		
	}

	public List<Emp> selectAll() {
	 
		return this.getSession().createQuery("from Emp").list();
	}

	public void updateEmpByEmpNo(int empNo) {
		// TODO Auto-generated method stub
		
	}

}

package com.zl.biz;

import java.util.List;

import com.zl.entity.Emp;

public interface EmpBiz {
	public void addEmp(Emp  e);
	public void updateEmpByEmpNo(int empNo);
	public void deleteEmpByEmpNo(int empNo);
	public List<Emp>  selectAll();
}

package com.zl.biz.impl;

import java.util.List;

import com.zl.biz.EmpBiz;
import com.zl.dao.EmpDao;
import com.zl.entity.Emp;

public class EmpBizImpl implements  EmpBiz {

	private  EmpDao  empdao;
	
	public void setEmpdao(EmpDao empdao) {
		this.empdao = empdao;
	}

	public void addEmp(Emp e) {
		// TODO Auto-generated method stub
		
	}

	public void deleteEmpByEmpNo(int empNo) {
		// TODO Auto-generated method stub
		
	}

	public List<Emp> selectAll() {
		 
		return empdao.selectAll();
	}

	public void updateEmpByEmpNo(int empNo) {
		// TODO Auto-generated method stub
		
	}

}

package com.zl.action;

import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;

import com.zl.biz.EmpBiz;
import com.zl.entity.Emp;

public class EmpAction extends DispatchAction {

	private EmpBiz  empbiz;
	
	
	public void setEmpbiz(EmpBiz empbiz) {
		this.empbiz = empbiz;
	}


	public ActionForward show(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		 
		List<Emp>  listemp=empbiz.selectAll();
		
		request.setAttribute("listemp", listemp);
		
		return  null;
	}
	
}

package com.zl.form;

import org.apache.struts.action.ActionForm;

import com.zl.entity.Emp;

public class EmpForm extends  ActionForm {
		private   Emp  emp=new Emp();

		public Emp getEmp() {
			return emp;
		}

		public void setEmp(Emp emp) {
			this.emp = emp;
		}
}

package com.zl.util;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;

/**
 * Configures and provides access to Hibernate sessions, tied to the
 * current thread of execution.  Follows the Thread Local Session
 * pattern, see {@link http://hibernate.org/42.html }.
 */
public class HibernateSessionFactory {

    /** 
     * Location of hibernate.cfg.xml file.
     * Location should be on the classpath as Hibernate uses  
     * #resourceAsStream style lookup for its configuration file. 
     * The default classpath location of the hibernate config file is 
     * in the default package. Use #setConfigFile() to update 
     * the location of the configuration file for the current session.   
     */
    private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";
	private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
    private  static Configuration configuration = new Configuration();
    private static org.hibernate.SessionFactory sessionFactory;
    private static String configFile = CONFIG_FILE_LOCATION;

	static {
    	try {
			configuration.configure(configFile);
			sessionFactory = configuration.buildSessionFactory();
		} catch (Exception e) {
			System.err
					.println("%%%% Error Creating SessionFactory %%%%");
			e.printStackTrace();
		}
    }
    private HibernateSessionFactory() {
    }
	
	/**
     * Returns the ThreadLocal Session instance.  Lazy initialize
     * the <code>SessionFactory</code> if needed.
     *
     *  @return Session
     *  @throws HibernateException
     */
    public static Session getSession() throws HibernateException {
        Session session = (Session) threadLocal.get();

		if (session == null || !session.isOpen()) {
			if (sessionFactory == null) {
				rebuildSessionFactory();
			}
			session = (sessionFactory != null) ? sessionFactory.openSession()
					: null;
			threadLocal.set(session);
		}

        return session;
    }

	/**
     *  Rebuild hibernate session factory
     *
     */
	public static void rebuildSessionFactory() {
		try {
			configuration.configure(configFile);
			sessionFactory = configuration.buildSessionFactory();
		} catch (Exception e) {
			System.err
					.println("%%%% Error Creating SessionFactory %%%%");
			e.printStackTrace();
		}
	}

	/**
     *  Close the single hibernate session instance.
     *
     *  @throws HibernateException
     */
    public static void closeSession() throws HibernateException {
        Session session = (Session) threadLocal.get();
        threadLocal.set(null);

        if (session != null) {
            session.close();
        }
    }

	/**
     *  return session factory
     *
     */
	public static org.hibernate.SessionFactory getSessionFactory() {
		return sessionFactory;
	}

	/**
     *  return session factory
     *
     *	session factory will be rebuilded in the next call
     */
	public static void setConfigFile(String configFile) {
		HibernateSessionFactory.configFile = configFile;
		sessionFactory = null;
	}

	/**
     *  return hibernate configuration
     *
     */
	public static Configuration getConfiguration() {
		return configuration;
	}

}

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">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

	<session-factory>
		<property name="connection.username">hello</property>
		<property name="connection.url">
			jdbc:oracle:thin:@localhost:1521:orcl
		</property>
		<property name="dialect">
			org.hibernate.dialect.Oracle9Dialect
		</property>
		<property name="myeclipse.connection.profile">oracle</property>
		<property name="connection.password">123</property>
		<property name="connection.driver_class">
			oracle.jdbc.driver.OracleDriver
		</property>
		<property name="show_sql">true</property>
		<property name="format_sql">true</property>
		<mapping resource="com/zl/entity/Emp.hbm.xml" />
		<mapping resource="com/zl/entity/Usertab.hbm.xml"></mapping>

	</session-factory>

</hibernate-configuration>

struts-config.xml:


<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.2//EN" "http://struts.apache.org/dtds/struts-config_1_2.dtd">

<struts-config>
  <data-sources />
  <form-beans>
  		<form-bean name="empForm" type="com.zl.form.EmpForm"></form-bean>
  </form-beans>
  
  <global-exceptions />
  <global-forwards />
  <action-mappings>
  		<action path="/empdo"
  				name="empForm"
  				scope="request"
  				type="org.springframework.web.struts.DelegatingActionProxy"
  				parameter="method"
  		>
  			<forward name="index" path="/index.jsp"></forward>
  		</action>
  
  </action-mappings>
  <message-resources parameter="com.yourcompany.struts.ApplicationResources" />
</struts-config>

web.xml:

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.4" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee   http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
 
 <context-param>
 		<param-name>contextConfigLocation</param-name>
 		<param-value>classpath:applicationContext-*.xml</param-value>
 </context-param>
 <listener>
 	<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
 </listener>
 
  <servlet>
    <servlet-name>action</servlet-name>
    <servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
    <init-param>
      <param-name>config</param-name>
      <param-value>/WEB-INF/struts-config.xml</param-value>
    </init-param>
    <init-param>
      <param-name>debug</param-name>
      <param-value>3</param-value>
    </init-param>
    <init-param>
      <param-name>detail</param-name>
      <param-value>3</param-value>
    </init-param>
    <load-on-startup>0</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>action</servlet-name>
    <url-pattern>*.do</url-pattern>
  </servlet-mapping>
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
</web-app>

index.jsp:


<%@ page language="java"  isELIgnored="false" import="java.util.*"  pageEncoding="UTF-8"%>
<%@taglib uri="http://struts.apache.org/tags-logic"  prefix="logic" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'index.jsp' starting page</title>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!-- contentType="application/vnd.ms-excel"  -->
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	
	-->
	  <jsp:include page="/empdo.do?method=show" />
 
  </head> 

  <body>
  <center><h1>员工管理</h1>
  	<table  border="1">
  		<tr>
  			<td>员工编号</td>
  			<td>员工名称</td>
  			<td>员工工作</td>
  			<td>员工上级</td>
  			<td>入职时间</td>
  			<td>员工薪水</td>
  			<td>额外薪水</td>
  			<td>操作</td>
  		</tr>
  		 <logic:iterate id="e"  name="listemp">
  		<tr>
  			<td>${e.empno}</td>
  			<td>${e.ename }</td>
  			<td>${e.job }</td>
  			<td>${e.mgr }</td>
  			<td>${e.hiredate} </td>
  			<td>${e.sal} </td>
  			<td>${e.comm} </td>
  			 
  			<td><a href="add.jsp">添加</a>/<a href="#">删除</a>/<a href="#">修改</a></td>
  		</tr>	
  		</logic:iterate>
  	</table>
  </center>
  </body>
</html>

com.zl.entity/Emp.hbm.xml


<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- 
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="com.zl.entity.Emp" table="EMP" schema="SCOTT">
        <id name="empno" type="java.lang.Long">
            <column name="EMPNO" precision="4" scale="0" />
            <generator class="sequence" />
        </id>
         
        <property name="ename" type="java.lang.String">
            <column name="ENAME" length="10" />
        </property>
        <property name="job" type="java.lang.String">
            <column name="JOB" length="9" />
        </property>
        <property name="mgr" type="java.lang.Long">
            <column name="MGR" precision="4" scale="0" />
        </property>
        <property name="hiredate" type="java.util.Date">
            <column name="HIREDATE" length="7" />
        </property>
        <property name="sal" type="java.lang.Double">
            <column name="SAL" precision="7" />
        </property>
        <property name="comm" type="java.lang.Double">
            <column name="COMM" precision="7" />
        </property>
    </class>
</hibernate-mapping>

com.zl.entity/Usertab.hbm.xml:


<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- 
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="com.zl.entity.Usertab" table="USERTAB" schema="SCOTT">
        <composite-id name="id" class="com.zl.entity.UsertabId">
            <key-property name="userid" type="java.lang.Long">
                <column name="USERID" precision="22" scale="0" />
            </key-property>
            <key-property name="username" type="java.lang.String">
                <column name="USERNAME" length="30" />
            </key-property>
            <key-property name="userpwd" type="java.lang.String">
                <column name="USERPWD" length="30" />
            </key-property>
        </composite-id>
    </class>
</hibernate-mapping>

applicationContext-dao.xml:

<?xml version="1.0" encoding="UTF-8"?>
<beans
	xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">


	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="configLocation"
			value="classpath:hibernate.cfg.xml">
		</property>
	</bean>
	
	<bean  id="empdao"  class="com.zl.dao.impl.EmpDaoImpl">
		<property name="sessionFactory"  ref="sessionFactory"></property>
	</bean>
	
	
	
 
	</beans>

applicationContext-biz.xml:
<?xml version="1.0" encoding="UTF-8"?>
<beans
	xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">


	<bean  id="empbiz"  class="com.zl.biz.impl.EmpBizImpl">
		<property name="empdao" ref="empdao"></property>
	</bean>


 </beans>

applicationContext-action.xml:

<?xml version="1.0" encoding="UTF-8"?>
<beans
	xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">


	<bean  name="/empdo"  class="com.zl.action.EmpAction">
		<property name="empbiz"  ref="empbiz" ></property>
	</bean>


 </beans>

applicationContext-common.xml:
<?xml version="1.0" encoding="UTF-8"?>
<beans
	xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
						http://www.springframework.org/schema/aop  http://www.springframework.org/schema/aop/spring-aop-2.0.xsd
						http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
						
	
	
	">


	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="configLocation"
			value="classpath:hibernate.cfg.xml">
		</property>
	</bean>
	
	<bean  id="transactionManager"  class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory"  ref="sessionFactory"></property>
	
	</bean>
	
	<tx:advice  id="txAdvice"  transaction-manager="transactionManager">
		<tx:attributes>
				<tx:method name="add*"  propagation="REQUIRED"/>
				<tx:method name="update*" propagation="REQUIRED"/>
				<tx:method name="delete*"  propagation="REQUIRED"/>
				<tx:method name="*"  read-only="true"/>
		</tx:attributes>
	
	</tx:advice>
	
	
	<aop:config>
			<aop:pointcut id="pointCut"  expression="execution(* com.zl.biz.impl.*.*(..))"/>
			<aop:advisor  advice-ref="txAdvice"  pointcut-ref="pointCut"/>
	
	</aop:config>
	
	
	
	</beans>



评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值