From 1b181507f2564bfd327cc3a8e5d75a8620c3d09d Mon Sep 17 00:00:00 2001 From: chenjiahe <763432473@qq.com> Date: 星期二, 07 二月 2023 18:37:26 +0800 Subject: [PATCH] 数据库公用方法添加 --- src/main/java/com/hx/common/service/impl/CommonDaoImpl.java | 30 ++++++++++++++++++++++++++++-- 1 files changed, 28 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/hx/common/service/impl/CommonDaoImpl.java b/src/main/java/com/hx/common/service/impl/CommonDaoImpl.java index 388fcd3..8ccd28d 100644 --- a/src/main/java/com/hx/common/service/impl/CommonDaoImpl.java +++ b/src/main/java/com/hx/common/service/impl/CommonDaoImpl.java @@ -1,6 +1,7 @@ package com.hx.common.service.impl; import com.hx.common.dao.CommonDao; +import com.hx.common.dao.mapper.CommonMapper; import com.hx.mybatisTool.SqlSentence; import org.apache.ibatis.session.SqlSessionFactory; import org.springframework.stereotype.Service; @@ -28,10 +29,23 @@ return sqlSessionFactory.openSession().insert(getStatement(mapperClass,"insert"),entity); } - /**鑾峰彇鏉℃暟*/ @Override - public <T extends Serializable> int selectCount(Class<?> mapperClass,SqlSentence sqlSentence) { + public <T extends Serializable> int insertById(Class<?> mapperClass, T entity) { + return sqlSessionFactory.openSession().insert(getStatement(mapperClass,"insertById"),entity); + } + + /**鑾峰彇鏉℃暟 + * @return*/ + @Override + public <T extends Serializable> int selectCount(Class<?> mapperClass, SqlSentence sqlSentence) { return sqlSessionFactory.openSession().selectOne(getStatement(mapperClass,"selectCount"),sqlSentence); + } + + /**鑾峰彇鏉℃暟 + * @return*/ + @Override + public <T extends Serializable> int selectCountSql(Class<?> mapperClass, SqlSentence sqlSentence) { + return sqlSessionFactory.openSession().selectOne(getStatement(mapperClass,"selectCountSql"),sqlSentence); } /**鑾峰彇鍒楄〃*/ @@ -94,4 +108,16 @@ return sqlSessionFactory.openSession().delete(getStatement(mapperClass,"deleteById"),object); } + /**鏇存柊sql璇彞锛堝叏璇彞锛�*/ + @Override + public <T extends Serializable> int updateSentence(SqlSentence sqlSentence) { + return sqlSessionFactory.openSession().update(getStatement(CommonMapper.class,"updateSentence"),sqlSentence); + } + + /**鏌ヨ鏉℃暟锛堝叏璇彞锛�*/ + @Override + public <T extends Serializable> int selectCountSql(SqlSentence sqlSentence) { + return sqlSessionFactory.openSession().selectOne(getStatement(CommonMapper.class,"selectCountSql"),sqlSentence); + } + } -- Gitblit v1.8.0