SSM

最新推荐文章于 2025-03-10 23:37:04 发布

有钱有钱

最新推荐文章于 2025-03-10 23:37:04 发布

阅读量101

点赞数

分类专栏： String 文章标签： SSM

本文链接：https://blog.youkuaiyun.com/weixin_43358395/article/details/100920446

版权

String 专栏收录该内容

10 篇文章

订阅专栏

@Autowired:自动注入

在这里插入图片描述

导包，配置文件

lib

在这里插入图片描述

关于数据库的spring-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"   
       xmlns:mybatis="http://mybatis.org/schema/mybatis-spring"  
       xmlns:context="http://www.springframework.org/schema/context"  
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd  
       http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd  
       http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">  
      
    <!-- 扫描指定包下的接口，自动引入mapper-->  
    <mybatis:scan base-package="com.chinasofti.mapper"/>  
    <!--引入属性文件 -->  
    <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    	<property name="locations" value="classpath:jdbc.properties"/>
	</bean>
      
    <!--数据库连接-->  
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">  
		<property name="driverClassName" value="${driverClassName}"/> 
        <property name="url" value="${url}" />  
        <property name="username" value="${username}"/>  
        <property name="password" value="${password}"/>  
        <!-- 配置初始化大小、最小、最大 -->  
        <property name="initialSize"><value>1</value></property>  
        <property name="maxActive"><value>5</value></property>  
        <property name="minIdle"><value>1</value></property>  
        <!-- 配置获取连接等待超时的时间 -->  
        <property name="maxWait"><value>60000</value></property>
    </bean>  
      
    <!-- mybatis配置 -->  
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
        <property name="dataSource" ref="dataSource" />  
    </bean>   
</beans>

springMybatis-servlet.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: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.xsd  
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd  
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">  
      
        <!-- 启用spring mvc 注解-->  
    <mvc:annotation-driven />    
      
    <!-- 自动扫描的包名 ，使Spring支持自动检测组件，如注解的Controller-->  
    <context:component-scan base-package="com.chinasofti.controller,com.chinasofti.service" />
      
    <!-- 设置静态资源的路径，这些路径将不会被前端控制器所接收 -->
	<mvc:resources location="/resources/" mapping="/resources/**"></mvc:resources>
     
    <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">    
		<!-- 支持视图中使用jstl -->
	    <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
        <property name="prefix" value="/WEB-INF/jsp/" />    
        <property name="suffix" value=".jsp" />
    </bean>  
</beans>

web.xml——配置spring

<?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>SSM</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>
	<context-param>  
        <param-name>contextConfigLocation</param-name>  
        <param-value>/WEB-INF/spring-*.xml</param-value>  
    </context-param>
	<listener>  
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>  
    </listener>
	<filter>  
        <filter-name>encodingFilter</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>  
        <init-param>  
            <param-name>forceEncoding</param-name>  
            <param-value>true</param-value>  
        </init-param>  
    </filter>  
    <filter-mapping>  
        <filter-name>encodingFilter</filter-name>  
        <url-pattern>/*</url-pattern>  
    </filter-mapping>
	<servlet>  
        <servlet-name>springMybatis</servlet-name>  
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>  
        <load-on-startup>1</load-on-startup>  
    </servlet>  
    <servlet-mapping>  
        <servlet-name>springMybatis</servlet-name>  
        <!-- 所有的的请求，都会被DispatcherServlet处理 -->  
        <url-pattern>/</url-pattern>  
    </servlet-mapping> 
</web-app>

数据库

jdbc.properties文件

driverClassName=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@127.0.0.1:1521:first
username=system
password=123456

controller:

UserController.java

package com.chinasofti.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import com.chinasofti.model.Login;
import com.chinasofti.service.UserService;

@Controller
public class UserController {
	
	@Autowired
	private UserService userService;
	
	@RequestMapping(value="/login",method=RequestMethod.GET)
	public String login() {
		return "login";
	}
	
	@RequestMapping(value="/login",method=RequestMethod.POST)
	public String toLogin(Login login) {
		Login l = userService.login(login);
		if(l==null || l.getId()==0) {
			return "login";
		}
		return "ok";
	}
	
	
}

mapper

UserMapper.java

package com.chinasofti.mapper;

import com.chinasofti.model.Login;

public interface UserMapper {
	public Login login(Login login);
}

UserMapper.xml

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.chinasofti.mapper.UserMapper">
	<select id="login" parameterType="com.chinasofti.model.Login" resultType="com.chinasofti.model.Login">
		select * from login where username=#{username} and password=#{password}
	</select>
</mapper>

model

Login.java

package com.chinasofti.model;

public class Login {
	private int id;
	private String username;
	private String password;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	
	
}

service

UserService.java

package com.chinasofti.service;

import com.chinasofti.model.Login;

public interface UserService {
	public Login login(Login login);
}

serviceImpl

UserServiceImpl.java

package com.chinasofti.service.impl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.chinasofti.mapper.UserMapper;
import com.chinasofti.model.Login;
import com.chinasofti.service.UserService;

@Service
public class UserServiceImpl implements UserService{

	@Autowired
	private UserMapper userMapper;
	
	@Override
	public Login login(Login login) {
		return userMapper.login(login);
	}

}

JSP

login.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
	<form action="login" method="post">
		<input type="text" name="username">
		<input type="password" name="password">
		<button>登录</button>
	</form>
</body>
</html>

ok.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
登录成功
</body>
</html>