初次接触Java Spring MVC, 正准备选个适合自己的orm用, Hibernate我感觉还是有点复杂, Mybatis一样如此.

这是我最后确定的orm, spring自带的jdbc, 蛮适合我!

先看下我的配置

web.xml

    
      
     
      JavaWebDemo
       
         
      
       index.jsp
        
       
         
      
       contextConfigLocation
          
      
       /WEB-INF/springmvc-servlet.xml
        
       
         
      
       org.springframework.web.context.ContextLoaderListener
        
       
         
      
       springmvc
          
      
       org.springframework.web.servlet.DispatcherServlet
          
            
       
        contextConfigLocation
             
       
        /WEB-INF/springmvc-servlet.xml
           
          
      
       1
        
       
         
      
       springmvc
          
      
       /
        
     
    

springmvc-servlet.xml

依赖的jar包

TestController.java

package com.controllers;import java.sql.ResultSet;import java.sql.SQLException;import java.util.List;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.ResponseBody;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.jdbc.core.RowCallbackHandler;import org.springframework.jdbc.core.RowMapper;import com.common.JsonHelper;import com.entity.UsersEntity;@Controller@RequestMapping(value = "test")public class TestController {	@Autowired	private JdbcTemplate jdbcTemplate;	@ResponseBody	@RequestMapping(value = "/index")	public String Index() {		final UsersEntity users = new UsersEntity();		jdbcTemplate.query("select * from Users", new Object[] {}, new RowCallbackHandler() {			@Override			public void processRow(ResultSet rs) throws SQLException {				users.setID(rs.getInt("id"));				users.setUsername(rs.getString("username"));				users.setPassword(rs.getString("password"));				users.setStatus(rs.getInt(rs.getInt("status")));				users.setIsDelete(rs.getBoolean("isdelete"));			}		});				return JsonHelper.toJson(users);	}	@ResponseBody	@RequestMapping(value = "list")	public String List() {		String sql = "select id,username,password,status,isdelete from Users";		List
    
      list = jdbcTemplate.query(sql, new Object[] { }, new RowMapper
     
      () {			@Override			public UsersEntity mapRow(ResultSet rs, int arg1) throws SQLException {				UsersEntity users = new UsersEntity();				users.setID(rs.getInt("id"));				users.setUsername(rs.getString("username"));				users.setPassword(rs.getString("password"));				users.setStatus(rs.getInt(rs.getInt("status")));				users.setIsDelete(rs.getBoolean("isdelete"));				return users;			}		});		return JsonHelper.toJson(list);	}		@ResponseBody	@RequestMapping(value = "/update")	public String Update() {		String sqlStr = "insert into users(username,password,status,isdelete) values(?,?,?,?)";		Object[] params = new Object[] { "test", "test", 1, 0};		return jdbcTemplate.update(sqlStr, params) + "";	}}
     
    

src下的主要架构

WebContent的主要目录