--创建数据库 create database 数据库名 character set utf8将数据库编码格式设计成utf8格式。 create database mybatis character set utf8; create table tb_user( userid int primary key auto_increment, username varchar(20), realname varchar(20) ); insert into tb_user values(null,'aaa','展示'),(null,'bbb','张三'),(null,'www','网站'),(null,'qww','去玩儿'),(null,'lmb','老毛病'),(null,'eee','鹅鹅鹅')
3.4 创建实体类
//下载lombok 加注解
//自动生成set和get
@Data
//生无参
@NoArgsConstructor
//生有参
@AllArgsConstructor
public class User {
private int userid;
private String username;
private String realname;
}
//下载lombok 加注解
//自动生成set和get
@Data
//生无参
@NoArgsConstructor
//生有参
@AllArgsConstructor
public class User {
private int userid;
private String username;
private String realname;
}
6 使用mybatis完成crud
xml
select * from tb_user where userid=#{id}
insert into tb_user values(null,#{username},#{realname});
delete from tb_user where userid=#{id}
update tb_user set username=#{username},realname=#{realname} where userid=#{userid}
select * from tb_user;
测试
//增加
public static void main(String[] args) throws IOException {
//读取mybatis配置文件 解析配置文件
Reader resource = Resources.getResourceAsReader("mybatis.xml");
//通过配置文件构造sqlsessionFactory对象
SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(resource);
//获取sqlsession对象 SQLsession对象封装了各种对 数据库的操作方法
SqlSession session = factory.openSession();
//添加是给属性设置值
User user = new User();
user.setUsername("ddd");
user.setRealname("张三");
System.out.println("前"+user);
//将user传给insert方法
int row = session.insert("quser.add", user);
System.out.println(row);
//增删改必须提交
session.commit();
System.out.println("后"+user);
session.close();
}