当前位置：Gxlcms > 数据库问题 > 【Spring】SpringMVC+MySQL的配置

【Spring】SpringMVC+MySQL的配置

时间：2021-07-01 10:21:17 帮助过：20人阅读

="utf-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>login</title> </head> <body> <form action="login.do" method="post"> <!-- userName:<input type="text" name="userName"/><br/> passWord:<input type="password" name="userPwd"/><br/> --> <input type="submit" value="查询所有信息"/> </form> </body> </html>

这里也可以配合后面做成用户登录界面。

第二步：配置Web.xml文件

  1. <span style="color: #0000ff;"><?</span><span style="color: #ff00ff;">xml version="1.0" encoding="UTF-8"</span><span style="color: #0000ff;">?></span>
  2. <span style="color: #0000ff;"><</span><span style="color: #800000;">web-app </span><span style="color: #ff0000;">xmlns:xsi</span><span style="color: #0000ff;">="http://www.w3.org/2001/XMLSchema-instance"</span><span style="color: #ff0000;"> xmlns</span><span style="color: #0000ff;">="http://xmlns.jcp.org/xml/ns/javaee"</span><span style="color: #ff0000;"> xsi:schemaLocation</span><span style="color: #0000ff;">="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"</span><span style="color: #ff0000;"> id</span><span style="color: #0000ff;">="WebApp_ID"</span><span style="color: #ff0000;"> version</span><span style="color: #0000ff;">="3.1"</span><span style="color: #0000ff;">></span>
  3.   <span style="color: #0000ff;"><</span><span style="color: #800000;">display-name</span><span style="color: #0000ff;">></span>mydb2<span style="color: #0000ff;"></</span><span style="color: #800000;">display-name</span><span style="color: #0000ff;">></span>
  4.   <span style="color: #0000ff;"><</span><span style="color: #800000;">welcome-file-list</span><span style="color: #0000ff;">></span>
  5.     <span style="color: #0000ff;"><</span><span style="color: #800000;">welcome-file</span><span style="color: #0000ff;">></span>welcome.html<span style="color: #0000ff;"></</span><span style="color: #800000;">welcome-file</span><span style="color: #0000ff;">></span>
  6.   <span style="color: #0000ff;"></</span><span style="color: #800000;">welcome-file-list</span><span style="color: #0000ff;">></span>
  7.   
  8.   <span style="color: #008000;"><!--</span><span style="color: #008000;"> 这里是一个总控制器 </span><span style="color: #008000;">--></span>
  9.   <span style="color: #0000ff;"><</span><span style="color: #800000;">servlet</span><span style="color: #0000ff;">></span>
  10.     <span style="color: #0000ff;"><</span><span style="color: #800000;">servlet-name</span><span style="color: #0000ff;">></span>spring<span style="color: #0000ff;"></</span><span style="color: #800000;">servlet-name</span><span style="color: #0000ff;">></span>
  11.     <span style="color: #0000ff;"><</span><span style="color: #800000;">servlet-class</span><span style="color: #0000ff;">></span>org.springframework.web.servlet.DispatcherServlet<span style="color: #0000ff;"></</span><span style="color: #800000;">servlet-class</span><span style="color: #0000ff;">></span>
  12.   <span style="color: #0000ff;"></</span><span style="color: #800000;">servlet</span><span style="color: #0000ff;">></span>
  13.   <span style="color: #0000ff;"><</span><span style="color: #800000;">servlet-mapping</span><span style="color: #0000ff;">></span>
  14.     <span style="color: #0000ff;"><</span><span style="color: #800000;">servlet-name</span><span style="color: #0000ff;">></span>spring<span style="color: #0000ff;"></</span><span style="color: #800000;">servlet-name</span><span style="color: #0000ff;">></span>
  15.     <span style="color: #0000ff;"><</span><span style="color: #800000;">url-pattern</span><span style="color: #0000ff;">></span>*.do<span style="color: #0000ff;"></</span><span style="color: #800000;">url-pattern</span><span style="color: #0000ff;">></span>
  16.   <span style="color: #0000ff;"></</span><span style="color: #800000;">servlet-mapping</span><span style="color: #0000ff;">></span>
  17.   
  18.   <span style="color: #008000;"><!--</span><span style="color: #008000;"> 解决POST提交乱码问题 </span><span style="color: #008000;">--></span>
  19.   <span style="color: #0000ff;"><</span><span style="color: #800000;">filter</span><span style="color: #0000ff;">></span>
  20.     <span style="color: #0000ff;"><</span><span style="color: #800000;">filter-name</span><span style="color: #0000ff;">></span>EncodingName<span style="color: #0000ff;"></</span><span style="color: #800000;">filter-name</span><span style="color: #0000ff;">></span>
  21.     <span style="color: #0000ff;"><</span><span style="color: #800000;">filter-class</span><span style="color: #0000ff;">></span>org.springframework.web.filter.CharacterEncodingFilter<span style="color: #0000ff;"></</span><span style="color: #800000;">filter-class</span><span style="color: #0000ff;">></span>
  22.     <span style="color: #0000ff;"><</span><span style="color: #800000;">init-param</span><span style="color: #0000ff;">></span>
  23.       <span style="color: #0000ff;"><</span><span style="color: #800000;">param-name</span><span style="color: #0000ff;">></span>encoding<span style="color: #0000ff;"></</span><span style="color: #800000;">param-name</span><span style="color: #0000ff;">></span>
  24.       <span style="color: #0000ff;"><</span><span style="color: #800000;">param-value</span><span style="color: #0000ff;">></span>utf-8<span style="color: #0000ff;"></</span><span style="color: #800000;">param-value</span><span style="color: #0000ff;">></span>
  25.     <span style="color: #0000ff;"></</span><span style="color: #800000;">init-param</span><span style="color: #0000ff;">></span>
  26.   <span style="color: #0000ff;"></</span><span style="color: #800000;">filter</span><span style="color: #0000ff;">></span>
  27.   <span style="color: #0000ff;"><</span><span style="color: #800000;">filter-mapping</span><span style="color: #0000ff;">></span>
  28.     <span style="color: #0000ff;"><</span><span style="color: #800000;">filter-name</span><span style="color: #0000ff;">></span>EncodingName<span style="color: #0000ff;"></</span><span style="color: #800000;">filter-name</span><span style="color: #0000ff;">></span>
  29.     <span style="color: #0000ff;"><</span><span style="color: #800000;">url-pattern</span><span style="color: #0000ff;">></span>/*<span style="color: #0000ff;"></</span><span style="color: #800000;">url-pattern</span><span style="color: #0000ff;">></span>
  30.   <span style="color: #0000ff;"></</span><span style="color: #800000;">filter-mapping</span><span style="color: #0000ff;">></span>
  31.   
  32. <span style="color: #0000ff;"></</span><span style="color: #800000;">web-app</span><span style="color: #0000ff;">></span>

第三步：配置dispatcher文件

spring-servlet.xml

  1. <span style="color: #0000ff;"><?</span><span style="color: #ff00ff;">xml version="1.0" encoding="UTF-8"</span><span style="color: #0000ff;">?></span>
  2. <span style="color: #0000ff;"><</span><span style="color: #800000;">beans </span><span style="color: #ff0000;">xmlns</span><span style="color: #0000ff;">="http://www.springframework.org/schema/beans"</span><span style="color: #ff0000;">
  3.     xmlns:xsi</span><span style="color: #0000ff;">="http://www.w3.org/2001/XMLSchema-instance"</span><span style="color: #ff0000;">
  4.     xsi:schemaLocation</span><span style="color: #0000ff;">="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd"</span><span style="color: #0000ff;">></span>
  5.   <span style="color: #008000;"><!--</span><span style="color: #008000;"> 获取配置文件 </span><span style="color: #008000;">--></span>
  6.   <span style="color: #0000ff;"><</span><span style="color: #800000;">bean </span><span style="color: #ff0000;">id</span><span style="color: #0000ff;">="config"</span><span style="color: #ff0000;"> class</span><span style="color: #0000ff;">="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"</span><span style="color: #0000ff;">></span>
  7.     <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="locations"</span><span style="color: #0000ff;">></span>
  8.       <span style="color: #0000ff;"><</span><span style="color: #800000;">list</span><span style="color: #0000ff;">></span>
  9.         <span style="color: #0000ff;"><</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>classpath:db-config.properties<span style="color: #0000ff;"></</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>
  10.       <span style="color: #0000ff;"></</span><span style="color: #800000;">list</span><span style="color: #0000ff;">></span>
  11.   <span style="color: #0000ff;"></</span><span style="color: #800000;">property</span><span style="color: #0000ff;">></span>
  12.   <span style="color: #0000ff;"></</span><span style="color: #800000;">bean</span><span style="color: #0000ff;">></span>
  13.  
  14.   <span style="color: #008000;"><!--</span><span style="color: #008000;"> 获取数据源 </span><span style="color: #008000;">--></span>
  15.   <span style="color: #0000ff;"><</span><span style="color: #800000;">bean </span><span style="color: #ff0000;">id</span><span style="color: #0000ff;">="dataSource"</span><span style="color: #ff0000;"> class</span><span style="color: #0000ff;">="org.apache.commons.dbcp.BasicDataSource"</span><span style="color: #0000ff;">></span>
  16.     <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="driverClassName"</span><span style="color: #0000ff;">></span>
  17.       <span style="color: #0000ff;"><</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>${db.dirverClass}<span style="color: #0000ff;"></</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>
  18.     <span style="color: #0000ff;"></</span><span style="color: #800000;">property</span><span style="color: #0000ff;">></span>
  19.     <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="url"</span><span style="color: #0000ff;">></span>
  20.       <span style="color: #0000ff;"><</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>${db.url}<span style="color: #0000ff;"></</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>
  21.     <span style="color: #0000ff;"></</span><span style="color: #800000;">property</span><span style="color: #0000ff;">></span>
  22.     <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="username"</span><span style="color: #0000ff;">></span>
  23.       <span style="color: #0000ff;"><</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>${db.username}<span style="color: #0000ff;"></</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>
  24.     <span style="color: #0000ff;"></</span><span style="color: #800000;">property</span><span style="color: #0000ff;">></span>
  25.     <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="password"</span><span style="color: #0000ff;">></span>
  26.       <span style="color: #0000ff;"><</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>${db.password}<span style="color: #0000ff;"></</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>
  27.     <span style="color: #0000ff;"></</span><span style="color: #800000;">property</span><span style="color: #0000ff;">></span>
  28.   <span style="color: #0000ff;"></</span><span style="color: #800000;">bean</span><span style="color: #0000ff;">></span>
  29.     
  30.   <span style="color: #008000;"><!--</span><span style="color: #008000;"> 
  31.         给jdbc模板注入数据源
  32.        在JdbcTemplate里有一个对应的私有属性dataSource
  33.   </span><span style="color: #008000;">--></span>
  34.   <span style="color: #0000ff;"><</span><span style="color: #800000;">bean </span><span style="color: #ff0000;">id</span><span style="color: #0000ff;">="jdbcTemplate"</span><span style="color: #ff0000;"> class</span><span style="color: #0000ff;">="org.springframework.jdbc.core.JdbcTemplate"</span><span style="color: #0000ff;">></span>
  35.     <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="dataSource"</span><span style="color: #ff0000;"> ref</span><span style="color: #0000ff;">="dataSource"</span><span style="color: #0000ff;">></</span><span style="color: #800000;">property</span><span style="color: #0000ff;">></span>
  36.   <span style="color: #0000ff;"></</span><span style="color: #800000;">bean</span><span style="color: #0000ff;">></span>
  37.     
  38.   <span style="color: #008000;"><!--</span><span style="color: #008000;"> 
  39.          给userDao注入模板
  40.         在com.spring.db.UserDao里应该设有一个JdbcTemplate jdbcTemplate的私有属性，并且setter
  41.   </span><span style="color: #008000;">--></span>
  42.   <span style="color: #0000ff;"><</span><span style="color: #800000;">bean </span><span style="color: #ff0000;">id</span><span style="color: #0000ff;">="userDao"</span><span style="color: #ff0000;"> class</span><span style="color: #0000ff;">="com.spring.db.UserDao"</span><span style="color: #0000ff;">></span>
  43.     <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="jdbcTemplate"</span><span style="color: #ff0000;"> ref</span><span style="color: #0000ff;">="jdbcTemplate"</span><span style="color: #0000ff;">></</span><span style="color: #800000;">property</span><span style="color: #0000ff;">></span>
  44.   <span style="color: #0000ff;"></</span><span style="color: #800000;">bean</span><span style="color: #0000ff;">></span>
  45.     
  46.   <span style="color: #008000;"><!--</span><span style="color: #008000;"> 
  47.          给控制器注入dao类
  48.         在com.spring.controller.LoginController里应该设有一个UserDao userDao的私有属性，并且setter
  49.   </span><span style="color: #008000;">--></span>
  50.   <span style="color: #0000ff;"><</span><span style="color: #800000;">bean </span><span style="color: #ff0000;">id</span><span style="color: #0000ff;">="LoginController"</span><span style="color: #ff0000;"> class</span><span style="color: #0000ff;">="com.spring.controller.LoginController"</span><span style="color: #0000ff;">></span>
  51.     <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="userDao"</span><span style="color: #ff0000;"> ref</span><span style="color: #0000ff;">="userDao"</span><span style="color: #0000ff;">></</span><span style="color: #800000;">property</span><span style="color: #0000ff;">></span>
  52.   <span style="color: #0000ff;"></</span><span style="color: #800000;">bean</span><span style="color: #0000ff;">></span>
  53.     
  54.   <span style="color: #008000;"><!--</span><span style="color: #008000;"> 配置映射响应器，映射响应器会根据请求文件来决定进入到哪个控制器，</span><span style="color: #008000;">--></span>
  55.   <span style="color: #0000ff;"><</span><span style="color: #800000;">bean </span><span style="color: #ff0000;">id</span><span style="color: #0000ff;">="mapping"</span><span style="color: #ff0000;"> class</span><span style="color: #0000ff;">="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping"</span><span style="color: #0000ff;">></span>
  56.     <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="mappings"</span><span style="color: #0000ff;">></span>
  57.       <span style="color: #0000ff;"><</span><span style="color: #800000;">props</span><span style="color: #0000ff;">></span>
  58.         <span style="color: #008000;"><!--</span><span style="color: #008000;"> 这里的key就是你的action请求。后面的是要分派的控制器，控制器和是id对应的。</span><span style="color: #008000;">--></span>
  59.         <span style="color: #0000ff;"><</span><span style="color: #800000;">prop </span><span style="color: #ff0000;">key</span><span style="color: #0000ff;">="login.do"</span><span style="color: #0000ff;">></span>LoginController<span style="color: #0000ff;"></</span><span style="color: #800000;">prop</span><span style="color: #0000ff;">></span>
  60.       <span style="color: #0000ff;"></</span><span style="color: #800000;">props</span><span style="color: #0000ff;">></span>
  61.     <span style="color: #0000ff;"></</span><span style="color: #800000;">property</span><span style="color: #0000ff;">></span>
  62.   <span style="color: #0000ff;"></</span><span style="color: #800000;">bean</span><span style="color: #0000ff;">></span>
  63.   <span style="color: #008000;"><!--</span><span style="color: #008000;">定义视图 通过internalResourceView来表示 使用的是Servlet/jsp技术</span><span style="color: #008000;">--></span>
  64.   <span style="color: #0000ff;"><</span><span style="color: #800000;">bean </span><span style="color: #ff0000;">id</span><span style="color: #0000ff;">="viewResolver"</span><span style="color: #ff0000;">    class</span><span style="color: #0000ff;">="org.springframework.web.servlet.view.InternalResourceViewResolver"</span><span style="color: #0000ff;">></span>
  65.     <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="viewClass"</span><span style="color: #0000ff;">></span>
  66.       <span style="color: #0000ff;"><</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>org.springframework.web.servlet.view.InternalResourceView<span style="color: #0000ff;"></</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>
  67.     <span style="color: #0000ff;"></</span><span style="color: #800000;">property</span><span style="color: #0000ff;">></span>
  68.     <span style="color: #008000;"><!--</span><span style="color: #008000;">jsp存放的目录</span><span style="color: #008000;">--></span>
  69.     <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="prefix"</span><span style="color: #0000ff;">></span>
  70.       <span style="color: #0000ff;"><</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>/view/<span style="color: #0000ff;"></</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>
  71.     <span style="color: #0000ff;"></</span><span style="color: #800000;">property</span><span style="color: #0000ff;">></span>
  72.     <span style="color: #008000;"><!--</span><span style="color: #008000;">jsp文件的后缀</span><span style="color: #008000;">--></span>
  73.     <span style="color: #0000ff;"><</span><span style="color: #800000;">property </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="suffix"</span><span style="color: #0000ff;">></span>
  74.       <span style="color: #0000ff;"><</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>.jsp<span style="color: #0000ff;"></</span><span style="color: #800000;">value</span><span style="color: #0000ff;">></span>
  75.     <span style="color: #0000ff;"></</span><span style="color: #800000;">property</span><span style="color: #0000ff;">></span>
  76.   <span style="color: #0000ff;"></</span><span style="color: #800000;">bean</span><span style="color: #0000ff;">></span>
  77. <span style="color: #0000ff;"></</span><span style="color: #800000;">beans</span><span style="color: #0000ff;">></span>

这儿控制MySQL的大致过程为，首先获得数据源，将数据源添加到JDBCTemplate模板，然后再将Jdbc模板添加到UserDao(负责和数据库交换)中，最后将UserDao添加到控制器中。

第四步：建立数据源文件

db-config.properties

  1. db.url=jdbc:mysql:<span style="color: #008000;">//</span><span style="color: #008000;">/test?characterEncoding=utf8&useSSL=true&serverTimezone=GMT</span>
  2. db.username=<span style="color: #000000;">root
  3. db.password</span>=<span style="color: #000000;">2714MySQL@pw
  4. db.dirverClass</span>=com.mysql.cj.jdbc.Driver

第五步：建立Model

UserVO.java

  1. <span style="color: #0000ff;">package</span><span style="color: #000000;"> com.spring.model;
  2. </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> UserVO {
  3.     </span><span style="color: #0000ff;">private</span> <span style="color: #0000ff;">int</span><span style="color: #000000;"> id;
  4.     </span><span style="color: #0000ff;">private</span><span style="color: #000000;"> String name;
  5.     </span><span style="color: #0000ff;">private</span><span style="color: #000000;"> String pwd;
  6.     
  7.     </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">int</span><span style="color: #000000;"> getId() {
  8.         </span><span style="color: #0000ff;">return</span><span style="color: #000000;"> id;
  9.     }
  10.     </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">void</span> setId(<span style="color: #0000ff;">int</span><span style="color: #000000;"> id) {
  11.         </span><span style="color: #0000ff;">this</span>.id =<span style="color: #000000;"> id;
  12.     }
  13.     </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> String getName() {
  14.         </span><span style="color: #0000ff;">return</span><span style="color: #000000;"> name;
  15.     }
  16.     </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> setName(String name) {
  17.         </span><span style="color: #0000ff;">this</span>.name =<span style="color: #000000;"> name;
  18.     }
  19.     </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> String getPwd() {
  20.         </span><span style="color: #0000ff;">return</span><span style="color: #000000;"> pwd;
  21.     }
  22.     </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> setPwd(String pwd) {
  23.         </span><span style="color: #0000ff;">this</span>.pwd =<span style="color: #000000;"> pwd;
  24.     }
  25. }</span>

第六步：建立dao类（和数据库交换），代码为：

  1. <span style="color: #0000ff;">package</span><span style="color: #000000;"> com.spring.db;
  2. </span><span style="color: #0000ff;">import</span><span style="color: #000000;"> java.sql.ResultSet;
  3. </span><span style="color: #0000ff;">import</span><span style="color: #000000;"> java.sql.SQLException;
  4. </span><span style="color: #0000ff;">import</span><span style="color: #000000;"> java.util.List;
  5. </span><span style="color: #0000ff;">import</span><span style="color: #000000;"> org.springframework.jdbc.core.JdbcTemplate;
  6. </span><span style="color: #0000ff;">import</span><span style="color: #000000;"> org.springframework.jdbc.core.RowMapper;
  7. </span><span style="color: #0000ff;">import</span><span style="color: #000000;"> com.spring.model.UserVO;
  8. </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> UserDao {
  9. </span><span style="color: #0000ff;">private</span><span style="color: #000000;"> JdbcTemplate jdbcTemplate;
  10.     
  11. </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> JdbcTemplate getJdbcTemplate() {
  12.     </span><span style="color: #0000ff;">return</span><span style="color: #000000;"> jdbcTemplate;
  13. }
  14. </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> setJdbcTemplate(JdbcTemplate jdbcTemplate) {
  15.     </span><span style="color: #0000ff;">this</span>.jdbcTemplate =<span style="color: #000000;"> jdbcTemplate;
  16. }
  17.     @SuppressWarnings({ </span>"unchecked", "rawtypes"<span style="color: #000000;"> })
  18.     </span><span style="color: #0000ff;">public</span> List<UserVO><span style="color: #000000;"> find(){
  19.         String sql</span>="select * from userbo";<span style="color: #008000;">//</span><span style="color: #008000;">这里也可以添加查询限制条件</span>
  20.         <span style="color: #0000ff;">return</span> jdbcTemplate.query(sql, <span style="color: #0000ff;">new</span><span style="color: #000000;"> RowMapper(){
  21.             </span><span style="color: #0000ff;">public</span> Object mapRow(ResultSet rs, <span style="color: #0000ff;">int</span> num) <span style="color: #0000ff;">throws</span><span style="color: #000000;"> SQLException {
  22.                 UserVO uservo</span>=<span style="color: #0000ff;">new</span><span style="color: #000000;"> UserVO();
  23.                 uservo.setId(rs.getInt(</span>"USERID"<span style="color: #000000;">));
  24.                 uservo.setName(rs.getString(</span>"USERNAME"<span style="color: #000000;">));
  25.                 uservo.setPwd(rs.getString(</span>"USERPSW"<span style="color: #000000;">));
  26.                 </span><span style="color: #0000ff;">return</span><span style="color: #000000;"> uservo;
  27.             }
  28.         });
  29.     }
  30. }</span>

第七步：建立控制器：

LoginController.java

  1. <span style="color: #0000ff;">package</span><span style="color: #000000;"> com.spring.controller;
  2. </span><span style="color: #0000ff;">import</span><span style="color: #000000;"> java.util.HashMap;
  3. </span><span style="color: #0000ff;">import</span><span style="color: #000000;"> java.util.List;
  4. </span><span style="color: #0000ff;">import</span><span style="color: #000000;"> java.util.Map;
  5. </span><span style="color: #0000ff;">import</span><span style="color: #000000;"> javax.servlet.http.HttpServletRequest;
  6. </span><span style="color: #0000ff;">import</span><span style="color: #000000;"> javax.servlet.http.HttpServletResponse;
  7. </span><span style="color: #0000ff;">import</span><span style="color: #000000;"> org.springframework.web.servlet.ModelAndView;
  8. </span><span style="color: #0000ff;">import</span><span style="color: #000000;"> org.springframework.web.servlet.mvc.Controller;
  9. </span><span style="color: #0000ff;">import</span><span style="color: #000000;"> com.spring.db.UserDao;
  10. </span><span style="color: #0000ff;">import</span><span style="color: #000000;"> com.spring.model.UserVO;
  11. </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">class</span> LoginController <span style="color: #0000ff;">implements</span><span style="color: #000000;"> Controller {
  12.     </span><span style="color: #0000ff;">private</span><span style="color: #000000;"> UserDao userDao;
  13.     @SuppressWarnings(</span>"unchecked"<span style="color: #000000;">)
  14.     </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> ModelAndView handleRequest(HttpServletRequest request,
  15.             HttpServletResponse response) </span><span style="color: #0000ff;">throws</span><span style="color: #000000;"> Exception {
  16.         
  17. </span><span style="color: #008000;">//</span><span style="color: #008000;">        String name = request.getParameter("userName");
  18. </span><span style="color: #008000;">//</span><span style="color: #008000;">        String psw = request.getParameter("userPwd");</span>
  19. <span style="color: #000000;">        
  20.         @SuppressWarnings(</span>"rawtypes"<span style="color: #000000;">)
  21.         Map model</span>=<span style="color: #0000ff;">new</span><span style="color: #000000;"> HashMap();
  22.         
  23.         List</span><UserVO> userVO=<span style="color: #000000;">userDao.find();
  24.         model.put(</span>"uservo"<span style="color: #000000;">, userVO);
  25.         
  26.         </span><span style="color: #0000ff;">return</span> <span style="color: #0000ff;">new</span> ModelAndView("userInfo"<span style="color: #000000;">,model);
  27.     }
  28.     </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> setUserDao(UserDao userDao) {
  29.         </span><span style="color: #0000ff;">this</span>.userDao =<span style="color: #000000;"> userDao;
  30.     }
  31.     </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> UserDao getUserDao() {
  32.         </span><span style="color: #0000ff;">return</span><span style="color: #000000;"> userDao;
  33.     }
  34. }</span>

第八步：视图界面代码

  1. <%@ page language="java" <span style="color: #0000ff;">import</span>="java.util.*" pageEncoding="utf-8"%>
  2. <%@page <span style="color: #0000ff;">import</span>="com.spring.model.UserVO"%>
  3. <%<span style="color: #000000;">
  4. @SuppressWarnings(</span>"unchecked"<span style="color: #000000;">)
  5. </span><span style="color: #008000;">/*</span><span style="color: #008000;">
  6. *这儿是合法的，根据com.spring.db.controller.LoginController中handleRequest的返回数据类型进行设置的。
  7. </span><span style="color: #008000;">*/</span><span style="color: #000000;">
  8. List</span><UserVO> str= (List<UserVO>)request.getAttribute("uservo"<span style="color: #000000;">);
  9. </span>%>
  10. <html>
  11.   <head>
  12.     <title>result</title>
  13.   </head>
  14.   
  15.   <body>
  16.   <table border="1">
  17.           <tr>
  18.             <td >编号</td>
  19.             <td >姓名</td>
  20.             <td >年龄</td>
  21.         </tr>
  22.    <%
  23.            <span style="color: #0000ff;">for</span><span style="color: #000000;">(UserVO user:str){
  24.                </span>%>
  25.                    <tr>
  26.                        <td><%=user.getId() %></td>
  27.                        <td><%=user.getName() %></td>
  28.                        <td><%=user.getPwd() %></td>
  29.                    </tr>
  30.                <%<span style="color: #000000;">
  31.            }
  32.     </span>%>
  33.     </table>
  34.   </body>
  35. </html>

数据库信息

  1. mysql> select *<span style="color: #000000;"> From userbo;
  2. </span>+-----------+---------------+--------------+
  3. | USERID    | USERNAME      | USERPSW      |
  4. +-----------+---------------+--------------+
  5. | 1         | 李晓红         | 123456789    |
  6. | 2         | 刘梦雨         | 1234         |
  7. | 3         | 刘姐           | 134567       |
  8. +-----------+---------------+--------------+

参考原文：

java spring mvc+mysql 整合写的一个简单的登录

【Spring】SpringMVC+MySQL的配置

标签：utf-8   let   1.0   orm   html   attribute   factor   年龄   string   

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！