public DataTable ExecDataTable(String SqlStr,string ResuleName)
{
string dbType = System.Configuration.ConfigurationSettings.AppSettings["DateBaseType"];
//获取数据库类型
DataSet QueryResult;
if (dbType == "informix")
{
OdbcConnection dbConnection_ifx;
OdbcDataAdapter dbDataAdapter_ifx; dbConnection_ifx = m_Connection_ifx;
QueryResult = new DataSet();
dbDataAdapter_ifx = new OdbcDataAdapter(SqlStr, dbConnection_ifx);
dbDataAdapter_ifx.Fill(QueryResult, ResuleName);
return QueryResult.Tables[ResuleName];
}
else
{
OleDbConnection dbConnection_orc;
OleDbDataAdapter dbDataAdapter_orc; dbConnection_orc = m_Connection_orc;
QueryResult = new DataSet();
dbDataAdapter_orc = new OleDbDataAdapter(SqlStr, dbConnection_orc);
dbDataAdapter_orc.Fill(QueryResult, ResuleName);
return QueryResult.Tables[ResuleName];
}
}
public DataSet ExecDataSet(String SqlStr,String tablename)
{
string dbType = System.Configuration.ConfigurationSettings.AppSettings["DateBaseType"]; //获取数据库类型
DataSet QueryResult; if (dbType == "informix")
{
OdbcConnection dbConnection_ifx;
OdbcDataAdapter dbDataAdapter_ifx; dbConnection_ifx = m_Connection_ifx;
QueryResult = new DataSet();
dbDataAdapter_ifx = new OdbcDataAdapter(SqlStr, dbConnection_ifx);
dbDataAdapter_ifx.Fill(QueryResult, tablename);
return QueryResult;
}
else
{
OleDbConnection dbConnection_orc;
OleDbDataAdapter dbDataAdapter_orc; dbConnection_orc = m_Connection_orc;
QueryResult = new DataSet();
dbDataAdapter_orc = new OleDbDataAdapter(SqlStr, dbConnection_orc);
dbDataAdapter_orc.Fill(QueryResult, tablename);
return QueryResult;
}
}
{
string dbType = System.Configuration.ConfigurationSettings.AppSettings["DateBaseType"];
//获取数据库类型
DataSet QueryResult;
if (dbType == "informix")
{
OdbcConnection dbConnection_ifx;
OdbcDataAdapter dbDataAdapter_ifx; dbConnection_ifx = m_Connection_ifx;
QueryResult = new DataSet();
dbDataAdapter_ifx = new OdbcDataAdapter(SqlStr, dbConnection_ifx);
dbDataAdapter_ifx.Fill(QueryResult, ResuleName);
return QueryResult.Tables[ResuleName];
}
else
{
OleDbConnection dbConnection_orc;
OleDbDataAdapter dbDataAdapter_orc; dbConnection_orc = m_Connection_orc;
QueryResult = new DataSet();
dbDataAdapter_orc = new OleDbDataAdapter(SqlStr, dbConnection_orc);
dbDataAdapter_orc.Fill(QueryResult, ResuleName);
return QueryResult.Tables[ResuleName];
}
}
public DataSet ExecDataSet(String SqlStr,String tablename)
{
string dbType = System.Configuration.ConfigurationSettings.AppSettings["DateBaseType"]; //获取数据库类型
DataSet QueryResult; if (dbType == "informix")
{
OdbcConnection dbConnection_ifx;
OdbcDataAdapter dbDataAdapter_ifx; dbConnection_ifx = m_Connection_ifx;
QueryResult = new DataSet();
dbDataAdapter_ifx = new OdbcDataAdapter(SqlStr, dbConnection_ifx);
dbDataAdapter_ifx.Fill(QueryResult, tablename);
return QueryResult;
}
else
{
OleDbConnection dbConnection_orc;
OleDbDataAdapter dbDataAdapter_orc; dbConnection_orc = m_Connection_orc;
QueryResult = new DataSet();
dbDataAdapter_orc = new OleDbDataAdapter(SqlStr, dbConnection_orc);
dbDataAdapter_orc.Fill(QueryResult, tablename);
return QueryResult;
}
}
帮你顶
没有datatable功能,最多就是有个实体类,勉强有个dataRow的功能,
想要datatable就是实例化一个实体类的列表
这个是java里的ado.net
* @param args
*/
public static void main(String[] args) {
// TODO 自動生成されたメソッド・スタブ
Connection con;
//SQL文
Statement sql;
//Proc
CallableStatement stmt ;
ResultSet rs;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(ClassNotFoundException e)
{
System.out.print(""+e);
}
try{
con = DriverManager.getConnection("jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL", "Uname","PassWord");
sql = con.createStatement();
//有返回值Proc
stmt = conn.prepareCall("{? = call procName}");
stmt.execute(); rs = sql.executeQuery("select * from chengjibiao");
while(rs.next())
{
String number = rs.getString(1);
String name = rs.getString(2);
String date = rs.getString(3);
int math = rs.getInt("math");
int english = rs.getInt("english");
System.out.print("学号: "+number);
System.out.print(" 名前: "+name);
System.out.print(" 出生: "+date);
System.out.print(" 数学: "+math);
System.out.print(" 英語: "+english);
}
con.close();
}
catch(SQLException e)
{
System.out.print(e);
}
}}