SSM实现添加查询，简单SSM框架

╰半夏微凉° 2022-10-10 11:23 223阅读 0赞

今天，博主给大家分享一个SSM项目的简单框架，即SSM项目的简单搭建过程。  
首先我们先对mybatis进行测试  
对数据持久层进行测试  
这块代码是只有mybatis的，其是通过获取sqlsession的方式进行数据操作的

public void sessionFactory() throws Exception{ 
    		//创建SqlSessionFactory的builder构造器
    		SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
    		//加载sqlMapConfig.xml
    		InputStream is=Resources.getResourceAsStream("sqlMapConfig.xml");
    		//创建SqlSessionFactory
    		SqlSessionFactory factory=builder.build(is);
    		//打开sqlsession
    		SqlSession sqlsession=factory.openSession();
    		//获取mapper接口的对象代理类对象
    		UserMapper usermapper=sqlsession.getMapper(UserMapper.class);
    		//操作
    		User user=new User();
    		
    		user.setUname("票系");
    		user.setPassword("123456");
    		usermapper.saveUser(user);
    		//提交事务
    		sqlsession.commit();
    		sqlsession.close();	}

整合了spring的mybatis,此时，其将sqlsession直接放入了spring容器中

<?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:context="http://www.springframework.org/schema/context"
    	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.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> 
    	
    	<context:property-placeholder location="classpath:jdbc.properties" /> 
    	
    	
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    		<property name="url" value="${jdbc.url}" />
    		<property name="driverClassName" value="${jdbc.driver}" />
    		<property name="username" value="${jdbc.username}" />
    		<property name="password" value="${jdbc.password}" />
    		<property name="maxActive" value="10" />
    		<property name="maxIdle" value="5" />
    	</bean> 
    	
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> 
    		<property name="dataSource" ref="dataSource" /> 
    		<property name="mapperLocations" value="classpath:mapper/*.xml" />
    	</bean>
    	
    	
    	
    	
    	
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> 
    	
    		<property name="basePackage" value="dao" />
    		
    	</bean>
    </beans>

在调用时，只需要读取相应的配置文件，然后再将spring容器中的sqlsession获取到即可

public void addtest(){ 
    		ApplicationContext ac=new ClassPathXmlApplicationContext("applicationContext.xml");
    		//获取对象
    		UserMapper usermapper=(UserMapper) ac.getBean("userMapper");
    		//调用方法
    		User user=new User();
    		user.setUname("白居易");
    		user.setPassword("123456");
    		usermapper.saveUser(user);
    	}

在确认我们的项目没有问题后再进行整合，看项目目录  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70]  
然后我们要配置的文件内容有：  
数据库连接文件 jdbc.properties

jdbc.url = jdbc\:mysql\:///book_store
    jdbc.driver = com.mysql.jdbc.Driver
    jdbc.username= root
    jdbc.password=

spring整合mybatis文件  
applicationContext.xml  
在该文件中，我们要进行数据库连接，开启事务扫描mapper包等

<?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:context="http://www.springframework.org/schema/context"
    	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.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> 
    	
    	<context:property-placeholder location="classpath:jdbc.properties" /> 
    	
    	
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    		<property name="url" value="${jdbc.url}" />
    		<property name="driverClassName" value="${jdbc.driver}" />
    		<property name="username" value="${jdbc.username}" />
    		<property name="password" value="${jdbc.password}" />
    		<property name="maxActive" value="10" />
    		<property name="maxIdle" value="5" />
    	</bean> 
    	
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> 
    		<property name="dataSource" ref="dataSource" /> 
    		<property name="mapperLocations" value="classpath:mapper/*.xml" />
    	</bean>
    		
    	
    	
    	
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> 
    	
    		<property name="basePackage" value="dao" />		
    	</bean>	
    	
    	<context:component-scan base-package="service"/>
    	
    	<bean id="transactionManager"		class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    		<property name="dataSource" ref="dataSource" />
    	</bean> 
    	
    	<tx:annotation-driven transaction-manager="transactionManager" />
    	
    	<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"/>
    </beans>

spring整合springmvc文件  
spring-mvc.xml  
在该文件中，我们要扫描所有的Controller并进行注解驱动，设置编码格式

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
        xmlns:mvc="http://www.springframework.org/schema/mvc"
        xmlns:contenxt="http://www.springframework.org/schema/context"
        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.xsd
            http://www.springframework.org/schema/mvc
            http://www.springframework.org/schema/mvc/spring-mvc.xsd
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context.xsd">
    
    	
    	<contenxt:component-scan base-package="controller"/>
    
    	
    	<mvc:annotation-driven></mvc:annotation-driven>
    	
        <mvc:annotation-driven>
            <mvc:message-converters>
                <bean class="org.springframework.http.converter.StringHttpMessageConverter">
                    <property name="supportedMediaTypes">
                        <list>
                            <value>text/html;charset=utf-8</value>
                        </list>
                    </property>
                </bean>
            </mvc:message-converters>
        </mvc:annotation-driven>
    	
    	<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    		
    		<property name="prefix" value="/WEB-INF/jsp/"/>
    		
    		<property name="suffix" value=".jsp"/>
    	</bean>
    </beans>

