SSH整合集成

作者: soloist001 | 来源:发表于2019-10-04 13:42 被阅读0次

一集成Maven

1.下载Maven

（1）下载地址：http://maven.apache.org/download.cgi。下载maven文件并解压到指定你想放置的目录。比如：/Users/ll/

在Mac环境下选择第一个安装包
（2）将Maven放置的路径拖入到终端，查看路径位置，得到：/Users/ll/apache-maven-3.6.2
（3）设置环境变量
（3-1）编辑.bash_profile文件：

vim ~/.bash_profile

（3-2）配置maven文件地址：

export M2_HOME=/Users/ll/apache-maven-3.6.2
export PATH=$PATH:$M2_HOME/bin

（3-3）保存文件，执行如下命令使配置生效：

source ~/.bash_profile

（3-4）验证

mvn -v

经过以上步骤配置成功，
（3-5）接下来修改配置文件apache-maven-3.6.2/conf/setting.xml

//配置本地库存放的地址并打开localRepository，之前是被注释掉的
<settings xmlns="http://maven.apache.org/SETTINGS/1.0.0"
          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
          xsi:schemaLocation="http://maven.apache.org/SETTINGS/1.0.0 http://maven.apache.org/xsd/settings-1.0.0.xsd">
       <localRepository>/Users/ll/Maven/repository</localRepository>

//添加阿里云镜像
    <mirror>
         <id>alimaven</id>
         <name>aliyun maven</name>          <url>http://maven.aliyun.com/nexus/content/groups/public/</url>
         <mirrorOf>central</mirrorOf>
    </mirror>

配置成功后保存。
（3-6）安装

mvn help:system

二创建web-project工程

（1）创建工程

屏幕快照 2019-10-04 下午12.49.19.png

（2）add Maven Support

add Maven Support
(3) 创建配置文件

创建成功后maven结构如此

配置配置文件

（1）配置文件 pom.xml
pom.xml文件中添加需要集成进来的库

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>day10_Mevan01</groupId>
  <artifactId>day10_Mevan01</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>war</packaging>
  <name>day10_Mevan01</name>
  <description/>
  <properties>
    <webVersion>3.1</webVersion>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <servlet.version>7.0</servlet.version>
    <spring.version>4.1.0.RELEASE</spring.version>
  </properties>
  <dependencies>
    <dependency>
      <groupId>javax</groupId>
      <artifactId>javaee-api</artifactId>
      <version>${servlet.version}</version>
      <scope>provided</scope>
    </dependency>
    <dependency>
      <groupId>org.glassfish.web</groupId>
      <artifactId>javax.servlet.jsp.jstl</artifactId>
      <version>1.2.2</version>
    </dependency>
    <!-- spring相关包 -->
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-core -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-beans -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-beans</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-web -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-expression -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-orm -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- struts相关包 -->
    <!-- https://mvnrepository.com/artifact/org.apache.struts/struts2-core -->
    <dependency>
        <groupId>org.apache.struts</groupId>
        <artifactId>struts2-core</artifactId>
        <version>2.5</version>
    </dependency>
    <!-- struts2和Spring整合插件 -->
    <!-- https://mvnrepository.com/artifact/org.apache.struts/struts2-spring-plugin -->
    <dependency>
        <groupId>org.apache.struts</groupId>
        <artifactId>struts2-spring-plugin</artifactId>
        <version>2.5</version>
    </dependency>
    <!-- c3p0数据源 -->
    <!-- https://mvnrepository.com/artifact/c3p0/c3p0 -->
    <dependency>
        <groupId>c3p0</groupId>
        <artifactId>c3p0</artifactId>
        <version>0.9.1</version>
    </dependency>
    <!-- 数据驱动 -->
    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.39</version>
    </dependency>
    <!--hibernate相关包  -->
    <!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-core -->
    <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-core</artifactId>
        <version>4.1.0.Final</version>
    </dependency>
    <!-- 单元测试相关包 -->
    <!-- https://mvnrepository.com/artifact/junit/junit -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.1</version>
        <scope>test</scope>
    </dependency>
    <!-- 面向切面编程相关包 -->
    <!-- https://mvnrepository.com/artifact/org.aspectj/aspectjweaver -->
    <dependency>
        <groupId>org.aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>1.8.9</version>
    </dependency>

  </dependencies>
  <build>
    <plugins>
      <plugin>
        <artifactId>maven-compiler-plugin</artifactId>
        <version>2.3.2</version>
        <configuration>
          <source>1.7</source>
          <target>1.7</target>
        </configuration>
      </plugin>
      <plugin>
        <artifactId>maven-war-plugin</artifactId>
        <version>2.6</version>
        <configuration>
          <failOnMissingWebXml>false</failOnMissingWebXml>
        </configuration>
      </plugin>
    </plugins>
  </build>
