?? parentbean.java
字號:
String field = "";
String value = "";
String type = "";
for(int i=1;i<vect.size();i++)
{
//對某一個字段
Vector v_t = (Vector)vect.get(i);
field = (String)v_t.get(0);
value = (String)v_t.get(1);
if (value.indexOf("'")!=-1)
{
value = value.replaceAll("'","''");
}
type = (String)v_t.get(2);
//組合字段SQL
if(sqlField.equals(""))sqlField = " (";
else sqlField = sqlField + ",";
sqlField = sqlField + field;
//組合值SQL
if(sqlValue.equals(""))sqlValue = "(";
else sqlValue = sqlValue + ",";
if(value.equals(""))//為空時
{
sqlValue = sqlValue + "null";
}
else if(type.equals("CHAR"))//字符串
{
sqlValue = sqlValue + "'" + value + "'";
}
else if(type.equals("NUM"))//數值
{
sqlValue = sqlValue + value;
}
else if(type.equals("TIME"))//日期
{
sqlValue = sqlValue + "to_date('yyyy-MM-dd HH:mm:ss','" + value + "')";
}
else if(type.equals("CLOB"))//clob類型
{
sqlValue = sqlValue + "empty_clob()";
}
else if(type.equals("BLOB"))//blob類型
{
sqlValue = sqlValue + "empty_blob()";
}
}
sqlField = sqlField + ")";
sqlValue = sqlValue + ")";
String sql = "insert into " + (String)vect.get(0) + sqlField + " values" + sqlValue;
return db.ExecuteSQL(sql);
}
/**修改記錄*/
protected int updateRecord(Vector vect)
{
/**Vector:第1項 表名(String)
// 第2項 列名(Vector[Field(String),Value(String,CLOB,BLOB),Type("CHAR","NUM","TIME","CLOB","BLOB")])
// 第3項 條件(String sql)*/
//臨時變量
String sqlSet = "";//形如(Name='name',ID=9)
String field = "";
String value = "";
String type = "";
int i = 1;
int n = vect.size();
for(;i<(n-1);i++)
{
//對某一個字段
Vector v_t = (Vector)vect.get(i);
field = (String)v_t.get(0);
value = (String)v_t.get(1);
if (value.indexOf("'")!=-1)
{
value = value.replaceAll("'","''");
}
type = (String)v_t.get(2);
//組合字段SQL
if(sqlSet.equals(""))sqlSet = " ";
else sqlSet = sqlSet + ",";
sqlSet = sqlSet + field + "=";
if(value.equals("")&&type.equals("NUM"))//為空時
{
sqlSet = sqlSet + "null";
}
if(type.equals("CHAR"))//字符串
{
sqlSet = sqlSet + "'" + value + "'";
}
else if(type.equals("NUM"))//數值
{
sqlSet = sqlSet + value;
}
else if(type.equals("TIME"))//日期
{
sqlSet = sqlSet + "to_date('yyyy-MM-dd HH:mm:ss','" + value + "')";
}
else if(type.equals("CLOB"))//clob類型
{
}
else if(type.equals("BLOB"))//blob類型
{
}
}
String sql = "update " + (String)vect.get(0) + " set " + sqlSet;
String sqlWhere = (String)vect.get(vect.size()-1);
if(!sqlWhere.equals(""))
{
sql = sql + " where " + sqlWhere;
}
return db.ExecuteSQL(sql);
}
/**刪除記錄*/
protected int deleteRecord(String sql)
{
return db.ExecuteSQL(sql);
}
/**執行語句*/
protected int executeUpdate(String sql)
{
return db.ExecuteSQL(sql);
}
/**產生唯一編號*/
public int makeID(String table,String field1,String field2,String value1,boolean type1)
{
return db.makeID(table,field1,field2,value1,type1);
}
public int makeID(String table,String field1,String field2,String field3,String value1,String value2,boolean type1,boolean type2)
{
return db.makeID(table,field1,field2,field3,value1,value2,type1,type2);
}
public int makeID_Add1(String table,String field1,String field2,String value1,boolean type1)
{
return db.makeID(table,field1,field2,value1,type1);
}
public int makeID_Add1(String table,String field1,String field2,String field3,String value1,String value2,boolean type1,boolean type2)
{
return db.makeID(table,field1,field2,field3,value1,value2,type1,type2);
}
/**將名稱轉換為編號*/
public int toID(String table,String field1,String field2,String value1)
{
return db.toID(table,field1,field2,value1);
}
/**將編號轉換為名稱*/
public String toName(String table,String field1,String field2,String value1)
{
return db.toName(table,field1,field2,value1);
}
/**寫數據庫時某一個字段的存儲類型*/
protected Vector addVector(String field,String value,String type)
{
Vector vect = new Vector();
vect.add(field);
vect.add(value);
vect.add(type);
return vect;
}
/**分頁時取得一頁的數據量*/
public Vector getOnePage(String sql,int page,int records)
{
return db.getOnePage(sql,page,records);
}
/**為某一個字段進行重新排序*/
public int setSort(String table,String field1,String field2,String wherestr,String orderstr,boolean b)
{
return db.setSort(table,field1,field2,wherestr,orderstr,b);
}
/**查詢CLOB類型值*/
public String QueryCLOB(String table,String wherestr,String clobfield)
{
return db.QueryCLOB(table,wherestr,clobfield);
}
/**修改CLOB類型值*/
public int UpdateCLOB(String table,String wherestr,String clobfield,String clobvalue)
{
return db.UpdateCLOB(table,wherestr,clobfield,clobvalue);
}
/**查詢BLOB類型值*/
public String QueryBLOB(String table,String wherestr,String blobfield)
{
return db.QueryBLOB(table,wherestr,blobfield);
}
/**修改BLOB類型值*/
public int UpdateBLOB(String table,String wherestr,String blobfield,String blobvalue)
{
return db.UpdateBLOB(table,wherestr,blobfield,blobvalue);
}
/**查詢BLOB類型值*/
public String QueryBLOB_JNDI(String table,String wherestr,String blobfield)
{
return db.QueryBLOB_JNDI(table,wherestr,blobfield);
}
/**修改BLOB類型值*/
public int UpdateBLOB_JNDI(String table,String wherestr,String blobfield,String blobvalue)
{
return db.UpdateBLOB_JNDI(table,wherestr,blobfield,blobvalue);
}
/**數據庫信息*/
public Hashtable getDataBaseInfo()
{
return db.getDataBaseInfo();
}
/**數據表列表*/
public Vector getTableList()
{
return db.getTableList();
}
/**數據表的結構*/
public Vector getTableStruct(String table)
{
return db.getTableStruct(table);
}
/**取得數據集內容*/
public Vector getResultSetData(ResultSet rs)
{
return db.getResultSetData(rs);
}
/**創建申明對象*/
public void prepareStatement(String sql)
{
db.prepareStatement(sql);
}
/**執行查詢*/
public void executeQuery()
{
db.executeQuery();
}
/**轉向下一條*/
public boolean next()
{
return db.next();
}
/**取得數據并根據數據類型轉化為字符串*/
public String getObject(String field,String sqlType)
{
return db.getObject(field,sqlType);
}
/**根據數據類型保存到數據庫*/
public void setObject(int index,String value,String sqlType)
{
db.setObject(index,value,sqlType);
}
/**執行更新*/
public void executeUpdate()
{
db.executeUpdate();
}
/**關閉申明對象*/
public void closePstm()
{
db.closePstm();
}
/**關閉游標*/
public void closeRs()
{
db.closeRs();
}
public static void main(String args[]) throws Exception
{
ParentBean mb = new ParentBean();
System.out.println("begin\r\n\r\n");
//修改方法
//Vector vect = new Vector();
//vect.add("test");
////vect.add(mb.addVector("ID","100","NUM"));
//vect.add(mb.addVector("NAME","libohua","CHAR"));
//vect.add("");
//System.out.println(mb.updateRecord(vect));
//新增方法
//vect.clear();
////vect.add(mb.addVector("ID","100","NUM"));
//vect.add(mb.addVector("NAME","libohua","CHAR"));
//vect.add("");
//System.out.println(mb.insertRecord(vect));
//分頁方法
//System.out.println(mb.getOnePage("select * from css",2,3));
System.out.println(mb.FilesPath);
System.out.println("\r\n\r\nend");
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -