- 框架（ Framework）是整个或部分系统的可重用设计，表现为一组抽象构件及构件实例间交互的方法。或者说是可被应用开发者定制的应用骨架。
- 框架的优点：
- 框架已经实现了一些功能，使用时不需重复实现这些功能，提高开发效率；
- 使用框架后，我们软件的架构更加稳定、开发流程必须按照框架约定进行，而优秀的框架是所有开发人员都熟悉的，任何人进入项目团队后可以更快适应开发，同时框架良好的扩展性更易于后期维护，减少项目成本。
表现层：SpringMVC、Struts2
业务层：Spring可对service层提供统一的事务控制。
数据访问层：JDBC、自定义框架封装jdbc、JDBCTemplate（Spring）、apache DbUtils、Hibernate框架、Jpa、Spring Data Jpa、Mybatis等
1.准备数据库
-- 1.创建数据库 CREATE DATABASE mybatis DEFAULT CHARACTER SET utf8; -- 2.创建用户表 DROP TABLE IF EXISTS USER; CREATE TABLE USER ( id INT(11) NOT NULL AUTO_INCREMENT, username VARCHAR(32) NOT NULL COMMENT '用户名称', birthday DATETIME DEFAULT NULL COMMENT '生日', sex CHAR(1) DEFAULT NULL COMMENT '性别', address VARCHAR(256) DEFAULT NULL COMMENT '地址', PRIMARY KEY (id) ) ENGINE=INNODB DEFAULT CHARSET=utf8; INSERT INTO USER(id,username,birthday,sex,address) VALUES (41,'旺旺','2018-08-27 17:47:08','男','北京'),(42,'小二王','2018-09-02 15:09:37','女','南京'), (43,'明明','2018-01-04 11:34:34','女','东京'), (45,'狗蛋','2017-02-04 12:04:06','男','西安'), (46,'隔壁老王','2015-05-07 17:37:26','男','济南'), (48,'茱莉','2017-07-07 11:44:00','女','华盛顿'); SELECT * FROM USER; 2.创建项目
3.创建实体类
package com.azure.entity; import java.util.Date; public class User { private int id; private String username; private Date birthday; private String sex; private String address; public User() { } @Override public String toString() { return "User{" + "id=" + id + ", username='" + username + '\'' + ", birthday=" + birthday + ", sex='" + sex + '\'' + ", address='" + address + '\'' + '}'; } public User(int id, String username, Date birthday, String sex, String address) { this.id = id; this.username = username; this.birthday = birthday; this.sex = sex; this.address = address; } public int getId() {return id;} public void setId(int id) {this.id = id;} public String getUsername() {return username;} public void setUsername(String username) {this.username = username;} public Date getBirthday() {return birthday;} public void setBirthday(Date birthday) {this.birthday = birthday;} public String getSex() {return sex;} public void setSex(String sex) {this.sex = sex;} public String getAddress() {return address;} public void setAddress(String address) {this.address = address;} } 4.添加依赖
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.azure</groupId> <artifactId>day47projects_mybatis01</artifactId> <version>1.0-SNAPSHOT</version> <packaging>war</packaging> <dependencies> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.6</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.30</version> </dependency> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.17</version> </dependency> </dependencies> </project> - 该文件要放在src/main/resources目录下
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <environments default="mysql"> <environment id="mysql"> <transactionManager type="JDBC"></transactionManager> <dataSource type="pooled"> <property name="driver" value="com.mysql.jdbc.Driver"></原文链接：https://blog.csdn.net/KeepStruggling/article/details/83449908?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522171837794916800180657233%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fblog.%2522%257D&request_id=171837794916800180657233&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~blog~first_rank_ecpm_v1~times_rank-16-83449908-null-null.nonecase&utm_term=%E8%A5%BF%E5%AE%89%E6%9C%8D%E5%8A%A1%E5%99%A8%E6%89%98%E7%AE%A1
原创文章，作者：优速盾-小U，如若转载，请注明出处：https://www.cdnb.net/bbs/archives/32223