</project>

<dependency> ....</dependency>包含的是maven坐标，如果要集成的库在本地仓库找不到，就到maven远程仓库中下载，搜索maven站点的库，复制进来，然后保存，myeclipse就自动加载

（2）配置文件web.xml
配置struts拦截核心控制器和Spring监听器

  <!-- struts核心控制器 -->
  <filter>
    <filter-name>struts2</filter-name>
    <filter-class>org.apache.struts2.dispatcher.filter.StrutsPrepareAndExecuteFilter</filter-class>
  </filter>
  <filter-mapping>
    <filter-name>struts2</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
  <!-- spring监听 -->
   <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:applicationContext.xml</param-value>
  </context-param>

（2）创建struts.xml文件并配置action

<?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="user" extends="struts-default" namespace="/user">
        <action name="user_query" class="cn.hd.action.UserAction" method="query">
            <result name="success">/user.jsp</result>
        </action>
    </package>

</struts>

（3）创建Spring applicationcontext.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:p="http://www.springframework.org/schema/p"
  xmlns:tx="http://www.springframework.org/schema/tx"
  xmlns:aop="http://www.springframework.org/schema/aop"
  xmlns:context="http://www.springframework.org/schema/context"
  xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
      http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd
      http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.1.xsd
      http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
  <!--扫描  -->
  <context:component-scan base-package="cn.hd.action"></context:component-scan>
  <context:component-scan base-package="cn.hd.dao.impl"></context:component-scan>
  <context:component-scan base-package="cn.hd.service.impl"></context:component-scan>
 <!--引入db.properties文件  -->
 <context:property-placeholder location="classpath:database.properties"/>
  <!-- 设置数据源 -->
  <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
      <property name="driverClass" value="${driverClass}"></property>
      <property name="jdbcUrl" value="${jdbcUrl}"></property>
      <property name="user" value="root"></property>
      <property name="password" value="${password}"></property>
  </bean>
  <bean id="sessionFactory"
      class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
      <property name="configLocation"
          value="classpath:hibernate.cfg.xml">
      </property>
      <property name="dataSource" ref="dataSource"></property>
  </bean>
  <bean id="transactionManager"
      class="org.springframework.orm.hibernate4.HibernateTransactionManager">
      <property name="sessionFactory" ref="sessionFactory" />
  </bean>
  <tx:annotation-driven transaction-manager="transactionManager" />
  <aop:config>
      <aop:pointcut expression="execution(* cn.hd.service.impl.*.*(..))" id="pointCut"/>
      <aop:advisor advice-ref="txAdvice" pointcut-ref="pointCut"/>
  </aop:config>
  <tx:advice id="txAdvice" transaction-manager="transactionManager">
      <tx:attributes>
          <!--是指事务的传播属性  -->
          <tx:method name="query*" propagation="REQUIRED" />
      </tx:attributes>
  </tx:advice>
</beans>

（4）拷贝hibernate配置文件hibernate.cfg.xml

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
         "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
         "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

<session-factory>
   <!--设置方言 -->
   <property name="dialect">
       org.hibernate.dialect.MySQLDialect
   </property>
   <mapping resource="cn/hd/model/TUser.hbm.xml" />
</session-factory>

</hibernate-configuration>

（5）创建属性配置文件 db.properties

driverClass=com.mysql.jdbc.Driver
jdbcUrl=jdbc:mysql://localhost:3306/eleshop?useSSL=false
user=root
password=00000000

#driverClass=com.mysql.jdbc.Driver
#jdbcUrl=jdbc:mysql://localhost:3306/eleshop?useSSL=false
#user=root
#password=00000000

四创建action

package cn.hd.action;


import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Controller;

import com.opensymphony.xwork2.ActionSupport;

import cn.hd.model.TUser;
import cn.hd.service.IUserService;

@Controller
public class UserAction extends ActionSupport {
   @Resource
   private IUserService service;
   private List<TUser> list;
   public String query() {
       setList(service.query());
       return SUCCESS;
   }
   public List<TUser> getList() {
       return list;
   }
   public void setList(List<TUser> list) {
       this.list = list;
   }
}

四创建service接口和接口实现类
cn.hd.service

package cn.hd.service;

import java.util.List;

import cn.hd.model.TUser;

public interface IUserService {
   List<TUser> query();
}

四创建service接口和接口实现类
cn.hd.service.impl

package cn.hd.service.impl;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import cn.hd.dao.IUserDao;
import cn.hd.model.TUser;
import cn.hd.service.IUserService;

@Service
public class UserServiceImpl implements IUserService{
   
   @Resource
   private IUserDao dao;
   
   @Override
   public List<TUser> query() {
       // TODO Auto-generated method stub
       return dao.query();
   }

五创建dao接口和接口实现类
cn.hd.dao

package cn.hd.dao;

import java.util.List;

import cn.hd.model.TUser;

public interface IUserDao {
  List<TUser> query();
}

六创建dao接口和接口实现类
cn.hd.dao.impl

package cn.hd.dao.impl;

import java.util.List;

import javax.annotation.Resource;

import org.hibernate.SessionFactory;
import org.springframework.stereotype.Repository;

import cn.hd.dao.IUserDao;
import cn.hd.model.TUser;

@Repository
public class UserDaoImpl implements IUserDao{

   @Resource
   private SessionFactory sessionFactory;
   
   @Override
   public List<TUser> query() {
       return sessionFactory.getCurrentSession().createQuery("from TUser").list();
   }

}

七反向生成TUser和配置文件，将配置文件添加到hibernate配置中
cn.hd.model

package cn.hd.model;

import java.util.Date;

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

public class TUser implements java.io.Serializable {

   // Fields

   private Integer userid;
   private String username;
   private String password;
   private String truename;
   private String usersex;
   private Date birthday;
   private String email;
   private String phoneno;
   private String postcade;
   private String address;
   private Date regdate;
   private String lockstate;
   private Date lastaccess;
   private Integer login;
   private String addr;

   // Constructors

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

   /** full constructor */
   public TUser(String username, String password, String truename, String usersex, Date birthday, String email,
           String phoneno, String postcade, String address, Date regdate, String lockstate, Date lastaccess,
           Integer login, String addr) {
       this.username = username;
       this.password = password;
       this.truename = truename;
       this.usersex = usersex;
       this.birthday = birthday;
       this.email = email;
       this.phoneno = phoneno;
       this.postcade = postcade;
       this.address = address;
       this.regdate = regdate;
       this.lockstate = lockstate;
       this.lastaccess = lastaccess;
       this.login = login;
       this.addr = addr;
   }

   // Property accessors

   public Integer getUserid() {
       return this.userid;
   }

   public void setUserid(Integer userid) {
       this.userid = userid;
   }

   public String getUsername() {
       return this.username;
   }

   public void setUsername(String username) {
       this.username = username;
   }

   public String getPassword() {
       return this.password;
   }

   public void setPassword(String password) {
       this.password = password;
   }

   public String getTruename() {
       return this.truename;
   }

   public void setTruename(String truename) {
       this.truename = truename;
   }

   public String getUsersex() {
       return this.usersex;
   }

   public void setUsersex(String usersex) {
       this.usersex = usersex;
   }

   public Date getBirthday() {
       return this.birthday;
   }

   public void setBirthday(Date birthday) {
       this.birthday = birthday;
   }

   public String getEmail() {
       return this.email;
   }

   public void setEmail(String email) {
       this.email = email;
   }

   public String getPhoneno() {
       return this.phoneno;
   }

   public void setPhoneno(String phoneno) {
       this.phoneno = phoneno;
   }

   public String getPostcade() {
       return this.postcade;
   }

   public void setPostcade(String postcade) {
       this.postcade = postcade;
   }

   public String getAddress() {
       return this.address;
   }

   public void setAddress(String address) {
       this.address = address;
   }

   public Date getRegdate() {
       return this.regdate;
   }

   public void setRegdate(Date regdate) {
       this.regdate = regdate;
   }

   public String getLockstate() {
       return this.lockstate;
   }

   public void setLockstate(String lockstate) {
       this.lockstate = lockstate;
   }

   public Date getLastaccess() {
       return this.lastaccess;
   }

   public void setLastaccess(Date lastaccess) {
       this.lastaccess = lastaccess;
   }

   public Integer getLogin() {
       return this.login;
   }

   public void setLogin(Integer login) {
       this.login = login;
   }

   public String getAddr() {
       return this.addr;
   }

   public void setAddr(String addr) {
       this.addr = addr;
   }

}

对应配置文件

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<!-- 
   Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
   <class name="cn.hd.model.TUser" table="T_USER" catalog="eleshop">
       <id name="userid" type="java.lang.Integer">
           <column name="USERID" />
           <generator class="increment" />
       </id>
       <property name="username" type="java.lang.String">
           <column name="USERNAME" length="20" />
       </property>
       <property name="password" type="java.lang.String">
           <column name="PASSWORD" length="20" />
       </property>
       <property name="truename" type="java.lang.String">
           <column name="TRUENAME" length="20" />
       </property>
       <property name="usersex" type="java.lang.String">
           <column name="USERSEX" length="1" />
       </property>
       <property name="birthday" type="java.util.Date">
           <column name="BIRTHDAY" length="10" />
       </property>
       <property name="email" type="java.lang.String">
           <column name="EMAIL" length="50" />
       </property>
       <property name="phoneno" type="java.lang.String">
           <column name="PHONENO" length="20" />
       </property>
       <property name="postcade" type="java.lang.String">
           <column name="POSTCADE" length="20" />
       </property>
       <property name="address" type="java.lang.String">
           <column name="ADDRESS" length="1024" />
       </property>
       <property name="regdate" type="java.util.Date">
           <column name="REGDATE" length="10" />
       </property>
       <property name="lockstate" type="java.lang.String">
           <column name="LOCKSTATE" length="1" />
       </property>
       <property name="lastaccess" type="java.util.Date">
           <column name="LASTACCESS" length="10" />
       </property>
       <property name="login" type="java.lang.Integer">
           <column name="LOGIN" />
       </property>
       <property name="addr" type="java.lang.String">
           <column name="addr" length="20" />
       </property>
   </class>
</hibernate-mapping>

八创建jsp文件对应在webapp目录下

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ taglib uri="/struts-tags" prefix="s" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
 <head>
   <base href="<%=basePath%>">
   
   <title>My JSP 'user.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">
   <!--
   <link rel="stylesheet" type="text/css" href="styles.css">
   -->

 </head>
 
 <body>
   <s:iterator var="user" value="list">
       <s:property value="#list.userid"/>-----
       <s:property value="username"/>-----
       <s:property value="password"/>-----<br>
   </s:iterator>
 </body>
</html>

九添加到tomcat服务器并发布

是在浏览器进行访问

SSH整合集成

相关文章

网友评论

延伸阅读

深度阅读

栏目导航

热点阅读