SpringMVC

1.springmvc的配置文件和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:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        https://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/mvc
        https://www.springframework.org/schema/mvc/spring-mvc.xsd
        http://www.springframework.org/schema/context
        https://www.springframework.org/schema/context/spring-context.xsd">
<!--开启注解扫描 -->
    <context:component-scan base-package="com.leisong"></context:component-scan>
    <!-- 视图解析器对象-->
    <bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/"/>
        <property name="suffix" value=".jsp"/>
    </bean>
    <!--开启springmvc框架的注解支持-->
    <mvc:annotation-driven/>
    <!-- 全局异常 -->
    <bean class="org.springframework.web.servlet.handler.SimpleMappingExceptionResolver">
        <property name="exceptionMappings">
            <props>
                <prop key="java.lang.RuntimeException">
                    error
                </prop>
            </props>
        </property>
    </bean>

</beans>

<?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:p="http://www.springframework.org/schema/p"
	xsi:schemaLocation="http://www.springframework.org/schema/beans
	http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
	http://www.springframework.org/schema/context
	http://www.springframework.org/schema/context/spring-context-3.2.xsd
	http://www.springframework.org/schema/aop
	http://www.springframework.org/schema/aop/spring-aop-3.2.xsd">

	<!-- 配置数据访问层和业务逻辑层包的扫描 -->
	<context:component-scan base-package="com.leisong.dao.impl"></context:component-scan>
	<context:component-scan base-package="com.leisong.dao.impl"></context:component-scan>
 
</beans>

2.数据访问层

public interface UserDao {

	public User getLoginUser(String userCode, String password)throws Exception;
}




@Repository
public class UserDaoImpl implements UserDao {

	Connection conn=null;
	Statement st=null;
	ResultSet rs=null;
	
	@Override
	public User getLoginUser(String userCode, String password)throws Exception {
		User user=null;
		conn= DbConn.getConnection();
		String sql="select * from smbms_user where userCode='"+userCode+"' and userPassword='"+password+"'";
		System.out.println(sql);
		try {
			st=conn.createStatement();
			rs=st.executeQuery(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		if(rs!=null){
			while (rs.next()){
				user=new User();
				user.setUserName(rs.getString("userName"));
			}
		}
		
		DbConn.close(rs, st, conn);
		return user;
	}

}

3.业务逻辑层

public interface UserService {
	public User findUser(String userCode, String password);
}



import javax.annotation.Resource;

import com.leisong.dao.UserDao;
import com.leisong.domain.User;
import com.leisong.service.UserService;
import org.springframework.stereotype.Service;


@Service
public class UserServiceImpl implements UserService {

	@Resource
	private UserDao userdao;
	public UserDao getUserdao() {
		return userdao;
	}
	public void setUserdao(UserDao userdao) {
		this.userdao = userdao;
	}
	@Override
	public User findUser(String userCode, String password) {
		User user=null;
		try {
			user= userdao.getLoginUser(userCode, password);
		} catch (Exception e) {
			e.printStackTrace();
		}
	
		return user;
	}

}

4.控制器

package com.leisong.controller;



import com.leisong.domain.User;
import com.leisong.service.UserService;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import java.util.HashMap;
import java.util.Map;

@Controller
@RequestMapping("/user")
public class UserController {

    @Resource
    UserService us=null;
    //定义一个欢迎的方法
    @RequestMapping("/welcome")
    public String welcome(String userName){
        System.out.println("欢迎访问"+userName+"登录医疗管理系统...");
        return "users";  //逻辑视图
    }

    //修改用户
    @RequestMapping("/updateUsers")
    public String updateUsers(@RequestParam(value="userNo",required=true,defaultValue="001")String userNumber){
        System.out.println("修改"+userNumber+"成功...");
        //调用业务逻辑层

        //调用数据访问层

        return "updateok"; //逻辑视图
    }

    //查询数据库所有的用户
    /**
     * @param userName
     * @return
     */
    @RequestMapping(value="/findAll")
    public ModelAndView findAll(String userName){
        System.out.println("传递进来的用户名"+userName);
        //创建ModelAndView对象
        ModelAndView mav=new ModelAndView();
        Map map=new HashMap();
        map.put("username", "库里");
        map.put("password", "123456");

        mav.addAllObjects(map);
        mav.addObject("uname","欧文");
        return mav;
    }

    //登录
    @RequestMapping(value="/login.html",method=RequestMethod.POST)
    public String dologin(String username,String password,HttpServletRequest request,HttpSession session){
        //调用业务逻辑层
        User user=us.findUser(username, password);

        if(user==null){
			/*request.setAttribute("errors", "用户名密码不正确");
			return "login";*/
            throw new RuntimeException("用户名密码不正确....");
        }else{
            System.out.println("控制器user用户的值："+user.getUserName()+user.getUserPassword());
            session.setAttribute("currentUser", user);
            //return "main";
            return "redirect:/user/main.html";
        }

    }

    //定义跳转到主页面的处理器
    @RequestMapping(value="/main.html")
    public String doMain(){
        return "main";
    }


}