Spingmvc的部分代码

// 获取数据库里面的数据并显示到前端页面中去 DB
public CountTabledao getdata() throws SQLException {
ResultSet rs = null;
Statement statement = null;
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection connection = DriverManager.getConnection("jdbc:mysql://10.0.30.171:3306/ifengqa", "root", "123456");
String sql = "select * from projectlisttable ";
statement = connection.createStatement();
rs = statement.executeQuery(sql);
while (rs.next()) {
int id = rs.getInt("Id");
user.setId(id);
String name = rs.getString("name");
user.setName(name);
String belong = rs.getString("belong");
user.setBelong(belong);
String type = rs.getString("type");
user.setType(type);
String starttime = rs.getString("starttime");
user.setStarttime(starttime);
String submittime = rs.getString("submittime");
user.setSubmittime(submittime);
String checktime = rs.getString("checktime");
user.setChecktime(checktime);
String onlinetime = rs.getString("onlinetime");
user.setOnlinetime(onlinetime);
String currentprogress = rs.getString("currentprogress");
user.setCurrentprogress(currentprogress);
String pm = rs.getString("PM");
user.setPM(pm);
String rd = rs.getString("RD");
user.setRD(rd);
String qa = rs.getString("QA");
user.setQA(qa);
int bug = rs.getInt("bug");
user.setBug(bug);
int onlinebug = rs.getInt("onlinebug");
user.setOnlinebug(onlinebug);
System.out.println(user.getBelong());
System.out.println(user.getType());
System.out.println(user.getBug());
}
return user;
}<tbody>
<tr>
View层
<td><%=dbUtildao.getdata().getId()%></td>
<td><%=dbUtildao.getdata().getName()%></td>
<td><%=dbUtildao.getdata().getBelong()%></td>
<td><%=dbUtildao.getdata().getType()%></td>
<td><%=dbUtildao.getdata().getStarttime()%></td>
<td><%=dbUtildao.getdata().getId()%></td>
<td><%=dbUtildao.getdata().getId()%></td>
<td><%=dbUtildao.getdata().getId()%></td>
<td><%=dbUtildao.getdata().getId()%></td>
<td><%=dbUtildao.getdata().getId()%></td>
<td><%=dbUtildao.getdata().getId()%></td>
<td><%=dbUtildao.getdata().getId()%></td>
<td><%=dbUtildao.getdata().getId()%></td> 
      <td><%=dbUtildao.getdata().getId()%></td>
<td><a href="edlist.html?id=<%=dbUtildao.getdata().getId()%>">编辑</a>
<a href="deldata.html?id=<%=dbUtildao.getdata().getId()%>">删除 </a>
</td>
</tr> 

</tbody>

控制层：

@RequestMapping("/")
public class ProjectListController {
@RequestMapping( method = RequestMethod.GET)
public String sayHello(ModelMap model) {
return "table";
}
@RequestMapping(value="/helloagain", method = RequestMethod.GET)
public String sayHelloAgain(ModelMap model) {
model.addAttribute("gre", "Hello World Again, from Spring 4 MVC");
model.addAttribute("info","my name id shixinfa  address jiangxishangraoyugan");
return "welcome";
}
@RequestMapping(value="/QA/UserLogin", method = RequestMethod.GET)
public String login(ModelMap model) {
model.addAttribute("greeting", "Hello World Again, from Spring 4 MVC");
model.addAttribute("user","username shixinfa password 15510225694");
return "welcome";
}
@RequestMapping(value="/addlist.html", method = RequestMethod.GET)
public String addlist(ModelMap model) {
return "addlist";
}
@RequestMapping(value="/addinfo.html", method = RequestMethod.POST)
public String addinfo(ModelMap model) {
return "addinfo";
}
@RequestMapping(value="/table.html", method = RequestMethod.GET)
public String table(ModelMap model) {
return "table";
}
@RequestMapping(value="/index.html", method = RequestMethod.GET)
public String index(ModelMap model) {
return "index";
}
@RequestMapping(value="/edlist.html", method = RequestMethod.POST)
public String edlist(ModelMap model) {
return "edlist";
}
@RequestMapping(value="/e.html", method = RequestMethod.GET)
public String e(ModelMap model) {
return "e";
}
@RequestMapping(value="/deldata.html", method = RequestMethod.GET)
public String del(ModelMap model) {
return "delVip";
}
@RequestMapping(value="/editdata.html", method = RequestMethod.POST)
public String edit(ModelMap model) {
return "delVip";
}
@RequestMapping(value="/alter.html", method = RequestMethod.GET)
public String alter(ModelMap model) {
return "alter";
}

}

