private String insertSql(Note note) {
// 组装sql
StringBuilder sb = new StringBuilder();
sb.append(
"insert into tcnote (note_id,note_name,author_name,from_url,flag,noteBook,noteBookGroup) values ( ");
sb.append(note.getNoteId() + ", ");
sb.append("'" + note.getNoteName() + "', ");
sb.append("'" + note.getAuthorName() + "', ");
sb.append("'" + note.getFromUrl() + "', ");
sb.append(note.getFlag() + ", ");
sb.append(" 1, ");
sb.append(" 1 )");
return sb.toString();
}
public Note queryById(String i) {
Note note = new Note();
RedisCachePool pool =
redisCacheManager.getRedisPoolMap().get(RedisDataBaseType.defaultType.toString());
Jedis jedis = pool.getResource();
// 查询不用开启事物
RedisDao rd = new RedisDao(jedis);
note = (Note) rd.getBean("Note:" + i, note.getClass(), jedis);
pool.returnResource(jedis);
// dubbo 调用的时候防止java.sql.Blob cannot be assigned from null ，也就是blob字段不能为空
note.setBlobContent(null);
return note;
}
public void insert(Note note) {
RedisCachePool pool = null;
Jedis jedis = null;
RedisDao rd = null;
try {
pool = redisCacheManager.getRedisPoolMap().get(RedisDataBaseType.defaultType.toString());
jedis = pool.getResource();
// 获取redis里面最大的主键值
Set<String> sortKey = RedisDao.getRevrangeSortSet("Note:sort:noteId", 0, 0, jedis);
for (String id : sortKey) {
// 新增的主键赋值
note.setNoteId(Integer.parseInt(id) + 1);
break;
}
Transaction transation = jedis.multi();
rd = new RedisDao(transation);
BeanField beanField = rd.getBeanField(note);
// 插入新增的
rd.insertSingleDataToredis(note, beanField);
/* 处理之后的数据库sql日志处理 */
String logs = insertSql(note);
rd.pubishLog(logs);
rd.log(logs);
transation.exec();
} catch (Exception e) {
log.error(" insert(Note note) 失败！" + e.getLocalizedMessage());
} finally {
log.info("回收insert==>jedis连接");
pool.returnResource(jedis);
}
}
/**
* @Description: 组织sql
*
* @param note
* @return:void
*/
private String genSql(Note note) {
// 组装sql
StringBuilder sb = new StringBuilder();
sb.append(" update tcnote set ");
if (note.getAuthorName() != null) {
sb.append(" author_name='" + note.getAuthorName() + "', ");
}
if (note.getFromUrl() != null) {
sb.append(" from_Url='" + note.getFromUrl() + "', ");
}
if (note.getNoteName() != null) {
sb.append(" note_name='" + note.getNoteName() + "', ");
}
// flag=0防止note里面字段都是空的
sb.append(" flag=0 where note_id= " + note.getNoteId());
return sb.toString();
}
/** 更新直接调用删除，然后再插入 */
public void update(Note newNote) {
RedisCachePool pool = null;
Jedis jedis = null;
RedisDao rd = null;
try {
pool = redisCacheManager.getRedisPoolMap().get(RedisDataBaseType.defaultType.toString());
jedis = pool.getResource();
// 获取原来redis里面存储的note
Object orldNote = RedisDao.getBean("Note:" + newNote.getNoteId(), Note.class, jedis);
if (null != orldNote) {
// 查询之后开启事物
Transaction transation = jedis.multi();
rd = new RedisDao(transation);
BeanField beanField = rd.getBeanField(orldNote);
// // 先删除原来的
// rd.delSingleDataFromRedis(orldNote, beanField);
// // 再插入新修改的note
// rd.insertSingleDataToredis(newNote, beanField);
rd.updateSingleFromToredis(orldNote, newNote, beanField);
/* 处理之后的数据库sql日志处理 */
String logs = genSql(newNote);
rd.pubishLog(logs);
rd.log(logs);
transation.exec();
}
} catch (Exception e) {
log.error(" update(Note note) 失败！" + e.getLocalizedMessage());
} finally {
// log.info("回收jedis连接");
pool.returnResource(jedis);
}
}
/**
* @Description: 组装key值
*
* @param note
* @return:void
*/
private String[] genKeys(Note note) {
String[] string = null;
StringBuilder sb = new StringBuilder();
if (note.getAuthorName() != null) {
sb.append("," + "Note:authorName:" + note.getAuthorName());
}
if (note.getFromUrl() != null) {
sb.append("," + "Note:fromUrl:" + note.getFromUrl() + ",");
}
if (note.getFlag() != null) {
sb.append("," + "Note:flag:" + note.getFlag() + ",");
}
if (null != sb.toString()) {
// 去除第一个逗号
String replaceString = sb.toString().replaceFirst(",", "");
string = replaceString.split(",");
}
return string;
}
private void delalBlob(List<Note> noteList) {
for (Note note : noteList) {
note.setBlobContent(null);
}
}