利用DataBaseMetaData和ResultSetMetaData复制数据库的表和数据
来源：互联网 发布：刷机会不会丢失数据 编辑：程序博客网 时间：2024/06/05 23:04
测试代码见我的云盘“学习路径/自己做的例子/CopyDatabase”
我们有时候可能需要复制一个数据库中的数据，可能同一个数据库中操作还简单，但是跨数据库的操作就可能很麻烦了，常见的工具都做不到。
现利用DataBaseMetaData和ResultSetMetaData实现了一个功能，生成数据库中的表的所有数据的insert语句，你只需要在你的数据库中运行这个代码即可。
操作步骤是：1.在你的数据库中创建你需要复制的表 2.运行代码生成的insert语句
SqlHelper.java【获取Connection和查询功能】
public class SqlHelper {
Connection ct=null;
PreparedStatement ps=null;
ResultSet rs=null;
String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url="jdbc:sqlserver://localhost:1433; DatabaseName=InstrumentManager";
String user="sa";
String password="xsy881026";
// String driverName="com.mysql.jdbc.Driver";
// String url="jdbc:mysql://localhost:3306/InstrumentManager";
// String user="root";
// String password="root";
public SqlHelper(){
try {
Class.forName(driverName);
ct=DriverManager.getConnection(url,user,password);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public ResultSet query(String sql,String ...args){
try {
ps=ct.prepareStatement(sql);
for(int i=0;i<args.length;i++)
ps.setString(i+1, args[i]);
rs=ps.executeQuery();
} catch (Exception e) {
e.printStackTrace();
}
return rs;
}
public Connection getConnection(){
return ct;
}
//把数据库的增，删，改 写一个函数
public boolean exeUpdate(String sql, Object ...args)
{
boolean b=true;
try {
ps=ct.prepareStatement(sql);
//给sql语句中的?号赋值
for(int i=0; i<args.length; i++)
{
ps.setObject(i+1,args[i]);
}
ps.executeUpdate(); //更新数据
} catch (Exception e) {
// TODO: handle exception
b=false;
e.printStackTrace();
}
return b;
}
public void close(){
try {
if(rs!=null)
rs.close();
if(ps!=null)
ps.close();
if(ct!=null)
ct.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public class GenerateSQL {
@Test
public void testGenerateSQL(){
SqlHelper helper = new SqlHelper();
String[] tableNames = {"table_bwpv","table_department","table_employee","table_forum",
"table_gama","table_gotowell","table_inouthistory","table_instrumentbaseinfo",
"table_instrumentcycling","Table_MaintainanceOfComponent","Table_MaintainanceOfInstruement",
"Table_MWD","Table_Node","Table_NodeCascade","Table_Resistivity","Table_Stock","Table_WellInfo"};
try {
System.out.println(helper.getConnection().getCatalog());//获取数据库名称
//获取所有的数据表
ResultSet set = helper.getConnection().getMetaData().getTables(null, null, null, new String[]{"TABLE"});
while (set.next()) {
String tableName = set.getString(3);
//根据表获取数据
createInsertSQL(helper, tableName);
}
set.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* 根据表名复制表中的数据，生成insert语句，
* 目前只能支持数字型和字符型的数据，对于
* 二进制的数据，需要特殊的处理方式
* @param helper
* @param tableName
*/
private void createInsertSQL(SqlHelper helper, String tableName) {
try {
ResultSet set = helper.query(
"select * from "+tableName);
ResultSetMetaData metaData = set.getMetaData();
int count = metaData.getColumnCount();
//List<String> labels = getLabels(metaData);
OutputStream os = new FileOutputStream("copy.sql");
StringBuffer insertSQL = null;
while (set.next()) {
insertSQL = new StringBuffer("INSERT INTO " + tableName + " VALUES(");
for (int i = 0; i < count; i++) {
Object obj = set.getObject(i+1);
int type = metaData.getColumnType(i+1);
if(isChar(type)){//根据列的类型看是否需要添加''
insertSQL.append("'"+obj+"'").append(",");
}else{
insertSQL.append(obj).append(",");
}
}
String sql = insertSQL.substring(0, insertSQL.length()-1);//去掉最后的逗号
sql= sql +")";
System.out.println(sql);//这个语句可以保存到文件中，在你的数据库中运行这个文件即可。
os.write(sql.getBytes());
}
set.close();
os.close();
} catch (Exception e) {
e.printStackTrace();
}
}
private boolean isChar(int type) {
switch (type) {
case Types.CHAR:
case Types.DATE:
case Types.LONGNVARCHAR:
case Types.LONGVARCHAR:
case Types.NCHAR:
case Types.NVARCHAR:
case Types.SQLXML:
case Types.VARCHAR:
case Types.TIMESTAMP:
case Types.TIME:
return true;
default :
return false;
}
}
private List<String> getLabels(ResultSetMetaData metaData) throws SQLException {
String label;
List<String> labels = new ArrayList<String>();
int count = metaData.getColumnCount();
for (int i = 0; i < count; i++) {
label = metaData.getColumnLabel(i+1);
//System.out.println(label);
int type = metaData.getColumnType(i+1);
System.out.println(type);
//Types
labels.add(label);
}
return labels;
}
}
生成的测试语句
想想如果我们手动敲的话多占用时间和精力。
InstrumentManager
INSERT INTO Table_Department VALUES(1,'仪器检修中心',20,'负责仪器检修，厂房管理')
INSERT INTO Table_Department VALUES(2,'仪器现场技术推广中心',40,'负责仪器上井工作，管理')
INSERT INTO Table_Department VALUES(3,'随钻测量与控制技术研究所',30,'负责仪器研发，负责仪器研发，负责仪器研发，负责仪器研发，负责仪器研发，负责仪器研发，负责仪器研发，负责仪器研发，负责仪器研发，负责仪器研发')
INSERT INTO Table_Employee VALUES(1,'86292428','熊诗言','男','四川省达州万源市白果乡','yanshixiong@126.com','15804270493','仪器检修工程师','2011-07-01','xsy881026',1,'yes',[B@1e78fc6,7)
INSERT INTO Table_Employee VALUES(2,'86292395','车智超','男','陕西省商洛县','czc1988@126.com','15326281956','仪器检修工程师','2011-07-01','czc',1,'no',[B@1f6226,7)
INSERT INTO Table_Employee VALUES(3,'86292433','杨鹏','男','陕西省商洛县','yangpeng@126.com','15142720876','仪器检修工程师','2011-07-01','123',1,'no',[B@64ea66,7)
INSERT INTO Table_Employee VALUES(4,'86183196','张俊','男','湖北省荆州市','zhangjun@136.com','18698796856','仪器检修工程师','2011-07-01','123',1,'no',[B@158f9d3,7)
INSERT INTO Table_Employee VALUES(5,'86183215','吴文博','男','辽宁省盘锦市','wuwenbo@126.com','18609871119','仪器检修工程师','2011-07-01','123',1,'no',[B@79a2e7,7)
INSERT INTO Table_Employee VALUES(6,'86385687','王超','男','河北省荆州市','wangchao@126.com','15724371623','仪器检修工程师','2011-07-01','123',1,'no',[B@5e55ab,7)
INSERT INTO Table_Employee VALUES(7,'80637405','王海民','男','辽宁省盘锦市','wanghaimin@126.com','13942795078','经理','1983-07-20','123',1,'yes',[B@14a55f2,0)
INSERT INTO Table_Employee VALUES(8,'86386188','夏进福','男','湖北省荆州市','xiajinfu@126.com','1234314321','仪器检修工程师','2013-07-01','xjf',1,'no',[B@15093f1,7)
INSERT INTO Table_Employee VALUES(9,'86386191','宋智威','男','湖北省荆州市','songzhiwei@126.com','15724370910','仪器检修工程师','2011-07-01','123',1,'no',[B@120bf2c,7)
INSERT INTO Table_Employee VALUES(10,'86386271','马晓平','女','辽宁省盘锦市','maxiaoping@126.com','15142786891','核算员','2014-02-01','124',1,'no',[B@e6f7d2,7)
INSERT INTO Table_Employee VALUES(11,'','刘洋','女','辽宁省盘锦市','liuyang@126.com','11111111111','安全员','2013-07-01','123',1,'no',[B@19836ed,7)
INSERT INTO Table_Employee VALUES(12,'86314443','孙泽','女','辽宁省盘锦市','sunze@126.com','22222222222','质量员','2013-07-01','123',1,'no',[B@3e0ebb,7)
INSERT INTO Table_Employee VALUES(13,'86329276','叶寒冰','男','辽宁省盘锦市','yehanbing@126.com','22222222222','仪器检修工','2011-07-01','123',1,'no',[B@39443f,7)
INSERT INTO Table_Employee VALUES(14,'86292535','李松辰','男','辽宁省盘锦市','lisongchen@126.com','44444444444','仪器检修工','2013-07-01','123',1,'no',[B@1afae45,7)
INSERT INTO Table_Employee VALUES(15,'86206218','关键','男','辽宁省盘锦市','guanjian@126.com','55555555555','仪器检修工程师','2011-07-01','123',1,'no',[B@da4b71,7)
INSERT INTO Table_Employee VALUES(16,'80637399','滕连忠','男','辽宁省盘锦市','tenglianzhong@126.com','66666666666','高级技工','1981-07-01','123',1,'yes',[B@18f1d7e,1)
INSERT INTO Table_Employee VALUES(17,'80579717','孙东辉','男','辽宁省盘锦市','sundonghui@126.com','77777777777','高级技工','1981-07-01','123',1,'no',[B@d9660d,7)
INSERT INTO Table_Employee VALUES(18,'80637400','张旭杰','男','辽宁省盘锦市','zhangxujie@126.com','88888888888','高级技工','1978-07-01','123',1,'no',[B@55e55f,7)
INSERT INTO Table_Employee VALUES(19,'80579757','程勇','男','辽宁省盘锦市','chengyong@126.com','99999999999','高级技工','1983-07-01','123',1,'no',[B@145c859,7)
INSERT INTO Table_Employee VALUES(20,'86292442','赵卫刚','男','陕西省西安市','zhaoweigang@126.com','11111111111','仪器检修工程师','2011-07-01','123',1,'no',[B@64883c,7)
INSERT INTO Table_Employee VALUES(21,'11111111','曹雷','男','辽宁省临海市','caolei@126.com','11111111111','仪器工程师','2011-07-01','123',2,'no',null,1)
INSERT INTO Table_Employee VALUES(22,'22222222','翁波强','男','浙江省。。市','wengboqiang@126.com','22222222222','仪器研发工程师','2011-07-01','123',3,'no',null,1)
INSERT INTO Table_Employee VALUES(115,'86292428','熊诗言','男','四川省达州万源市白果乡','yanshixiong@126.com','15804270493','仪器检修工程师','2011-07-01','xsy881026',2,'yes',[B@2c1e6b,1)
INSERT INTO Table_Employee VALUES(116,'86292428','熊诗言','男','四川省达州万源市白果乡','yanshixiong@126.com','15804270493','仪器检修工程师','2011-07-01','xsy881026',3,'yes',[B@811c88,1)
INSERT INTO Table_Employee VALUES(118,'86292428','3423423423','男','四川省达州万源市白果乡','yanshixiong@126.com','15804270493','仪器检修工程师','2011-07-01','xsy881026',3,'no',[B@785d65,1)
INSERT INTO Table_Employee VALUES(119,'86292428','3423423423','女','四川省达州万源市白果乡','yanshixiong@126.com','15804270493','仪器检修工程师','2011-07-01','xsy881026',3,'yes',null,1)
INSERT INTO Table_Employee VALUES(126,'test','饕餮','df','覆盖','df ','f ','f','fdg','gf',2,'4',null,1)
INSERT INTO Table_Employee VALUES(127,'86385673','余凯','男','湖北潜江','835755412@qq.com','18742381193','仪器检修工程师','2013-07-01','123',3,'no',null,1)
INSERT INTO Table_Forum VALUES(1,'幽默笑话','幽默笑话',21,21,1)
INSERT INTO Table_Forum VALUES(2,'技术交流','技术交流',12,21,2)
INSERT INTO Table_Forum VALUES(3,'信息通知','信息通知',12,22,1)
INSERT INTO Table_GoToWell VALUES(1,'2014-09-03 00:00:00.0',1,'杜-84',12,12,12,12,12.0,1,12,'121212','121212',1)
INSERT INTO Table_GoToWell VALUES(2,'2014-09-05 00:00:00.0',2,'杜-85',22,22,22,22,22.0,22,22,'22','22',2)
INSERT INTO Table_GoToWell VALUES(3,'2015-01-13 00:00:00.0',1,'杜-86',12,12,12,12,12.0,12,12,'12','12',12)
INSERT INTO Table_GoToWell VALUES(4,'2015-01-13 00:00:00.0',2,'杜-87',21,21,12,112,12.0,12,12,'12','1',126)
INSERT INTO Table_GoToWell VALUES(5,'2015-01-28 00:00:00.0',2,'杜-88',2,2,2,2,2.0,2,2,'2','2',2)
INSERT INTO Table_GoToWell VALUES(6,'2015-01-27 00:00:00.0',1,'杜-89',1,1,1,1,1.0,1,1,'1','1',1)
INSERT INTO Table_GoToWell VALUES(10,'2015-01-29 00:00:00.0',9,'杜-81',1,1,1,1,1.0,1,1,'1','1',118)
INSERT INTO Table_GoToWell VALUES(11,'2015-01-28 00:00:00.0',11,'杜-82',1,1,1,1,1.0,1,1,'1','1',1)
INSERT INTO Table_GoToWell VALUES(12,'2015-01-27 00:00:00.0',1,'杜-83',1,1,1,1,1.0,1,1,'1','1',1)
INSERT INTO Table_GoToWell VALUES(13,'2015-01-20 00:00:00.0',9,'杜-84',1,1,1,1,1.0,1,1,'1','d',17)
INSERT INTO Table_InoutHistory VALUES(4,2,23,1,'2015-02-04 00:00:00.0','dfsdf',false)
INSERT INTO Table_InoutHistory VALUES(6,2,3,3,'2015-02-04 00:00:00.0','ewfw',false)
INSERT INTO Table_InoutHistory VALUES(7,3,23,2,'2015-02-05 00:00:00.0','efw',true)
INSERT INTO Table_InoutHistory VALUES(8,4,43,1,'2015-02-04 00:00:00.0','efw',true)
INSERT INTO Table_InoutHistory VALUES(9,12,232,1,'2015-03-02 00:00:00.0','e',true)
INSERT INTO Table_InoutHistory VALUES(10,2,21,2,'2015-03-10 00:00:00.0','23',true)
INSERT INTO Table_InoutHistory VALUES(11,23,21,5,'2015-03-26 00:00:00.0','12',false)
INSERT INTO Table_InoutHistory VALUES(12,2,11,2,'2015-03-25 00:00:00.0','21',false)
INSERT INTO Table_InoutHistory VALUES(13,2,11,4,'2015-03-26 00:00:00.0','212121212',false)
INSERT INTO Table_InoutHistory VALUES(14,2,12,3,'2015-03-26 00:00:00.0','231',false)
INSERT INTO Table_InoutHistory VALUES(15,2,12,9,'2015-03-26 00:00:00.0','21',false)
INSERT INTO Table_InoutHistory VALUES(16,3,3,2,'2015-03-26 00:00:00.0','21',false)
INSERT INTO Table_InoutHistory VALUES(17,3,13,3,'2015-03-26 00:00:00.0','21',true)
INSERT INTO Table_InoutHistory VALUES(18,2,12,7,'2015-03-26 00:00:00.0','21',true)
INSERT INTO Table_InstrumentBaseInfo VALUES(1,'BWR12','12','12','gg','ggg',1)
INSERT INTO Table_InstrumentBaseInfo VALUES(2,'BWRX24','12','12','12','12',2)
INSERT INTO Table_InstrumentBaseInfo VALUES(9,'sdasda','sdas','dasdadas','dassdas','dasd',3)
INSERT INTO Table_InstrumentBaseInfo VALUES(11,'fd121221fdfd','12','12','12','21211212',0)
INSERT INTO Table_InstrumentCycling VALUES(2,1,'2013-09-01 00:00:00.0',1,12.0,23.0,'122121','122121','212121','_a08fe50b-8174-46f4-a342-63e8dd8aa88d_11.png','21212112 ')
INSERT INTO Table_InstrumentCycling VALUES(3,2,'2015-01-29 00:00:00.0',3,12.0,24.0,'212','121','212','_a08fe50b-8174-46f4-a342-63e8dd8aa88d_11.png','21212 ')
INSERT INTO Table_InstrumentCycling VALUES(4,9,'2015-01-28 00:00:00.0',8,12.0,24.0,'231','12','12','_a08fe50b-8174-46f4-a342-63e8dd8aa88d_11.png','2111111111')
INSERT INTO Table_InstrumentCycling VALUES(8,1,'2015-01-12 00:00:00.0',1,12.0,12.0,'12','12','12','_a08fe50b-8174-46f4-a342-63e8dd8aa88d_11.png','12122222')
INSERT INTO Table_InstrumentCycling VALUES(9,9,'2015-01-28 00:00:00.0',1,21.0,1111111.0,'111111111','11111111111','111111','_a08fe50b-8174-46f4-a342-63e8dd8aa88d_11.png','211111111')
INSERT INTO Table_InstrumentCycling VALUES(10,11,'2015-01-28 00:00:00.0',9,12.0,21.0,'21','12','21','_a08fe50b-8174-46f4-a342-63e8dd8aa88d_11.png','211111')
INSERT INTO Table_InstrumentCycling VALUES(11,9,'2015-01-28 00:00:00.0',9,211.0,2112.0,'2','1','21','_a08fe50b-8174-46f4-a342-63e8dd8aa88d_11.png','2111111')
INSERT INTO Table_InstrumentCycling VALUES(12,9,'2015-01-28 00:00:00.0',3,21.0,1111.0,'1111111111','11111111111','111111111111','_82565ac7-70bf-4074-a07f-a628ca4f01d9_20150130142352.png','21111')
INSERT INTO Table_InstrumentCycling VALUES(13,11,'2015-01-21 00:00:00.0',9,21.0,1.11111113185165312E18,'11111111111','1111111111','111111111111','_a08fe50b-8174-46f4-a342-63e8dd8aa88d_11.png','21111')
INSERT INTO Table_InstrumentCycling VALUES(14,9,'2015-01-20 00:00:00.0',1,211.0,2112.0,'21','2122','22','_9016ca9f-a2a0-47f3-b7cd-6fba034222a6_32.png','211111ffffff')
INSERT INTO Table_InstrumentCycling VALUES(15,2,'2015-01-28 00:00:00.0',9,212.0,12.0,'12','21','21','_a08fe50b-8174-46f4-a342-63e8dd8aa88d_11.png','211111')
INSERT INTO Table_InstrumentCycling VALUES(16,2,'2015-01-20 00:00:00.0',7,122.0,2.2222221606912E13,'222222222222','222222222222','2222222222222222222222','_a08fe50b-8174-46f4-a342-63e8dd8aa88d_11.png','211111111111')
INSERT INTO Table_InstrumentCycling VALUES(17,2,'2015-01-28 00:00:00.0',7,21.0,111.0,'21','1111','2112','_a08fe50b-8174-46f4-a342-63e8dd8aa88d_11.png','21111111')
INSERT INTO Table_InstrumentCycling VALUES(18,11,'2015-01-20 00:00:00.0',5,21.0,121.0,'1111121','22','2','_a08fe50b-8174-46f4-a342-63e8dd8aa88d_11.png','21111111')
INSERT INTO Table_MaintainanceOfComponent VALUES(1,'小阀','23-pd',2,'2014-09-03 00:00:00.0','2014-09-03 00:00:00.0','小阀冲蚀严重 ','拆开维修 ','垫片 ',1,'推广 ',20000.0,'维修好了 ',0)
INSERT INTO Table_MaintainanceOfComponent VALUES(2,'大阀','21-PX',1,'2014-03-12 00:00:00.0','2014-03-12 00:00:00.0','大阀蘑菇头坏 ','拆开修理 ','蘑菇头 ',1,'辽河 ',10000.0,'.............. ',1)
INSERT INTO Table_MaintainanceOfComponent VALUES(3,'发电机','13',1,'2014-03-12 00:00:00.0','2014-03-12 00:00:00.0','发电机不发电 ','清洗重装调间隙 ','硬质合金 ',1,'国内 ',30000.0,'备注 ',2)
INSERT INTO Table_MaintainanceOfComponent VALUES(5,'dsds','dssdsd',3,'2015-01-12 15:38:05.0','2015-01-29 15:38:08.0','dsdsds ','dsd ','sdsd ',1,'1 ',1.0,'1 ',4)
INSERT INTO Table_MaintainanceOfComponent VALUES(6,'212','2121',2,'2015-01-29 15:38:32.0','2015-01-29 15:38:34.0','21 ','2 ','2 ',2,'2 ',2.0,'2 ',3)
INSERT INTO Table_MaintainanceOfComponent VALUES(8,'21','21',1,'2015-01-14 15:39:32.0','2015-01-29 15:39:35.0','21 ','2 ','2 ',2,'2 ',2.0,'2 ',2)
INSERT INTO Table_MaintainanceOfComponent VALUES(9,'1','1',1,'2015-01-29 15:40:02.0','2015-01-29 15:40:04.0','11 ','1 ','1 ',1,'1 ',1.0,'1 ',3)
INSERT INTO Table_MaintainanceOfComponent VALUES(10,'2','2',2,'2015-01-29 15:40:19.0','2015-01-29 15:40:21.0','2 ','2 ','2 ',2,'2 ',2.0,'2 ',2)
INSERT INTO Table_MaintainanceOfComponent VALUES(11,'2','2',3,'2015-01-29 15:40:33.0','2015-01-29 15:40:35.0','2 ','2 ','2 ',2,'2 ',2.0,'2 ',1)
INSERT INTO Table_MaintainanceOfComponent VALUES(12,'2','2',9,'2015-01-29 00:00:00.0','2015-01-29 00:00:00.0','2 ','2 ','2 ',2,'2 ',2.0,'2哈哈镜 ',4)
INSERT INTO Table_MaintainanceOfComponent VALUES(14,'3','3',10,'2015-01-29 15:41:34.0','2015-01-29 15:41:36.0','3 ','3 ','3 ',5,'3 ',3.0,'3 ',2)
INSERT INTO Table_MaintainanceOfComponent VALUES(15,'4','4',3,'2015-01-29 15:42:39.0','2015-01-29 15:42:41.0','4 ','4 ','4 ',6,'6 ',6.0,'6 ',2)
INSERT INTO Table_MaintainanceOfComponent VALUES(16,'6','6',1,'2015-01-29 15:43:13.0','2015-01-29 15:43:14.0','6 ','6 ','6 ',7,'7 ',7.0,'7 ',0)
INSERT INTO Table_MaintainanceOfComponent VALUES(17,'恒泰发电机','啥啥啥',6,'2015-03-24 14:18:14.0','2015-03-24 14:18:19.0','上电 ','但是 ','但是 ',1,'2 ',23.0,'213333的萨达阿斯达萨达苏打水 ',2)
INSERT INTO Table_MaintainanceOfInstruement VALUES(1,1,'杜-81','没信号','维修包2kljpmlkmlmk了了里面里面，里面，吗，吗吗， ，吗，吗， 里面， ，吗， ','gg*2
','_867ce32a-ba59-4c36-a53e-7d2032f336ec_3号.doc',21111.0,'2014-09-02 00:00:00.0')
INSERT INTO Table_MaintainanceOfInstruement VALUES(2,2,'杜-82','22222gfjhhhfffffffffffffffffffffffffffffffffffffffffffff发给fffffffffffffffffffff','222222hgjhgggggggggg福德宫ggggggggggggjkmn','22222','_01fbc705-cf9f-4d84-a1cc-971cfb5a2881_2013-12-05-19号仪器配置文件.rar',2222222.0,'2014-09-03 00:00:00.0')
INSERT INTO Table_MaintainanceOfInstruement VALUES(5,1,'杜-83','你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好','你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好','你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好','_35c83deb-3d37-49aa-896b-a6cd7b12797d_2013-12-05-19号仪器配置文件.rar',33333.0,'2015-01-28 00:00:00.0')
INSERT INTO Table_MaintainanceOfInstruement VALUES(6,2,'杜-84','444444就啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥','444444啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥','444444啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥啥','_35c83deb-3d37-49aa-896b-a6cd7b12797d_2013-12-05-19号仪器配置文件.rar',4.4444444E7,'2015-01-28 00:00:00.0')
INSERT INTO Table_MaintainanceOfInstruement VALUES(7,9,'杜-85','45555555','55555555','555555','_35c83deb-3d37-49aa-896b-a6cd7b12797d_2013-12-05-19号仪器配置文件.rar',5.55555584E8,'2015-01-14 00:00:00.0')
INSERT INTO Table_MaintainanceOfInstruement VALUES(8,11,'杜-86','666666666','66666666','666666666666666666','_17d938ed-fa40-4e05-9333-7aade4e8071a_du32-xingKH315.las',666666.0,'2015-01-28 00:00:00.0')
INSERT INTO Table_MaintainanceOfInstruement VALUES(9,2,'杜-87','777777777777777','777777777777','7777777777777','_35c83deb-3d37-49aa-896b-a6cd7b12797d_2013-12-05-19号仪器配置文件.rar',7777.0,'2015-01-28 00:00:00.0')
INSERT INTO Table_MaintainanceOfInstruement VALUES(10,9,'杜-88','8888888888888888888','8888888888','888888888','_35c83deb-3d37-49aa-896b-a6cd7b12797d_2013-12-05-19号仪器配置文件.rar',888.0,'2015-01-28 00:00:00.0')
INSERT INTO Table_MaintainanceOfInstruement VALUES(11,2,'杜-89','999999999','99999999999999999','999999999999999','_35c83deb-3d37-49aa-896b-a6cd7b12797d_2013-12-05-19号仪器配置文件.rar',1.0E8,'2015-01-28 00:00:00.0')
INSERT INTO Table_MaintainanceOfInstruement VALUES(12,11,'杜-80','9999999999999','999999999','9999999999999','_35c83deb-3d37-49aa-896b-a6cd7b12797d_2013-12-05-19号仪器配置文件.rar',999999.0,'2015-01-28 00:00:00.0')
INSERT INTO Table_MaintainanceOfInstruement VALUES(13,2,'杜-811','22222222','222222222','22222222222222','_35c83deb-3d37-49aa-896b-a6cd7b12797d_2013-12-05-19号仪器配置文件.rar',2.22222224E8,'2015-01-13 00:00:00.0')
INSERT INTO Table_MaintainanceOfInstruement VALUES(14,1,'杜-812','1111111111111111','1111111111','111111111111111','_35c83deb-3d37-49aa-896b-a6cd7b12797d_2013-12-05-19号仪器配置文件.rar',1111.0,'2015-01-14 00:00:00.0')
INSERT INTO Table_MaintainanceOfInstruement VALUES(15,2,'杜-813','12','22222222','2222222222222','_35c83deb-3d37-49aa-896b-a6cd7b12797d_2013-12-05-19号仪器配置文件.rar',21.0,'2015-01-27 00:00:00.0')
INSERT INTO Table_MaintainanceOfInstruement VALUES(16,2,'杜-814','21','111111','111111111111111111','_35c83deb-3d37-49aa-896b-a6cd7b12797d_2013-12-05-19号仪器配置文件.rar',1222.0,'2015-01-27 00:00:00.0')
INSERT INTO Table_MaintainanceOfInstruement VALUES(17,9,'杜-815','2111111111111111','11111111111111111111','11111111111111111','_35c83deb-3d37-49aa-896b-a6cd7b12797d_2013-12-05-19号仪器配置文件.rar',1222222.0,'2015-01-28 00:00:00.0')
INSERT INTO Table_MaintainanceOfInstruement VALUES(20,11,'杜十娘','是',' 的','的','_3a7ddfc5-5d7d-40e7-8b3f-a07898fc3bf9_汤阳光Hibernate3.6(基础二).doc',23.0,'2015-03-31 00:00:00.0')
INSERT INTO Table_Node VALUES(1,'Memory1','0x11','D','10081-08','1.1.86')
INSERT INTO Table_Node VALUES(2,'MWD','0x13','D','10060-04','3.0.32')
INSERT INTO Table_Node VALUES(3,'LWDMaster','0x14','B','10032-14','3.0.70')
INSERT INTO Table_Node VALUES(4,'FSKModem','0x17','E','10094-31','1.2.585')
INSERT INTO Table_Node VALUES(5,'DataProcess','0x19','C','10050-01','2.2.99')
INSERT INTO Table_Node VALUES(6,'SignalGenerator','0x1A','C','10039-05','2.0.16')
INSERT INTO Table_Node VALUES(7,'Memory2','0x1B','C','BWLWD1101019REM','1.1.86')
INSERT INTO Table_Node VALUES(8,'FSKModem','0x1F','C','BWLWD1101029REF','1.2.585')
INSERT INTO Table_Node VALUES(9,'Gama','0x21','B','10030-01','2.0.167')
INSERT INTO Table_Node VALUES(10,'FSKModem','0x27','E','10062-05','1.2.585')
INSERT INTO Table_Node VALUES(11,'PressVib','0x49','C','PWDDAQ-1','1.0.60')
INSERT INTO Table_Node VALUES(12,'FSKModem','0X4F','F','10179-11','1.2.585')
INSERT INTO Table_Node VALUES(13,'FSKModem','0x27','C','BWLWD1101013GAF','1.2.585')
INSERT INTO Table_Node VALUES(14,'Gama','0x21','C','BWLWD1101013GAC','2.0.167')
INSERT INTO Table_Node VALUES(15,'FSKModem','0x1F','C','BWLWD1101023REF','1.2.585')
INSERT INTO Table_Node VALUES(16,'Memory2','0x1B','C','BWLWD1101033REM','1.1.86')
INSERT INTO Table_Node VALUES(17,'SignalGenerator','0x1A','C','BWLWD1101023RES','2.0.16')
INSERT INTO Table_Node VALUES(18,'DataProcess','0x19','C','BWLWD1101023RED','2.2.99')
INSERT INTO Table_Node VALUES(19,'FSKModem','0x17','E','10094-01','1.2.585')
INSERT INTO Table_Node VALUES(20,'LWDMaster','0x14','B','10032-09','3.0.89')
INSERT INTO Table_Node VALUES(21,'MWD','0x13','D','10060-09','3.3.76')
INSERT INTO Table_Node VALUES(22,'Memory1','0x11','B','10058-02','1.1.86')
INSERT INTO Table_Node VALUES(23,'TEST','TEST','TEST','TEST','TEST')
INSERT INTO Table_NodeCascade VALUES(1,'MWD','[MWD[12号]]',1,1)
INSERT INTO Table_NodeCascade VALUES(2,'Resistivity','12号',1,1)
INSERT INTO Table_NodeCascade VALUES(3,'Gama','12号',1,1)
INSERT INTO Table_NodeCascade VALUES(4,'BWPV','12号',1,1)
INSERT INTO Table_NodeCascade VALUES(5,'Memory1','Memory1',1,2)
INSERT INTO Table_NodeCascade VALUES(6,'MWD','MWD',1,2)
INSERT INTO Table_NodeCascade VALUES(7,'LWDMaster','LWDMaster',1,2)
INSERT INTO Table_NodeCascade VALUES(8,'FSKModem','FSKModem',1,2)
INSERT INTO Table_NodeCascade VALUES(9,'DataProcess','DataProcess',2,2)
INSERT INTO Table_NodeCascade VALUES(10,'Memory2','Memory2',2,2)
INSERT INTO Table_NodeCascade VALUES(11,'Gama','Gama',3,2)
INSERT INTO Table_NodeCascade VALUES(12,'PressVib','PressVib',4,2)
INSERT INTO Table_NodeCascade VALUES(13,'FSKModem','FSKModem',3,2)
INSERT INTO Table_NodeCascade VALUES(14,'FSKModem','FSKModem',4,2)
INSERT INTO Table_NodeCascade VALUES(15,'Address','0x11',5,3)
INSERT INTO Table_NodeCascade VALUES(16,'PCB Version','C',5,3)
INSERT INTO Table_NodeCascade VALUES(17,'Seril#','100026-012',5,3)
INSERT INTO Table_NodeCascade VALUES(18,'FireWare','1.1.00293',5,3)
INSERT INTO Table_NodeCascade VALUES(19,'Address','0x11',6,3)
INSERT INTO Table_NodeCascade VALUES(20,'PCB Version','C',6,3)
INSERT INTO Table_NodeCascade VALUES(21,'Seril#','100026-012',6,3)
INSERT INTO Table_NodeCascade VALUES(22,'FireWare','1.1.00293',6,3)
INSERT INTO Table_NodeCascade VALUES(23,'Address','0x11',7,3)
INSERT INTO Table_NodeCascade VALUES(24,'PCB Version','D',7,3)
INSERT INTO Table_NodeCascade VALUES(25,'Seril#','100026-012',7,3)
INSERT INTO Table_NodeCascade VALUES(26,'FireWare','1.1.00293',7,3)
INSERT INTO Table_NodeCascade VALUES(27,'Address','0x11',8,3)
INSERT INTO Table_NodeCascade VALUES(28,'Address','0x11',9,3)
INSERT INTO Table_NodeCascade VALUES(29,'Address','0x11',10,3)
INSERT INTO Table_NodeCascade VALUES(30,'Address','0x11',11,3)
INSERT INTO Table_NodeCascade VALUES(31,'Address','0x11',12,3)
INSERT INTO Table_NodeCascade VALUES(32,'Address','0x11',13,3)
INSERT INTO Table_NodeCascade VALUES(33,'Address','0x11',14,3)
INSERT INTO Table_NodeCascade VALUES(35,'PCB Version','D',8,3)
INSERT INTO Table_NodeCascade VALUES(36,'PCB Version','D',9,3)
INSERT INTO Table_NodeCascade VALUES(37,'PCB Version','D',10,3)
INSERT INTO Table_NodeCascade VALUES(38,'PCB Version','D',11,3)
INSERT INTO Table_NodeCascade VALUES(39,'PCB Version','D',12,3)
INSERT INTO Table_NodeCascade VALUES(40,'PCB Version','D',13,3)
INSERT INTO Table_NodeCascade VALUES(41,'PCB Version','D',14,3)
INSERT INTO Table_NodeCascade VALUES(42,'Seril#','100026-012',8,3)
INSERT INTO Table_NodeCascade VALUES(43,'Seril#','100026-012',9,3)
INSERT INTO Table_NodeCascade VALUES(44,'Seril#','100026-012',10,3)
INSERT INTO Table_NodeCascade VALUES(45,'Seril#','100026-012',11,3)
INSERT INTO Table_NodeCascade VALUES(46,'Seril#','100026-012',12,3)
INSERT INTO Table_NodeCascade VALUES(47,'Seril#','100026-012',13,3)
INSERT INTO Table_NodeCascade VALUES(48,'Seril#','100026-012',14,3)
INSERT INTO Table_NodeCascade VALUES(49,'FireWare','1.1.00293',8,3)
INSERT INTO Table_NodeCascade VALUES(50,'FireWare','1.1.00293',9,3)
INSERT INTO Table_NodeCascade VALUES(51,'FireWare','1.1.00293',10,3)
INSERT INTO Table_NodeCascade VALUES(52,'FireWare','1.1.00293',11,3)
INSERT INTO Table_NodeCascade VALUES(53,'FireWare','NULL1.1.00293',12,3)
INSERT INTO Table_NodeCascade VALUES(54,'FireWare','1.1.00293',13,3)
INSERT INTO Table_NodeCascade VALUES(55,'FireWare','1.1.00293',14,3)
INSERT INTO Table_NodeCascade VALUES(57,'FSKModem','FSKModem',2,2)
INSERT INTO Table_NodeCascade VALUES(58,'Address','0x11',57,3)
INSERT INTO Table_NodeCascade VALUES(59,'PCB Version','D',57,3)
INSERT INTO Table_NodeCascade VALUES(60,'Seril#','100026-012',57,3)
INSERT INTO Table_NodeCascade VALUES(62,'FireWare','1.1.00293',57,3)
INSERT INTO Table_NodeCascade VALUES(63,'MWD','24#',2,1)
INSERT INTO Table_NodeCascade VALUES(64,'Resistivity','24#',2,1)
INSERT INTO Table_NodeCascade VALUES(65,'Gama','24#####',2,1)
INSERT INTO Table_NodeCascade VALUES(66,'MWD','MWD',63,2)
INSERT INTO Table_NodeCascade VALUES(67,'LWDMaster','LWDMaster',63,2)
INSERT INTO Table_NodeCascade VALUES(68,'Memory1','Memory1',63,2)
INSERT INTO Table_NodeCascade VALUES(69,'FSKModem','FAKModem',63,2)
INSERT INTO Table_NodeCascade VALUES(70,'Address','[Address[0x12]]',66,3)
INSERT INTO Table_NodeCascade VALUES(71,'PCB Version','C',66,3)
INSERT INTO Table_NodeCascade VALUES(72,'Seril#','100026-012',66,3)
INSERT INTO Table_NodeCascade VALUES(73,'FireWare','1.1.00293',66,3)
INSERT INTO Table_NodeCascade VALUES(92,'Address','sd',63,2)
INSERT INTO Table_NodeCascade VALUES(96,'PCB Version','df',65,2)
INSERT INTO Table_NodeCascade VALUES(97,'BWPV','12',2,1)
INSERT INTO Table_NodeCascade VALUES(102,'MWD','[MWD[[12-PXX]]]',11,1)
INSERT INTO Table_Resistivity VALUES(1,'1',1,1,1,1)
INSERT INTO Table_Stock VALUES(2,'垫圈','34-f','研究所',22,35,12.3)
INSERT INTO Table_Stock VALUES(3,'12','34-f','34-f',12,22,122.4)
INSERT INTO Table_Stock VALUES(4,'21','21','22',34343,21,122.4)
INSERT INTO Table_Stock VALUES(5,'21','212','21',21,21,122.4)
INSERT INTO Table_Stock VALUES(8,'21','21','2',21,21,122.4)
INSERT INTO Table_Stock VALUES(9,'21','21','21',21,21,122.4)
INSERT INTO Table_Stock VALUES(10,'21','21','21',32,321,122.4)
INSERT INTO Table_Stock VALUES(11,'21','21','21',21,21,122.4)
INSERT INTO Table_Stock VALUES(12,'21','12','21',21,21,122.4)
INSERT INTO Table_Stock VALUES(13,'21','21','21',12,2,122.4)
INSERT INTO Table_Stock VALUES(14,'21','21','1',21,2,122.4)
INSERT INTO Table_Stock VALUES(15,'21','21','21',21,21,122.4)
INSERT INTO Table_Stock VALUES(19,'21','21','21',21,21,122.4)
INSERT INTO Table_Stock VALUES(20,'21','21','21',21,21,122.4)
INSERT INTO Table_Stock VALUES(22,'21','21','2143',432,324,122.4)
INSERT INTO Table_Stock VALUES(23,'压缩环','24','22',21,12,null)
INSERT INTO Table_WellInfo VALUES(1,'杜84-冷家323','杜84','这口井不好打啊')
INSERT INTO Table_WellInfo VALUES(2,'梅-23','吉林','这口井有点深啊')
INSERT INTO Table_WellInfo VALUES(3,'沈采234','沈阳','。。。')
INSERT INTO Table_WellInfo VALUES(4,'12','12','12')
INSERT INTO Table_WellInfo VALUES(5,'13','13','13')
INSERT INTO Table_WellInfo VALUES(6,'14','14','14')
INSERT INTO Table_WellInfo VALUES(7,'15','15','15')
INSERT INTO Table_WellInfo VALUES(8,'16','16','16')
INSERT INTO Table_WellInfo VALUES(9,'17','17','17')
INSERT INTO Table_WellInfo VALUES(10,'18','18','18')
INSERT INTO Table_WellInfo VALUES(11,'20','20','20')
INSERT INTO Table_WellInfo VALUES(12,'21','21','21')
INSERT INTO Table_WellInfo VALUES(13,'22','22','22')
INSERT INTO Table_WellInfo VALUES(14,'23','23','23')
INSERT INTO Table_WellInfo VALUES(15,'24','24','24')
INSERT INTO Table_WellInfo VALUES(16,'25','25','25')
INSERT INTO Table_WellInfo VALUES(17,'26','26','26')
INSERT INTO Table_WellInfo VALUES(18,'27','27','27')
INSERT INTO Table_WellInfo VALUES(19,'28','28','28')
INSERT INTO Table_WellInfo VALUES(20,'29','29','29')
INSERT INTO Table_WellInfo VALUES(21,'30','30','30')
INSERT INTO Table_WellInfo VALUES(22,'31','31','31')
INSERT INTO Table_WellInfo VALUES(23,'32','32','32')
INSERT INTO Table_WellInfo VALUES(24,'33','33','33')
INSERT INTO Table_WellInfo VALUES(26,'34','34','34')
- 利用DataBaseMetaData和ResultSetMetaData复制数据库的表和数据
- ResultSetMetaData 和DatabaseMetaData的用法
- 使用DatabaseMetaData和ResultSetMetaData查看数据库信息
- JDBC: ResultSetMetaData和DatabaseMetaData
- ResultSetMetaData和DatabaseMetaData
- ResultSetMetaData和DatabaseMetaData
- ResultSetMetaData和DatabaseMetaData用法简介(转)
- JDBC利用DatabaseMetaData,ResultSetMetaData获取数据库连接信息,数据库信息,表信息
- 三大元数据--DatabaseMetaData，ParameterMetaData，ResultSetMetaData
- 学习ResultSetMetaData、DatabaseMetaData的知识
- ResultSetMetaData 、DatabaseMetaData中的方法的介绍
- DatabaseMetaData和ResultSetMeta的使用
- DatabaseMetaData获取数据库信息和表信息(表的列名,类型,主键等)SQL java
- ResultSetMetaData类与DatabaseMetaData类操作元数据
- JDBC:MetaData(ResultSetMetaData、DataBaseMetaData)
- 数据库表数据和表结构复制
- DatabaseMetaData ResultSet ResultSetMetaData三种类型的区别
- DatabaseMetaData，ResultSet，ResultSetMetaData三种类型的区别
- Python-层次聚类-Hierarchical clustering
- Xamarion.IOS UIImage图片的裁剪缩放等
- iOS 自带定位服务
- 研究生数学建模大赛参赛经验
- 关于sharePreference的数据Demo
- 利用DataBaseMetaData和ResultSetMetaData复制数据库的表和数据
- Android网络请求框架：Volley简单使用
- C++运算符重载
- 解决Plugin is too old,please update to a more recent version,or set ANDROID_DAILY_OVERRIDE..
- jvm钩子：Java应用中使用ShutdownHook友好地清理现场
- Android 之WebView+ProgressBar 完美结合
- Javascript单元测试框架Qunit和Jasmine的比较
- /var/run/yum.pid 已被锁定 解决办法
- Nginx Load Balancing
