帮我写一段mybates写一段增删改查
时间: 2023-03-23 16:01:55 浏览: 49
好的,以下是一个基于MyBatis的增删改查的示例代码:
增加记录:
```java
public void addRecord(Record record) {
SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
try {
RecordMapper mapper = session.getMapper(RecordMapper.class);
mapper.addRecord(record);
session.commit();
} finally {
session.close();
}
}
```
删除记录:
```java
public void deleteRecord(int id) {
SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
try {
RecordMapper mapper = session.getMapper(RecordMapper.class);
mapper.deleteRecord(id);
session.commit();
} finally {
session.close();
}
}
```
修改记录:
```java
public void updateRecord(Record record) {
SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
try {
RecordMapper mapper = session.getMapper(RecordMapper.class);
mapper.updateRecord(record);
session.commit();
} finally {
session.close();
}
}
```
查询记录:
```java
public Record getRecord(int id) {
SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
try {
RecordMapper mapper = session.getMapper(RecordMapper.class);
return mapper.getRecord(id);
} finally {
session.close();
}
}
```
其中,Record为一个Java类,对应于数据库中的记录,RecordMapper为一个接口,包含了以上四个方法的声明。这里的示例代码仅供参考,实际应用中需要根据具体情况进行调整和扩展。