Intellij idea通过maven搭建ssm框架(实现获取数据库数据显示在页面中)

系统管理员 2022-05-17 00:47 176阅读 0赞

## 其实idea和eclipse搭建ssm框架基本上相同，但是还是有些许的区别 ##

*  首选我们建立一个maven项目  
    ![这里写图片描述][70]  
    maven项目名称等信息，自己填写好就行
 *  来看看我们的项目结构，你可以像我一样建立起文件夹和文件的结构  
    ![这里写图片描述][70 1]  
    结构很清晰，我们慢慢搭建我们的ssm项目
 *  我们打开项目设置在web项里，点击右边加号，让它获取我们的web.xml位置  
    ![这里写图片描述][70 2]  
    现在我们来写上面建立的文件里面的代码
 *  pom.xml

<?xml version="1.0" encoding="UTF-8"?>
    <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>top.maniy</groupId>
        <artifactId>ssm_maven_demo</artifactId>
        <version>1.0-SNAPSHOT</version>
        <packaging>war</packaging>
    
        <dependencies>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.0.9</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.32</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>4.1.3.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>4.1.3.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-beans</artifactId>
                <version>4.1.3.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>4.1.3.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aspects</artifactId>
                <version>4.1.3.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jms</artifactId>
                <version>4.1.3.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context-support</artifactId>
                <version>4.1.3.RELEASE</version>
            </dependency>
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.2.8</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>1.2.2</version>
            </dependency>
            <dependency>
                <groupId>com.github.miemiedev</groupId>
                <artifactId>mybatis-paginator</artifactId>
                <version>1.2.15</version>
            </dependency>
            <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper</artifactId>
                <version>3.2.1</version>
            </dependency>
            
            <dependency>
                <groupId>org.apache.commons</groupId>
                <artifactId>commons-lang3</artifactId>
                <version>3.3.2</version>
            </dependency>
            <dependency>
                <groupId>org.apache.commons</groupId>
                <artifactId>commons-io</artifactId>
                <version>1.3.2</version>
            </dependency>
            <dependency>
                <groupId>commons-net</groupId>
                <artifactId>commons-net</artifactId>
                <version>3.3</version>
            </dependency>
            
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-databind</artifactId>
                <version>2.4.2</version>
            </dependency>
            
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
                <scope>test</scope>
            </dependency>
            
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-log4j12</artifactId>
                <version>1.6.4</version>
            </dependency>
            
            <dependency>
                <groupId>jstl</groupId>
                <artifactId>jstl</artifactId>
                <version>1.2</version>
            </dependency>
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>servlet-api</artifactId>
                <version>2.5</version>
                <scope>provided</scope>
            </dependency>
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>jsp-api</artifactId>
                <version>2.0</version>
                <scope>provided</scope>
            </dependency>
        </dependencies>
    
        <build>
            <finalName>${project.artifactId}</finalName>
            <plugins>
                           
                <plugin>
                    <groupId>org.apache.maven.plugins</groupId>
                    <artifactId>maven-compiler-plugin</artifactId>
                    <version>3.2</version>
                    <configuration>
                        <source>1.8</source>
                        <target>1.8</target>
                        <encoding>UTF-8</encoding>
                    </configuration>
                </plugin>
            </plugins>
            
    
    
        </build>
    </project>

*  applicationContext-dao.xml

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
    	xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
    	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
    	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-4.0.xsd
    	http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
    	http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
    	http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
    	
    	
    	<context:property-placeholder location="classpath:jdbc.properties" />
    		
    	
    	<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
    		<property name="driverClassName" value="${jdbc.driver}" />
    		<property name="url" value="${jdbc.url}" />
    		<property name="username" value="${jdbc.username}" />
    		<property name="password" value="${jdbc.password}" />
    	</bean>
    	
    	
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		
    		<property name="configLocation" value="classpath:mybatis/SqlMapConfig.xml" />
    		
    		<property name="dataSource" ref="dataSource" />
    		
    		
            
            <property name="mapperLocations" value="classpath:mapper/*.xml"/>
    
        </bean>
    
    	
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    
            
    		<property name="basePackage" value="top.maniy.demo.mapper" />
    
    	</bean>
    
    
        
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            
            <property name="dataSource" ref="dataSource"/>
        </bean>
    
        
        <tx:annotation-driven transaction-manager="transactionManager"/>
    
    
    </beans>

*  applicationContext-service.xml

*  springmvc.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:context="http://www.springframework.org/schema/context"
    	xmlns:mvc="http://www.springframework.org/schema/mvc"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
            http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
    	
    	<context:component-scan base-package="top.maniy.demo.controller" />
    
    	<mvc:annotation-driven />
    	
    	
    	
    	
    
    	<mvc:default-servlet-handler />
    
    	
    	<bean	class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    		<property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
    
    		
    		<property name="prefix" value="/WEB-INF/jsp/" />
    		
    		<property name="suffix" value=".jsp" />
    	</bean>
    </beans>

*  jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/ssm?characterEncoding=utf-8
    jdbc.username=root
    jdbc.password=root

*  SqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    	
    	<typeAliases>
    		<package name="top.maniy.demo.entity"/>
    	</typeAliases>
    </configuration>

*  web.xml

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
             version="4.0">
    
        <welcome-file-list>
    
            <welcome-file>index</welcome-file>
    
        </welcome-file-list>
        
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring/applicationContext-*.xml</param-value>
        </context-param>
    
        
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
    
        
        <filter>
            <filter-name>encoding</filter-name>
            <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
            <init-param>
                <param-name>encoding</param-name>
                <param-value>UTF-8</param-value>
            </init-param>
        </filter>
        <filter-mapping>
            <filter-name>encoding</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>
    
    
        
        <servlet>
            <servlet-name>SpringMVC</servlet-name>
            <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
            <init-param>
                <param-name>contextConfigLocation</param-name>
                <param-value>classpath:spring/springmvc.xml</param-value>
            </init-param>
            
            
            
            <load-on-startup>1</load-on-startup>
        </servlet>
        <servlet-mapping>
            <servlet-name>SpringMVC</servlet-name>
            
            <url-pattern>/</url-pattern>
        </servlet-mapping>
        
        <servlet-mapping>
            <servlet-name>SpringMVC</servlet-name>
            
            <url-pattern>/index</url-pattern>
        </servlet-mapping>
    
    </web-app>

*  CustomerMapper.java

package top.maniy.demo.mapper;
    
    import java.util.List;
    
    
    import top.maniy.demo.entity.Customer;
    
    public interface CustomerMapper {
    
    
    
    	//获取全部用户
    	public List<Customer> findAllCustomer();
    }

*  CustomerMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper
    PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace ="top.maniy.demo.mapper.CustomerMapper">
    
    
    
    	<select id="findAllCustomer" resultType="Customer">
    		select * from customer
    	</select>
    	
    
    </mapper>

*  CustomerService.java

package top.maniy.demo.service;
    
    import top.maniy.demo.entity.Customer;
    
    import java.util.List;
    
    
    
    public interface CustomerService {
    
    	
    
    
    		//获取全部用户
    		public List<Customer> findAllCustomer();
    }

*  CustomerServiceImpl.java

package top.maniy.demo.service;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Transactional;
    import top.maniy.demo.entity.Customer;
    import top.maniy.demo.mapper.CustomerMapper;
    
    /**
     * 客户管理
     * @author Admin
     *
     */
    @Service
    @Transactional
    public class CustomerServiceImpl implements CustomerService {
    		
    	@Autowired
    	private CustomerMapper customerMapper;
    	
    	//获取全部用户
    	public List<Customer> findAllCustomer() {
    		return customerMapper.findAllCustomer();
    	}
    	
    }

*  Customer.java

package top.maniy.demo.entity;
    
    import java.util.Date;
    
    public class Customer {
    
    	private Long cust_id;
    	private String cust_name;
    	public Long getCust_id() {
    		return cust_id;
    	}
    	public void setCust_id(Long cust_id) {
    		this.cust_id = cust_id;
    	}
    	public String getCust_name() {
    		return cust_name;
    	}
    	public void setCust_name(String cust_name) {
    		this.cust_name = cust_name;
    	}
    }

*  CustomerController.java

package top.maniy.demo.controller;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestBody;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.ResponseBody;
    import top.maniy.demo.entity.Customer;
    import top.maniy.demo.service.CustomerService;
    
    @Controller
    public class CustomerController {
    	@Autowired
    	private CustomerService customerService;
    	@RequestMapping(value ="index")
    	   public String index() {	
    			return "index";
    	   }
       @RequestMapping(value ="/customer/list")
       @ResponseBody
       public List<Customer> list() {	
    		return customerService.findAllCustomer();
       } 
    }

1.  代码就这么多了，还有一个数据库我想看实体类和jdbc.properties应该可以直接弄好
2.  然后我们添加tomcat  
    ![这里写图片描述][70 3]

## 最后我们运行看看效果吧 ##

完美运行（这个是表字段没有删之前的）。  
![这里写图片描述][70 4]

## 如果要写junit单元测试的话要加上 ##

@RunWith(SpringJUnit4ClassRunner.class)//帮我们创建容器
    //指定创建容器是使用那些配置文件
    @ContextConfiguration(locations = {"classpath*:/spring/applicationContext-dao.xml","classpath*:/spring/applicationContext-service.xml"})

1.  项目源代码及sql文件  
    [https://download.csdn.net/download/imaniy/10582400][https_download.csdn.net_download_imaniy_10582400]

[70]: /images/20220517/ad11ef736b2247fa9b5f4ae6147d9048.png
[70 1]: /images/20220517/81db0c760614464189b66f87c82044cf.png
[70 2]: /images/20220517/1856d1e3022a4361a712edd58a1847eb.png
[70 3]: /images/20220517/628f86c7f3b1457bb364d363b8fc0678.png
[70 4]: /images/20220517/0f36b9c3d9314f10b796c33479040af9.png
[https_download.csdn.net_download_imaniy_10582400]: https://download.csdn.net/download/imaniy/10582400