Springmvc结合Ibatis小案例

package cn.edu.shou.hsh.control;

import java.util.HashMap;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.Controller;

import cn.edu.shou.hsh.DAO.UserDAO;
import cn.edu.shou.hsh.Impl.UserImpl;
import cn.edu.shou.hsh.model.User;

public class HelloWorldController implements Controller {

    private User user;
    private UserDAO userDAO;


    public UserDAO getUserDAO() {
        return userDAO;
    }
    public void setUserDAO(UserDAO userDAO) {
        this.userDAO = userDAO;
    }
    public User getUser() {
        return user;
    }
    public void setUser(User user) {
        this.user = user;
    }
    public ModelAndView handleRequest(HttpServletRequest arg0,HttpServletResponse arg1) throws Exception {

        System.out.println("hsh");
        user.setUsername(arg0.getParameter("username"));
        user.setPassword(arg0.getParameter("password"));
        String address=userDAO.checkUser(user);

        if("error".equals(address)){
            return new ModelAndView("/error");
        }else{
            Map<String,Object> map = new HashMap<String,Object>();
            map.put("用户：", arg0.getParameter("username"));
            map.put("地址：", address);
            return new ModelAndView("/welcome","map",map);
        }



    }



}

package cn.edu.shou.hsh.DAO;

import cn.edu.shou.hsh.model.User;

public interface UserDAO {
    public String checkUser(User user);
}

package cn.edu.shou.hsh.Impl;

import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

import cn.edu.shou.hsh.DAO.UserDAO;
import cn.edu.shou.hsh.model.User;

public class UserImpl implements UserDAO {

    private static SqlMapClient sqlMapClient = null;
    // 读取配置文件
    static {
        try {
            Reader reader = Resources.getResourceAsReader("config/sqlMapConfig.xml");
            sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
            reader.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    public String checkUser(User user) {
        // TODO Auto-generated method stub
        Object u = null;
        System.out.println("hsh:"+user.getUsername());
        try {
            u = sqlMapClient.queryForObject("selectUser",user);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        System.out.println("end search:"+u);
        if (u != null) {
            return u.toString();
        } else
            return "error";

    }

}

package cn.edu.shou.hsh.model;

public class User {

    private int id;
    private String username;
    private String password;
    private String address;
    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;
    }
    public String getAddress() {
        return address;
    }
    public void setAddress(String address) {
        this.address = address;
    }

}

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
    "">
<sqlMap>
    <!-- 通过typeAlias使得我们在下面使用Student实体类的时候不需要写包名 -->
    <typeAlias alias="User" type="cn.edu.shou.hsh.model.User"/>

    <select id="selectUser" parameterClass="User" resultClass="String">
        select address from Admin where username = #username# and password=#password#
    </select>

</sqlMap>

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns=""
 xmlns:context=""
 xmlns:p=""
 xmlns:mvc=""
 xmlns:xsi=""
 xsi:schemaLocation="
      /spring-beans-3.0.xsd

      /spring-context.xsd

      /spring-mvc-3.0.xsd">


    <bean id="User" class="cn.edu.shou.hsh.model.User"></bean>
    <bean id="UserDAO" class="cn.edu.shou.hsh.Impl.UserImpl"></bean>
    <bean name="/hsh/search" class="cn.edu.shou.hsh.control.HelloWorldController">
        <property name="User">
         <ref local="User"/>
        </property>
        <property name="UserDAO">
         <ref local="UserDAO"/>
        </property>
    </bean>

    <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/"></property>
        <property name="suffix" value=".jsp"></property>
    </bean>
 </beans>

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
 "">
<sqlMapConfig>
    <properties resource="config/SqlMapConfigExample.properties" />
    <settings cacheModelsEnabled="true" enhancementEnabled="true"
        lazyLoadingEnabled="true" maxRequests="32" maxSessions="10"
        maxTransactions="5" useStatementNamespaces="false" />
    <transactionManager type="JDBC">
        <dataSource type="SIMPLE">
            <property name="JDBC.Driver" value="${dirver}" />
            <property name="JDBC.ConnectionURL" value="${url}" />
            <property name="JDBC.Username" value="${username}" />
            <property name="JDBC.Password" value="${password}" />
        </dataSource>
    </transactionManager>

    <sqlMap resource="cn/edu/shou/hsh/model/User.xml" />

</sqlMapConfig>

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5"
    xmlns=""
    xmlns:xsi=""
    xsi:schemaLocation="
    /web-app_2_5.xsd">
  <display-name></display-name>
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
  <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*:config/spring-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>
</web-app>

dirver=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://127.0.0.1;DatabaseName=User
username=shou
password=shou

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">

    <title>My JSP 'index.jsp' starting page</title>
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">

    <script type="text/javascript">
        function Check(){
        //alert(document.getElementById("username").value);
            if(document.getElementById("username").value==""){
                document.getElementById("info").innerHTML="请输入用户名!";
                document.getElementById("info").style.color='red';
                document.getElementById("username").focus();
                return false;
            }else if(document.getElementById("password").value=="") {
                document.getElementById("info").innerHTML="请输入密码!";
                document.getElementById("info").style.color='red';
                document.getElementById("password").focus();
                return false;
            }
        }
    </script>
  </head>

  <body>
    <br/>
    <form action="hsh/search" method="post" name="myForm" onsubmit="return Check();">
    <div><div id="info"></div>
        <table border=0>
        <tr><td>用户名：</td><td align="center"><input type="text" name="username" id="username"></td></tr>
        <tr><td>密 &nbsp;码：</td><td align="center"><input type="password" name="password" id="password"><br/></td></tr>
        <tr ><td align="center" colspan="2"><input type="submit" value="提交"></td></tr>
        </table>
    </div>
    </form>
  </body>
</html>

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">

    <title>My JSP 'index.jsp' starting page</title>
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">

  </head>

  <body>
    <br/>
    <h1>查询结果：</h1>
    <div style="color:red;">
        <c:forEach items="${map }" var="m">
        ${m.key } -----> ${m.value }</br>
        </c:forEach>
    </div>
  </body>
</html>