一.学习新知识的步骤
环境搭建---编写代码--测试代码---总结知识
二.环境搭建
(1)搭建数据库
CREATE TABLE `user` (
`id` int(20) NOT NULL,
`name` varchar(20) DEFAULT NULL,
`pwd` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
如图
(2)搭建idea的环境与数据库的链接
1.创建实体包pojo与实体类User,并与数据库链接
注意:这里数据库的表名与字段名(数据类型)必须一致否则会报错,找不到mapper的资源
package com.sqt.pojo; //实体类 public class User { private int id; private String name; private String pwd; public User() { } public User(int id, String name, String pwd) { this.id = id; this.name = name; this.pwd = pwd; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getPwd() { return pwd; } public void setPwd(String pwd) { this.pwd = pwd; } @Override public String toString() { return "User{" + "id=" + id + ", name='" + name + '\'' + ", pwd='" + pwd + '\'' + '}'; } } 随后与数据库测试链接
2.导入依赖
mysql-connector-java,mybatis,junit,build(这个是为了防止xml文件导入不进去,idea不会主动导入xml文件)
<dependencies> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId&