package com.kaxi.info.common;
import java.lang.*;
import java.sql.*;
import java.util.*;
import com.kaxi.info.dbconn.*;public class ExecuteSQL{
public ExecuteSQL(){
}
/**
*@ strSQL ÒªÖ´ÐеÄSQLÓï¾ä£»
*@ flag Çø·ÖÖ´Ðвéѯʱ flag = true;½øÐвåÈë¡¢¸üÐÂʱflag = flase;
**/
public ArrayList executeSQL(String strSQL,boolean flag){
try{
DbTrans DBSQL = new DbTrans();
ResultSet rs = null;
ArrayList rsVct = new ArrayList();
if(flag==true){
rs = DBSQL.executeQuery(strSQL);
ResultSetMetaData rsmd=rs.getMetaData();
int nColumns=rsmd.getColumnCount();
while(rs.next()){
for(int i=1;i<=nColumns;i++){
rsVct.add(rs.getObject(i));
}
}
return rsVct;
}else{
DBSQL.executeUpdate(strSQL);
return ;
}
}catch(SQLException e){
System.err.println(e.getMessage());
}
}
}
import java.lang.*;
import java.sql.*;
import java.util.*;
import com.kaxi.info.dbconn.*;public class ExecuteSQL{
public ExecuteSQL(){
}
/**
*@ strSQL ÒªÖ´ÐеÄSQLÓï¾ä£»
*@ flag Çø·ÖÖ´Ðвéѯʱ flag = true;½øÐвåÈë¡¢¸üÐÂʱflag = flase;
**/
public ArrayList executeSQL(String strSQL,boolean flag){
try{
DbTrans DBSQL = new DbTrans();
ResultSet rs = null;
ArrayList rsVct = new ArrayList();
if(flag==true){
rs = DBSQL.executeQuery(strSQL);
ResultSetMetaData rsmd=rs.getMetaData();
int nColumns=rsmd.getColumnCount();
while(rs.next()){
for(int i=1;i<=nColumns;i++){
rsVct.add(rs.getObject(i));
}
}
return rsVct;
}else{
DBSQL.executeUpdate(strSQL);
return ;
}
}catch(SQLException e){
System.err.println(e.getMessage());
}
}
}
public class Product
{
public Product(id,name)
{
}
private String id;
private String name;
String getId(){}
setId(){}
String getname(){}
setName(){}
} Arraylist arraylist = new Arraylist();
arraylist.add(new Product("1001","televison"));
import java.lang.*;
import java.sql.*;
import java.util.*;
import com.kaxi.info.dbconn.*;
import com.kaxi.info.common.Product;public class ExecuteSQL{
public ExecuteSQL(){
}
/**
*@ strSQL ÒªÖ´ÐеÄSQLÓï¾ä£»
*@ flag Çø·ÖÖ´Ðвéѯʱ flag = true;½øÐвåÈë¡¢¸üÐÂʱflag = flase;
**/
public ArrayList executeSQL(String strSQL,boolean flag){
try{
DbTrans DBSQL = new DbTrans();
ResultSet rs = null;
ArrayList aList = new ArrayList();
if(flag==true){
rs = DBSQL.executeQuery(strSQL);
while(rs.next()){
Product prc = new Product();
prc.id = rs.getString(1);
prc.name = rs.getString(2);
aList.add(prc);
}
return aList;
}else{
DBSQL.executeUpdate(strSQL);
}
rs.close();
}catch(SQLException e){
System.err.println(e.getMessage());
}
}
}