ssm增删改查 oracle,ssm简单增删改查案例

此文章仅供新手参考或老手温习

一、创建maven web项目，这里就不多讲了.

二、添加pom文件信息

4.3.10.RELEASE

2.6

1.2

3.4.5

1.3.1

5.1.10

1.0.14

1.2.17

1.2

2.2

3.1.0

1.8.13

org.springframework

spring-core

${spring.version}

org.springframework

spring-beans

${spring.version}

org.springframework

spring-context

${spring.version}

org.springframework

spring-web

${spring.version}

org.springframework

spring-webmvc

${spring.version}

org.springframework

spring-tx

${spring.version}

org.springframework

spring-jdbc

${spring.version}

org.springframework

spring-expression

${spring.version}

commons-lang

commons-lang

${commons-lang.version}

commons-logging

commons-logging

${commons-logging.version}

org.mybatis

mybatis

${mybatis.version}

org.mybatis

mybatis-spring

${mybatis-spring.version}

mysql

mysql-connector-java

${mysql.version}

com.alibaba

druid

${druid.version}

log4j

log4j

${log4j.vresion}

jstl

jstl

${jstl.version}

javax.servlet.jsp

jsp-api

${jsp-api.version}

javax.servlet

javax.servlet-api

${servlet-api.version}

org.aspectj

aspectjweaver

${aspectjweaver.version}

org.apache.maven.plugins

maven-resources-plugin

2.5

三、添加web.xml文件信息

encodingFilter

org.springframework.web.filter.CharacterEncodingFilter

encoding

UTF-8

forceEncoding

true

encodingFilter

/*

contextConfigLocation

classpath:spring/spring-*.xml

org.springframework.web.context.ContextLoaderListener

springDispatcherServlet

org.springframework.web.servlet.DispatcherServlet

contextConfigLocation

classpath:spring/springmvc.xml

1

springDispatcherServlet

/

四、springmvc.xml

五、spring-dao.xml

六、spring-service.xml

七、database.properties

jdbc.driverClassName=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8

jdbc.username=root

jdbc.password=root

八、Java代码部分

1.PageController

@Controller

public class PageController {

@RequestMapping("/")

public String index() {

return "index";

}

}

2.UserController

@Controller

@RequestMapping("/users")

public class UsersController {

@Autowired

private UserService userServie;

@RequestMapping("/toAddUser")

public String toAddUser() {

return "addUser";

}

@RequestMapping("/toUpdateUser/{uid}")

public String toUpdateUser(@PathVariable("uid")Integer uid,Mapmap) {

if(uid != null) {

try {

Users users = userServie.findOne(uid);

map.put("user", users);

} catch (Exception e) {

e.printStackTrace();

}

}

return "updateUser";

}

@RequestMapping("/userinfo")

public String user(Mapmap) {

ListfindAll = userServie.findAll();

map.put("userList", findAll);

return "userinfo";

}

@RequestMapping("/addUser")

@ResponseBody

public String addUser(Users users) {

if(users != null) {

try {

userServie.addUsers(users);

return "success";

} catch (Exception e) {

e.printStackTrace();

return "error";

}

}else {

return "not null";

}

}

@RequestMapping("/updateUser")

@ResponseBody

public String updateUser(Users users) {

if(users != null) {

try {

userServie.updateUsers(users);

return "success";

} catch (Exception e) {

e.printStackTrace();

return "error";

}

}else {

return "not null";

}

}

@RequestMapping("/deleteUser/{uid}")

@ResponseBody

public String deleteUser(@PathVariable("uid")Integer uid) {

if(uid != null) {

try {

userServie.deleteUsers(uid);

return "success";

} catch (Exception e) {

e.printStackTrace();

return "error";

}

}else {

return "not null";

}

}

}

3.实体类

public class Users {

private Integer uid;

private String name;

private String username;

private String password;

private String gender;

private Integer age;

private Date createdate;

private Date lastlogindate;

private Integer locked;

get set.......

}

4.service和mapper就不贴出来了(mybatis逆向工程就可以直接搞定mapper和pojo)

九、JSP部分

1.userinfo.jsp

Insert title here

Show User

name

username

gender

age

createDate

lastLoginDate

locked

操作

${user.uid} --%>

${user.name}

${user.gender}

${user.age}

${user.locked}

2.其他JSP页面就只是画页面而已就不贴了

十、最后完整的项目结构

另源码地址：https://download.csdn.net/download/qq_38553950/10738793

github:https://github.com/houfanGitHub/ssm-demo