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;
            }
        }

解决方案 »

  1.   

    主要是如何用java实现datatable的功能
      

  2.   

    java中好像没有DataTable和DataSet的功能吧? 好像只能返回一个IList或者List<>列表了
      

  3.   

    java 不懂期待懂JAVA 的解决
    帮你顶
      

  4.   

    好像java有resultset这个类的,和DataSet差不多啦!
      

  5.   

    回 ls,那如何实现datatable的功能呢 ?
      

  6.   

    java一般用的都是hibernate链接数据库
    没有datatable功能,最多就是有个实体类,勉强有个dataRow的功能,
    想要datatable就是实例化一个实体类的列表
      

  7.   

    还是看看hibernate吧
    这个是java里的ado.net
      

  8.   

    import java.sql.*;public class TestDB { /**
     * @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);
            }
    }}