TRIP数据库的JDBC

TRIP数据库的JDBC ,代码如下：

欢迎关注本人公众号进行交流：

GetKnowledge+

 package com.dareway.seftrain.trip.compare;import java.io.BufferedOutputStream;import java.io.File;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.IOException;import java.util.ArrayList;import java.util.HashMap;import java.util.List;import java.util.Map;import com.tietoenator.trip.jxp.TdbException;import com.tietoenator.trip.jxp.TdbFieldType;import com.tietoenator.trip.jxp.TdbLanguage;import com.tietoenator.trip.jxp.control.TdbDatabaseList;import com.tietoenator.trip.jxp.data.TdbComponent;import com.tietoenator.trip.jxp.data.TdbField;import com.tietoenator.trip.jxp.data.TdbPhraseField;import com.tietoenator.trip.jxp.data.TdbRecord;import com.tietoenator.trip.jxp.data.TdbRecordSet;import com.tietoenator.trip.jxp.data.TdbTextField;import com.tietoenator.trip.jxp.database.TdbDatabaseDesign;import com.tietoenator.trip.jxp.database.TdbFieldDesign;import com.tietoenator.trip.jxp.pool.TdbConnectionPool;import com.tietoenator.trip.jxp.pool.TdbPooledSession;import com.tietoenator.trip.jxp.pool.TdbTripNetConnectionPool;import com.tietoenator.trip.jxp.session.TdbSession;/** * TRIP数据库操作工具类 * @author Leraing_LB * @version V1.2.0 * @最新修改时间   2016-12-17 */public class TripUtil {static TdbPooledSession session = null;static TdbConnectionPool pool = null;public static TdbConnectionPool Login(String ip,String port,String username,String pw) throws TdbException{pool=new TdbTripNetConnectionPool("127.0.0.1",23457, "system","z", TdbLanguage.English, 5);pool.setIdleTimeout(10);pool.setPurgeInterval(2);pool.setMinIdle(10);return pool;}//创建数据库,并添加字段/** * @param name ：数据库名字 * @param fName ：字段名 * @param fType ：对应字段类型 * @throws TdbException  * */public static void creatDB(String name,String fName [],String fType []) throws TdbException{try {//创建数据库session=Login(null, null, null, null).acquire();TdbDatabaseDesign db=new TdbDatabaseDesign(session);db.setBafFile(name+".BAF");db.setBifFile(name+".BIF");db.setVifFile(name+".VIF");//添加字段TdbFieldDesign field=new TdbFieldDesign();for (int i = 0; i < fType.length; i++) {field.setName(fName[i]);field.setType(fType[i]);db.addField(field);}db.put(name);System.out.println("创建数据库成功！");} catch (Exception e) {// TODO Auto-generated catch blockSystem.out.println("创建数据库失败！");}finally{session.logout();pool.close();}}//插入记录/** * @param dbName ：数据库名字 * @param fNa ：字段名 * @param val ：对应字段值 * @throws TdbException  * */public static int insert(String dbName,String [] fNa,String [] val ) throws TdbException{try {session=Login(null, null, null, null).acquire();TdbDatabaseDesign db=new TdbDatabaseDesign(session);db.get(dbName);TdbRecord rec=new TdbRecord(session, db, false);TdbComponent c=rec.getHead();for (int i = 0; i < val.length; i++) {TdbPhraseField naField= (TdbPhraseField) c.createField(fNa[i],c.getField(fNa[i]).getType());naField.appendValue(val[i]);}rec.commit();db.index();System.out.println("添加记录成功！");return 1;} catch (TdbException e) {System.out.println("添加记录失败！");return 0;}finally{session.logout();pool.close();}}//获取结果/** * @param dbName ：数据库名字 * @param tem ：字段名 * @throws TdbException  * */public static List<Map<String,Object>> getResult(String dbName,String [] tem) throws TdbException{List<Map<String,Object>> list=new ArrayList<Map<String,Object> >();try {TdbRecordSet rset=new TdbRecordSet(session);rset.setDatabase(dbName);rset.setQuerySQL(true);rset.setFrom(1);TdbRecord template=new TdbRecord(session);for (int i = 0; i < tem.length; i++) {template.addToTemplate(tem[i]);}rset.setRetrievalTemplate(template);rset.get();for (TdbRecord r : rset.records()) {Map<String,Object> map=new HashMap<String,Object>();map.put("id", r.getRecordId());for (TdbField field : r.getHead().fields())         {            map.put(field.getName(), field.toString());                  } list.add(map);}return list;} catch (TdbException e) {// TODO Auto-generated catch blocke.printStackTrace();return null;}finally{session.logout();pool.close();}}//修改记录/** * @param dbName ：数据库名字 * @param id ：记录号 * @param field :字段名 * @param val ：对应字段值 * @throws TdbException  * */public static  int update(String dbName,String id,String [] field,String [] val) throws TdbException{session=Login(null, null, null, null).acquire();try {TdbDatabaseDesign db=new TdbDatabaseDesign(session);db.get(dbName);TdbRecordSet rset=new TdbRecordSet(session);rset.setDatabase(dbName);TdbRecord rec=new TdbRecord(session, db, true);int r_id=Integer.parseInt(id);rec.setRecordId(r_id);rec.get();for (int i = 0; i < val.length; i++) {rec.getHead().getField(field[i]).setValue(0, val[i]);}rec.commit();db.index();System.out.println("修改记录成功！");return 1;} catch (TdbException e) {// TODO Auto-generated catch blockSystem.out.println("添加记录失败！");e.printStackTrace();return 0;}finally{session.logout();pool.close();}}//删除记录/*** *  * @param dbName :数据库名 * @param id ：记录号 * @return * @throws TdbException  */public static  int delete(String dbName,String id) throws TdbException{session=Login(null, null, null, null).acquire();try {TdbRecord rec=new TdbRecord(session);rec.setDatabaseName(dbName);rec.setRecordId(Integer.parseInt(id));rec.delete();TdbDatabaseDesign db = new TdbDatabaseDesign(session);db.get(dbName);db.reindex();System.out.println("删除记录成功！");return 1;} catch (TdbException e) {// TODO Auto-generated catch blockSystem.out.println("删除记录失败！");e.printStackTrace();return 0;}finally{session.logout();pool.close();}}/*** * @param 精确查找 * @param dbName 数据库名 * @param tem 想要获取的字段名称数组 * @param arg1 想要检索的字段 * @param arg2 想要检索的内容 * @return List集合 * @throws Exception  */public static List<Map<String,Object>> query(String dbName,String [] tem,String [] arg1,String []arg2) throws Exception{session=Login(null, null, null, null).acquire();List<Map<String,Object>> list=new ArrayList<Map<String,Object> >();try {TdbRecordSet rset=new TdbRecordSet(session);rset.setDatabase(dbName);rset.setQueryCCL(true);StringBuilder sb =new StringBuilder();sb.append("F  ");for (int i = 0; i < arg1.length; i++) {sb.append(arg1[i]+" =  '" +arg2[i]+"'  ");sb.append(" and ");}sb.append(" r = fr 1");sb.toString();System.out.println(sb.toString());rset.setQuery(sb.toString());rset.setFrom(1);TdbRecord template=new TdbRecord(session);for (int i = 0; i < tem.length; i++) {template.addToTemplate(tem[i]);}rset.setRetrievalTemplate(template);rset.get();for (TdbRecord r : rset.records()) {Map<String,Object> map=new HashMap<String,Object>();map.put("id", r.getRecordId());for (TdbField field : r.getHead().fields())         {            map.put(field.getName(), field.toString());                  } list.add(map);}return list;} catch (TdbException e) {// TODO Auto-generated catch blockthrow new Exception();}finally{session.logout();pool.close();}}/*** * @param 模糊查找 * @param dbName 数据库名 * @param tem 想要获取的字段名称数组 * @param arg1 想要检索的字段 * @param arg2 想要检索的内容 * @return List集合 * @throws TdbException  */public static List<Map<String,Object>> queryLike(String dbName,String [] tem,String [] arg1,String []arg2) throws TdbException{session=Login(null, null, null, null).acquire();List<Map<String,Object>> list=new ArrayList<Map<String,Object> >();try {TdbRecordSet rset=new TdbRecordSet(session);rset.setDatabase(dbName);rset.setQueryCCL(true);StringBuilder sb =new StringBuilder();sb.append("F  ");if(arg1!=null){for (int i = 0; i < arg1.length; i++) {if(arg2[i].length()>0){sb.append(arg1[i]+" =  " +arg2[i]+"  ");sb.append(" and ");}}}else{sb.append(" "+arg2[0]);}sb.append(" and  r = fr 1");sb.toString();System.out.println(sb.toString());rset.setQuery(sb.toString());rset.setFrom(1);TdbRecord template=new TdbRecord(session);for (int i = 0; i < tem.length; i++) {template.addToTemplate(tem[i]);}rset.setRetrievalTemplate(template);rset.get();for (TdbRecord r : rset.records()) {Map<String,Object> map=new HashMap<String,Object>();map.put("id", r.getRecordId());for (TdbField field : r.getHead().fields())         {            map.put(field.getName(), field.toString());                  } list.add(map);}session.logout();return list;} catch (TdbException e) {// TODO Auto-generated catch blockreturn null;}finally{session.logout();pool.close();}}/** * 文本抽取 * @param session * @param filename * @throws TdbException  */public static void wbcq(TdbSession ses,String filename) throws TdbException{try {session=Login(null, null, null, null).acquire();TdbDatabaseDesign db=new TdbDatabaseDesign(session);db.get("LWFJ");TdbRecord record = new TdbRecord(session, db, false);TdbComponent head = record.getHead();TdbPhraseField field1= (TdbPhraseField) head.createField("FILE_NAME", TdbFieldType.PhraseField);field1.appendValue(filename);TdbTextField field =(TdbTextField) head.createField("FILE_TEXT", TdbFieldType.TextField);field.getTextExtractionInfo().setExtractText(true);field.getTextExtractionInfo().setBinaryCopyField("FILE_BLOB");field.getTextExtractionInfo().setFileName(filename);File file= new File(filename);FileInputStream is=new FileInputStream(file);field.getTextExtractionInfo().setStream(is);field.getTextExtractionInfo().setPropertyNameField("PROP_NAME");field.getTextExtractionInfo().setPropertyValueField("PROP_VALUE");record.commit();is.close();db.index();//延迟5秒，留足抽取时间Thread.sleep(5000);} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{session.logout();pool.close();}}/** * 获取数据库的所有用户名 * @throws TdbException  */public static void getUser() throws TdbException{session=Login(null, null, null, null).acquire();try {TdbDatabaseList tdbList = new TdbDatabaseList(session);TdbDatabaseDesign db=new TdbDatabaseDesign(session);for (int i = 0; i < tdbList.size(); i++) {String DbName = tdbList.get(i).getName();db.get(DbName);for (int j = 0; j < db.getFieldCount(); j++) {}}} catch (TdbException e) {e.printStackTrace();}finally{session.logout();pool.close();}}/** * 获取数据库的所有用户名 * @throws TdbException  */public static void getUser1() throws TdbException{session=Login(null, null, null, null).acquire();try {TdbDatabaseList tdbList = new TdbDatabaseList(session);TdbDatabaseDesign db=new TdbDatabaseDesign(session);for (int i = 0; i < tdbList.size(); i++) {String DbName = tdbList.get(i).getName();db.get(DbName);}} catch (TdbException e) {e.printStackTrace();}finally{session.logout();pool.close();}}public static ArrayList<Map<String,Object>> getDbName(String DBname) throws TdbException{session  = pool.acquire();ArrayList<Map<String,Object>>list= new ArrayList<Map<String,Object>>();try {TdbDatabaseList tdbList = new TdbDatabaseList(session);for (int i = 0; i < tdbList.size(); i++) {Map<String,Object> map =new HashMap<String, Object>();if(DBname==null){map.put("DbName", tdbList.get(i).getName());map.put("OwnerName", tdbList.get(i).getOwnerName());map.put("LastModifiedDate", tdbList.get(i).getModifiedDate()+" "+tdbList.get(i).getModifiedTime());list.add(map);}else{if(tdbList.get(i).getName().toUpperCase().equals(DBname.toUpperCase())){map.put("DbName", tdbList.get(i).getName());map.put("OwnerName", tdbList.get(i).getOwnerName());map.put("LastModifiedDate", tdbList.get(i).getModifiedDate()+" "+tdbList.get(i).getModifiedTime());list.add(map);}}}} catch (TdbException e) {throw new  TdbException("获取数据库用户错误");}finally{session.logout();pool.close();}return list;}/** *  * @param dbName * @param tem * @param arg1 * @return * @throws TdbException */public static List<Map<String,Object>> queryData(String dbName,String [] tem,String  arg1) throws TdbException{session=Login(null, null, null, null).acquire();List<Map<String,Object>> list=new ArrayList<Map<String,Object> >();try {TdbRecordSet rset=new TdbRecordSet(session);rset.setDatabase(dbName);rset.setQueryCCL(true);rset.setQuery(arg1);rset.setFrom(1);TdbRecord template=new TdbRecord(session);for (int i = 0; i < tem.length; i++) {template.addToTemplate(tem[i]);}rset.setRetrievalTemplate(template);rset.get();for (TdbRecord r : rset.records()) {Map<String,Object> map=new HashMap<String,Object>();map.put("id", r.getRecordId());for (TdbField field : r.getHead().fields())         {            map.put(field.getName(), field.toString());                  } list.add(map);}session.logout();return list;} catch (TdbException e) {// TODO Auto-generated catch blockreturn null;}finally{session.logout();pool.close();}}public static String convertFileSize(long size) {    long kb = 1024;    long mb = kb * 1024;    long gb = mb * 1024;    if (size >= gb) {        return String.format("%.1f GB", (float) size / gb);    } else if (size >= mb) {        float f = (float) size / mb;        return String.format(f > 100 ? "%.0f MB" : "%.1f MB", f);    } else if (size >= kb) {        float f = (float) size / kb;        return String.format(f > 100 ? "%.0f KB" : "%.1f KB", f);    } else        return String.format("%d B", size);}public static void main(String[] args) throws Exception {}    /**      * 根据byte数组，生成文件      */      public static void getFile(byte[] bfile, String filePath,String fileName) {          BufferedOutputStream bos = null;          FileOutputStream fos = null;          File file = null;          try {              File dir = new File(filePath);             if(!dir.exists()&&dir.isDirectory()){//判断文件目录是否存在                dir.mkdirs();             }             file = new File(filePath+"\\"+fileName);             fos = new FileOutputStream(file);            bos = new BufferedOutputStream(fos);            bos.write(bfile);        } catch (Exception e) {             e.printStackTrace();         } finally {             if (bos != null) {                 try {                     bos.close();                 } catch (IOException e1) {                     e1.printStackTrace();                }             }             if (fos != null) {                 try {                     fos.close();                 } catch (IOException e1) {                     e1.printStackTrace();                 }             }         }     }  }