新建测试表
drop table CMU_TMP_TEST;
create table CMU_TMP_TEST (
id VARCHAR2(2) primary key,
info blob default null
);
修改generatorConfig.xml增加测试表配置数据(mybatis框架的一种工具)
自动生成测试表持久层代码
修改DataAnalyze数据分析部分代码:增加service层impl层逻辑
DataAnalyzeService.java
public byte[] getByte();
public void setByte(byte[] info);
DataAnalyzeServiceImpl.java
@Override
public byte[] getByte() {
byte[] rs;
rs = tmpTestMapper.selectByPrimaryKey("1").getInfo();
return rs;
}
@Override
public void setByte(byte[] info) {
TmpTest tmpTest = new TmpTest();
tmpTest.setId("1");
tmpTest.setInfo(info);
tmpTestMapper.updateByPrimaryKeyWithBLOBs(tmpTest);
}
修改DataListController对应逻辑
map转二进制更新数据库表字段:
ByteArrayOutputStream byt=new ByteArrayOutputStream();
try {
ObjectOutputStream obj = new ObjectOutputStream(byt);
obj.writeObject(map);
byte[] cnb = byt.toByteArray();
dataAnalyzeService.setByte(cnb);
cnb = dataAnalyzeService.getByte();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
读取字段二进制转map
byte[] cnb = dataAnalyzeService.getByte();
ByteArrayInputStream byteInt=new ByteArrayInputStream(cnb);
try {
ObjectInputStream objInt=new ObjectInputStream(byteInt);
try {
map = (Map<String, Object>)objInt.readObject();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
drop table CMU_TMP_TEST;
create table CMU_TMP_TEST (
id VARCHAR2(2) primary key,
info blob default null
);
修改generatorConfig.xml增加测试表配置数据(mybatis框架的一种工具)
自动生成测试表持久层代码
修改DataAnalyze数据分析部分代码:增加service层impl层逻辑
DataAnalyzeService.java
public byte[] getByte();
public void setByte(byte[] info);
DataAnalyzeServiceImpl.java
@Override
public byte[] getByte() {
byte[] rs;
rs = tmpTestMapper.selectByPrimaryKey("1").getInfo();
return rs;
}
@Override
public void setByte(byte[] info) {
TmpTest tmpTest = new TmpTest();
tmpTest.setId("1");
tmpTest.setInfo(info);
tmpTestMapper.updateByPrimaryKeyWithBLOBs(tmpTest);
}
修改DataListController对应逻辑
map转二进制更新数据库表字段:
ByteArrayOutputStream byt=new ByteArrayOutputStream();
try {
ObjectOutputStream obj = new ObjectOutputStream(byt);
obj.writeObject(map);
byte[] cnb = byt.toByteArray();
dataAnalyzeService.setByte(cnb);
cnb = dataAnalyzeService.getByte();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
读取字段二进制转map
byte[] cnb = dataAnalyzeService.getByte();
ByteArrayInputStream byteInt=new ByteArrayInputStream(cnb);
try {
ObjectInputStream objInt=new ObjectInputStream(byteInt);
try {
map = (Map<String, Object>)objInt.readObject();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
本文原创于:美推网 (http://www.zdflshop.com/)。