启动spring与springmvc,设置编码格式

<?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>mybatis_spring_transaction</display-name>
      
      <servlet>
    		<servlet-name>DispatcherServlet</servlet-name>
    		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    		
    		<init-param>
    			<param-name>contextConfigLocation</param-name>
    			<param-value>classpath:spring-mvc.xml</param-value>
    		</init-param>
    	</servlet>
    	<servlet-mapping>
    		<servlet-name>DispatcherServlet</servlet-name>
    		<url-pattern>*.action</url-pattern>
    	</servlet-mapping>
      
      <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>
    	
    	<filter>
            <filter-name>characterFilter</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>characterFilter</filter-name>
            <url-pattern>/*</url-pattern> </filter-mapping> <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> </web-app>

紧接着。整个项目便已配置完成，接下来便是进行测试是否能够正常访问，即测试springmvc的功能

@Controller
    @RequestMapping("/user")
    public class UserController { 
    	@RequestMapping("/test")    //最终的访问路径为项目名/user/test.action
    	public String test(){ 
    		return "test";
    }
    }

如图所示：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 1]  
测试访问页面成功后，我们写一个上传信息页面，包含上传图片  
![在这里插入图片描述][20210628091112945.png]  
页面很丑，先忍耐，我们待会会进行界面美化

@Controller
    @RequestMapping("/good")
    public class GoodsController { 
    	@Autowired
    	GoodsService gs;
    	@RequestMapping("/save")
    	public String save(MultipartFile file, Good good,HttpServletRequest request) { //这是保存上传的controller
    		try { 
    			return gs.save(file, good,request);
    		} catch (IOException e) { 
    			e.printStackTrace();
    		}
    		return null;
    	}
    	@RequestMapping("/list")
        public String listUser( Model model){ 
            List<Good> list= gs.list(); 
            model.addAttribute("list",list);
            System.out.println(list);
            return "list";
        }
    	@RequestMapping("/test")
    	public String test(){ 
    		return "test";
    	}
    
    }

服务层代码，进行图片上传处理，此处博主对上传进行了封装

@Service("GoodsService")
    @Transactional
    public class GoodsServiceImpl implements GoodsService{ 
    	@Autowired
    	private GoodsMapper gm;
    	@Override
    	@Transactional
    	public String save(MultipartFile file, Good good, HttpServletRequest request) throws IOException { 
    		
    		// 保存图片的路径，图片上传成功后，将路径保存到数据库
    		String newFileName="";
    		FileUploadUtil f=new FileUploadUtil();
    		newFileName=f.uploadSingleFile(file, request);
    		// 保存到数据库
    		good.setImage(newFileName);
    		gm.saveGoods(good);
    		return "redirect:/user/test.action";
    	}
    	@Override
    	public List<Good> list() { 
    		// TODO Auto-generated method stub
    		return gm.findAllGood();
    	}
    
    }

封装的图片上传工具类

public static String uploadSingleFile(MultipartFile file, HttpServletRequest request) { 
    		String path = null;
    		String originalFilename = file.getOriginalFilename();
    		if (!originalFilename.equals("")) { 
    			// 得到上传文件的文件扩展名
    			String newFileName = System.currentTimeMillis() + originalFilename;
    			// 得到上传文件保存路径的服务器端硬盘物理路径
    			String savePath = request.getServletContext().getRealPath("/img");
    			File f = new File(savePath);
    			if (!f.exists()) { 
    				f.mkdirs();
    			}
    			// 文件上传
    			try { 
    				File targetFile = new File(savePath, newFileName);
    				file.transferTo(targetFile);
    				path="img/"+newFileName;
    			} catch (IOException e) { 
    				e.printStackTrace();
    			}
    		}
    		System.out.println(path);
    		return path;
    	}

完成这些后，我们便可以进行测试，其中与此同时我们还写了查询操作  
看下页面  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 2]  
此处博主使用的是bootstrap框架，如此，我们便使用SSM框架完成了一个简单的项目上传图片并查询信息的功能，这是我们在开发时常用的小功能模块，后续我们可以在已配置好的框架上进行其他功能的开发。  
码字不易，给个赞呗！

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70]: /images/20221005/c6b007fcce0b4986b6738aaf37b7d2c8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 1]: /images/20221005/4c9e0e2b80a54485bcc18495e7674e81.png
[20210628091112945.png]: /images/20221005/d9b90b0ef45d482b9be0898579c83b78.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 2]: /images/20221005/4a1ec0a74208470ea63c357f8ca09384.png