高灵活的ＳＱＬ使用

csdn

佚名

2008-7-1

保存本文

推荐给好友

收藏本页

欢迎进入Java社区论坛，与200万技术人员互动交流 >>进入

/**
* @return执行sql语句(Insert、pdate、delete)
*/
public void execMySQL(String inSQL) throws SQLException {
  sql = inSQL;
  util = new DBManager();
  conn = util.getConn();
  conn.setAutoCommit(false); // .setAutoCommit(false);
  try {
   util.getStmt().execute(sql);
   conn.commit();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   conn.rollback();
   e.printStackTrace();
  }
  util.close();
 } 
/**
* @return执行sql语句(select)
*/

public MyTable execMySQLSelect2(String inSQL) {
  MyFunc func = new MyFunc();
  sql = inSQL;
  //list = new ArrayList();
  util = new DBManager();
  MyTable kfse = new MyTable();
  String s;
  int type;
  int iValue;
  List rows = new ArrayList();
  Integer itg = new Integer(0);
  BigDecimal ftg = new BigDecimal(0.0);
  java.sql.Date date;
  try {
   rs = util.getStmt().executeQuery(sql);
   ResultSetMetaData rsmd = rs.getMetaData();//可用于获取关于 ResultSet 对象中列的类型和属性信息的对象
   String[] cols = new String[rsmd.getColumnCount()];//rsmd.getColumnCount()返回此 ResultSet 对象中的列数
   String[] colsType = new String[rsmd.getColumnCount()];
   for (int i = cols.length; i > 0; i--) {
    cols[i - 1] = rsmd.getColumnName(i);//rsmd.getColumnName(i)获取指定列的名称
    colsType[i - 1] = String.valueOf(rsmd.getColumnType(i));//rsmd.getColumnType(i)检索指定列的 SQL 类型
   }
   if (rs != null) {
    while (rs.next()) {
     Object[] row = new Object[cols.length];
     rows.add(row);
     for (int i = cols.length; i > 0; i--) {
      //row[i - 1] = rs.getString(cols[i - 1]);
      type = rsmd.getColumnType(i);
      //row[i - 1] = String.valueOf(type);
      switch (type) {//type数值参照java.sql.types
       case 1 :
        row[i - 1] = rs.getString(cols[i - 1]);
        break;
       case 2 :
        ftg = new BigDecimal(0.0);
        if (rs.getBigDecimal(cols[i - 1]) != null)
         ftg = rs.getBigDecimal(cols[i - 1]);

        row[i - 1] = ftg;
        break;
       case 3 :
        ftg = new BigDecimal(0.0);
        if (rs.getBigDecimal(cols[i - 1]) != null)
         ftg = rs.getBigDecimal(cols[i - 1]);

        row[i - 1] = ftg;
        break;
       case 4 : //对u24212 数u25454 库u23383 段NTEGER//ok
        itg = new Integer(rs.getInt(cols[i - 1]));
        row[i - 1] = itg;
        break;
       case 5 :
        itg = new Integer(rs.getInt(cols[i - 1]));
        row[i - 1] = itg;
        break;
       case 6 :
        ftg = new BigDecimal(0.0);
        if (rs.getBigDecimal(cols[i - 1]) != null)
         ftg = rs.getBigDecimal(cols[i - 1]);

[1] [2] 下一页

【责编:landy】