package gov.hebjs.test;

import gov.hebjs.base.conn;
import gov.hebjs.base.linkdb;
import java.sql.ResultSet;
import java.sql.*;
import java.util.Vector;

/**
 * <p>Title: 测试两个数据库连接</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright  2003</p>
 * <p>Company: </p>
 * @author 网辉
 * @version 1.0
 */

public class testnw {

  public testnw() {
  }

  public conn db = new conn();
  public linkdb mdb=new linkdb();
  public int addout(String name) {

    String sql = "insert into jst(id,name)valuse(seq_jst.nextval,'" + name +
        "')";
    db.close();
    return db.executeUpdate(sql);
  }

  public void tongbu(String tablename) {
    String ziduanname = null;
    String insertsql = "";

    String myvalue = "";
    int tablenum = 0;
    try {
      String sql = "select * from " + tablename;
      ResultSet rstableid = db.executeQuery(sql);
      ResultSetMetaData rsmd = rstableid.getMetaData();
      tablenum = rsmd.getColumnCount();

      for (int i = 1; i <= tablenum; i++) {
        ziduanname = rsmd.getColumnLabel;
        if (i == 1) {
          insertsql += ziduanname + "";
        }
        else {
          insertsql += "," + ziduanname + "";
        }

      }
      insertsql = "insert into " + tablename + " (" + insertsql + ") values(";

      while (rstableid.next()) {
        String insertsql2 = "";
        String insertsql3 = "";
        for (int j = 1; j <= tablenum; j++) {
          Object myvalues = rstableid.getObject(j);
          if (myvalues != null) {
            myvalue = myvalues.toString();
          }
          else {
            myvalue = "";
          }
          int type = rsmd.getColumnType(j);
          if (j == 1) {
            insertsql2 += myvalue;
          }
          else {
            if (type == 2) {
              insertsql2 += "," + myvalue;
            }
            if (type == 12) {
              insertsql2 += ",'" + myvalue + "'";
            }
          }

        }
        insertsql3 = insertsql + insertsql2 + ")";
     mdb.executeUpdate(insertsql3);

      }

    }
    catch (Exception ex1) {

    }

  }
}