springmvc -servlet.xml 文件

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
  http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
  http://www.springframework.org/schema/mvc
  http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
  http://www.springframework.org/schema/context
  http://www.springframework.org/schema/context/spring-context-4.0.xsd">
<context:component-scan base-package="com.ifeng.qa.controller" />
     <mvc:resources mapping="/static/**" location="/static/" />
<mvc:resources mapping="/static/img/**" location="/static/img/" />
<mvc:resources mapping="/static/js/**" location="/static/js/" />
<mvc:annotation-driven/>
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> 
<!-- 前缀 -->
<property name="prefix">
<value>/WEB-INF/views/</value>
</property>
<!-- 后缀 -->
<property name="suffix">
<value>.jsp</value>
</property>
</bean>

</beans>

web.xml 文件

<web-app id="WebApp_ID" version="2.4"
  xmlns="http://java.sun.com/xml/ns/j2ee"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
  http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
 <display-name>Ifeng Web Application</display-name>
 <servlet>
  <servlet-name>dispatcher</servlet-name>
  <servlet-class>
  org.springframework.web.servlet.DispatcherServlet
  </servlet-class>
  <init-param>
  <param-name>contextConfigLocation</param-name>
  <param-value>/WEB-INF/spring-servlet.xml</param-value>
 
  </init-param>
  <load-on-startup>1</load-on-startup>
 </servlet>
 <servlet>
  <description>
  </description>
  <display-name>AddListData</display-name>
  <servlet-name>AddListData</servlet-name>
  <servlet-class>AddListData</servlet-class>
 </servlet>
 
 <servlet-mapping>  
   <servlet-name>default</servlet-name>
     <url-pattern>*.css</url-pattern>  
</servlet-mapping>  
<servlet-mapping>  
 <servlet-name>default</servlet-name>
    <url-pattern>*.gif</url-pattern>   
 </servlet-mapping>  
      
 <servlet-mapping>  
  <servlet-name>default</servlet-name>
     <url-pattern>*.jpg</url-pattern>  
 </servlet-mapping>  
      <servlet-mapping>  
       <servlet-name>default</servlet-name>
     <url-pattern>*.png</url-pattern>  
 </servlet-mapping>  
 <servlet-mapping>  
  <servlet-name>default</servlet-name>
     <url-pattern>*.ico</url-pattern>  
 </servlet-mapping>
 <servlet-mapping>  
  <servlet-name>default</servlet-name>
     <url-pattern>*.js</url-pattern>  
 </servlet-mapping>
<servlet-mapping>
        <servlet-name>default</servlet-name>
        <url-pattern>*.woff</url-pattern>
</servlet-mapping>
 <servlet-mapping>
  <servlet-name>dispatcher</servlet-name>
  <url-pattern>/</url-pattern>
 </servlet-mapping>
<servlet>
<servlet-name>Test</servlet-name>
<servlet-class>com.ifeng.qa.dao.DbAction</servlet-class>
</servlet>
  <servlet-mapping>
    <servlet-name>Test</servlet-name>
    <url-pattern>/Ifeng/DbAction</url-pattern>
    </servlet-mapping>
</web-app>