sm1011增删改查+springmvc1012

新建导入jar

pom.xml

junit junit 4.11 test

<!--Spring框架核心库 -->
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-context</artifactId>
  <version>${spring.version}</version>
</dependency>
<!-- aspectJ AOP 织入器 -->
<dependency>
  <groupId>org.aspectj</groupId>
  <artifactId>aspectjweaver</artifactId>
  <version>1.8.9</version>
</dependency>
<!-- Spring Web -->
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-web</artifactId>
  <version>${spring.version}</version>
</dependency>
<!--mybatis-spring适配器 -->
<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis-spring</artifactId>
  <version>1.3.0</version>
</dependency>
<!--Spring java数据库访问包，在本例中主要用于提供数据源 -->
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-jdbc</artifactId>
  <version>${spring.version}</version>
</dependency>
<!--mysql数据库驱动 -->
<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <version>5.1.38</version>
</dependency>
<!--log4j日志包 -->
<dependency>
  <groupId>org.apache.logging.log4j</groupId>
  <artifactId>log4j-core</artifactId>
  <version>2.6.1</version>
</dependency>
<!-- mybatis ORM框架 -->
<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>3.4.1</version>
</dependency>
<!-- JUnit单元测试工具 -->
<dependency>
  <groupId>junit</groupId>
  <artifactId>junit</artifactId>
  <version>4.10</version>
</dependency>
<!--c3p0 连接池 -->
<dependency>
  <groupId>c3p0</groupId>
  <artifactId>c3p0</artifactId>
  <version>0.9.1.2</version>
</dependency>
<!-- jstl -->
<dependency>
  <groupId>javax.servlet</groupId>
  <artifactId>jstl</artifactId>
  <version>1.2</version>
</dependency>

 User 实体类 private int id; private String username; private String password;

IUserDao

package com.zhongruan.dao;

import com.zhongruan.bean.User;

import java.util.List;

public interface IUserDao {
List findAll();
void delete(int id);
void update(User user);
void insert(User user);
}

UserService

package com.zhongruan.service.impl;

import com.zhongruan.bean.User;
import com.zhongruan.dao.IUserDao;
import com.zhongruan.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
@Service
public class UserService implements IUserService {

@Autowired
private IUserDao userDao;
@Override
public List<User> findAll() {
    return userDao.findAll();
}

@Override
public void delete(int id) {
    userDao.delete(id);
}

@Override
public void update(User user) {
    userDao.update(user);
}

@Override
public void insert(User user) {
    userDao.insert(user);
}

}

IUserService

package com.zhongruan.service;

import com.zhongruan.bean.User;

import java.util.List;

public interface IUserService {
List findAll();
void delete(int id);
void update(User user);
void insert(User user);
}

Test

package com.zhongruan.test;

import com.zhongruan.bean.User;
import com.zhongruan.service.IUserService;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.util.List;

public class Test {
public static void main(String[] args) {
ClassPathXmlApplicationContext applicationContext=
new ClassPathXmlApplicationContext(“applicationContext.xml”);
IUserService userService= (IUserService) applicationContext.getBean(“userService”);

    List<User> all=userService.findAll();
    // System.out.println(all);
    //userService.delete(13);

// User user1=new User();
// user1.setId(5);
// user1.setUsername(“555”);
// user1.setPassword(“555”);
// userService.update(user1);
User user=new User();
user.setUsername(“zll”);
user.setPassword(“123”);
userService.insert(user);

}

}

UserMapper1.xml

<?xml version="1.0" encoding="UTF-8"?>

<select id="findAll" resultType="user">
    select *from tb_user;
</select>
<delete id="delete" parameterType="int">
    delete from tb_user where id=#{id};
</delete>
<update id="update" parameterType="user">
   update tb_user set username=#{username},password=#{password} where id=#{id};
</update>

<insert id="insert" parameterType="user">
    insert into tb_user(username, password) values(#{username},#{password});
</insert>

新建

可以让加载速度变快

hello.jsp

Hellocontroller

package com.zhongruan.controller;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

@Controller
public class Hellocontroller {

//通过/hello.do来访问 hello.jsp

@RequestMapping("/hello.do")
public ModelAndView hello(){
    ModelAndView mv=new ModelAndView();
    mv.setViewName("hello.jsp");
    mv.addObject("name","wmsjsw");
    return mv;
}

}