随笔分类 -  mysql

上一页 1 2 3
按时间间隔查询
摘要：select ONH_ID,date_format(CREATE_TIME, '%Y%m%d%H') as date, count(1) from RIV_OUTBOUND_NOTICE_H where CREATE_TIME >= '2017-09-22 08:00:00' and CREATE_TIME < '2017-09-22 10:55:23' GROUP BY date 阅读全文
posted @ 2017-09-22 10:08 tonggc1668 阅读(133) 评论(0) 推荐(0)
把查询出来的结果进行修改再赋值给list
摘要：List list = this.jdbcTemplate.getJdbcOperations().query(sqlSb.toString(), params.toArray(), new RowMapper(){ @Override public RivBillNoPatternL mapRow(ResultSet rs, int rowNu... 阅读全文
posted @ 2017-06-15 15:45 tonggc1668 阅读(935) 评论(0) 推荐(0)
从sql中获取表名
摘要：com.github.jsqlparser jsqlparser 0.9 import java.io.StringReader; import java.util.List; import net.sf.jsqlparser.parser.CCJSqlParserManager; import net.sf.jsqlparser.st... 阅读全文
posted @ 2017-06-12 14:35 tonggc1668 阅读(3555) 评论(0) 推荐(0)
mysql /etc/my.cnf
摘要：[client] port=3306 socket = /tmp/mysql.sock default-character-set=utf8 [mysqld] # 1 general config port=3306 socket = /tmp/mysql.sock datadir = /u02/mysql binlog_cache_size = 1M default-storage-en... 阅读全文
posted @ 2017-05-18 14:03 tonggc1668 阅读(399) 评论(0) 推荐(0)
多条件查询
摘要：protected NamedParameterJdbcTemplate jdbcTemplate;public DataGrid query(QueryCriteria qc) { Class clazz = RivGeneralConfig.class; Integer currentPage = null; Integer pageSize... 阅读全文
posted @ 2017-03-20 09:43 tonggc1668 阅读(166) 评论(0) 推荐(0)
sql 更新 批量更新 更新得到主键
摘要：import org.springframework.dao.InvalidDataAccessApiUsageException; import org.springframework.jdbc.core.BatchPreparedStatementSetter; import org.springframework.jdbc.core.BeanPropertyRowMapper; impor... 阅读全文
posted @ 2017-03-06 16:03 tonggc1668 阅读(1983) 评论(0) 推荐(0)
得到新序列号
摘要：import org.springframework.jdbc.core.PreparedStatementCreator; import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate; import org.springframework.jdbc.support.GeneratedKeyHolder; ... 阅读全文
posted @ 2017-03-06 13:10 tonggc1668 阅读(132) 评论(0) 推荐(0)
删除90天以前的表
摘要：import org.apache.commons.dbutils.BasicRowProcessor; import org.apache.commons.dbutils.BeanProcessor; import org.apache.commons.dbutils.QueryRunner; import org.apache.commons.dbutils.RowProcessor; im... 阅读全文
posted @ 2017-02-23 17:17 tonggc1668 阅读(221) 评论(0) 推荐(0)
查询表中有多少行记录
摘要：import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core... 阅读全文
posted @ 2017-02-23 17:17 tonggc1668 阅读(810) 评论(0) 推荐(0)
插入po得到主键,插入sql得到主键
摘要：import com.yd.common.data.CIPPageInfo; import com.yd.common.data.CIPReqCondition; import com.yd.common.exception.CIPDaoException; import com.yd.common.runtime.CIPErrorCode; import com.yd.wms.busi.dao... 阅读全文
posted @ 2017-02-23 17:15 tonggc1668 阅读(509) 评论(0) 推荐(0)
查询多列得到map与查询得到po对象
摘要：import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import org.springframework.beans.factory.annotation 阅读全文
posted @ 2017-02-23 17:02 tonggc1668 阅读(405) 评论(0) 推荐(0)

上一页 1 2 3