spring_mvc_jdbc入门程序步骤

一，导包建立依赖。

二.配置xml文件。

配置springmvc-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:mvc="http://www.springframework.org/schema/mvc"
    xmlns:p="http://www.springframework.org/schema/p"
    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://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">
        
	<context:component-scan base-package="com.offcn.controller"/>
    <mvc:annotation-driven/>

	<!-- 完成视图的对应 -->
	<!-- 对转向页面的路径解析。prefix：前缀， suffix：后缀 -->
	<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver" >
		<property name="prefix" value="/WEB-INF/jsp/"/>
		<property name="suffix" value=".jsp"/>
	</bean>

</beans>

配置applicationContext-jdbc.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:aop="http://www.springframework.org/schema/aop"  
        xmlns:p="http://www.springframework.org/schema/p"  

        xmlns:context="http://www.springframework.org/schema/context"  
        xsi:schemaLocation="   
            http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd   
            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd   

            http://www.springframework.org/schema/context 
            http://www.springframework.org/schema/context/spring-context.xsd">  
    <!--
    	使spring扫描包下的所有类，让标注spring注解的类生效 

    -->
    <context:component-scan base-package="com.offcn.service"/>
    <context:component-scan base-package="com.offcn.dao"/>
</beans>

以上文件都在src以下。
在WEB-INF下配置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">
    <!--加载所有的spring xml文件-->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext-*.xml</param-value>
    </context-param>
<!--配置springmvc的servlet-->
    <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:springmvc-servlet.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>
<!--监听初始化操作-->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>

</web-app>

三，创建相应包。

在c3p0中配置相应数据库。

四.导入工具类文件。

五.创建pojo，dao与service。以登录界面为例

dao与dao.impl

public interface UserDao {
     public User selectByName(String uname);

//impl
//注意注解
@Repository("userDao")
public class UserDaoImpl implements UserDao {

    @Override
    public User selectByName(String uname) {
       User user= (User) BaseDao.executeQuery ("SELECT * FROM user WHERE uname= ? ",
                new Object[]{uname},
                new BeanResultHandler (User.class));
        return user;
    }

service与service.impl

public interface UserService {
   public User selectByName(String uname,String pwd);

//impl
@Service("userService")
public class UserServiceImpl  implements UserService {
    @Resource
    private UserDao userDao;

    @Override
    public User selectByName(String uname,String upwd) {
        User user = userDao.selectByName (uname);
        if(user.getUpwd ().equals (upwd)){
            return  user;
        }
        return null;
    }

六. controller类与jsp。

@Controller
@RequestMapping("/userController")
public class UserController {
  /*   /WEB-INF/jsp/error.jsp*/

    @Resource
    private UserService userService;

    @RequestMapping(value = "/login",method = RequestMethod.POST)
    public String login111(@RequestParam(value = "uname",required = false)String uname,
                        @RequestParam(value = "upwd",required = false)String upwd, Model model){
        User user = userService.selectByName (uname, upwd);
        if(user != null){
            model.addAttribute ("user",user);
            /*
            * redirect代表重定向到，forward转发 默认就是转发*/
           return  "welcome";
        }

        return "error";
    }

对应jsp：
welcome.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<h1>欢迎${user.uname}</h1>
</body>
</html>

error.jsp:

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<h1>密码错误</h1>
</body>
</html>

其程序：tomcat部署开启后，在index的jsp 输入与数据库对应的账号与密码。
在controller里进行判断，如账号的uname 返回的user对象其对象的getpasswod不一样就进入error页面，反之核对正确就进入welcome页面。