急啊,,,求助oracle 中读取Long类型字段

Question

如何用JAVA实现读取ORACLE 中的Long类型字段啊?有简单的例子吗?大家帮帮忙吧

Answer 1

/**
 * ChangeCode.java
 * 修改tb_sys_codeitem表的c_typecode字段
 *
 *  <code>
 *  <p>Created on 2005-12-2 13:09:57</p>
 *  <p>By  lonely bug </p>
 *  </code>
 */import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;public class ChangeCode {
       
       public static void main(String[] args) throws Exception{               Class.forName("oracle.jdbc.driver.OracleDriver");
               Connection Conn = DriverManager.getConnection(
                               "jdbc:oracle:thin:@192.168.29.253:1521:oradb", "lonelybug", "lonelybug");
               Statement stmtSel = Conn.createStatement();
               ResultSet rs = stmtSel.executeQuery("select * from A");
               while (rs.next()) {
                       String oldCode = rs.getString("CODE");
                       long id = rs.getLong("ID");
                       Statement stmtUpd = Conn.createStatement();
                       StringBuffer sql = new StringBuffer(
                                       "update A set CODE = '");
                       sql.append("CODE_").append(oldCode).append("' where ID = ")
                                       .append(id);
                       stmtUpd.executeQuery(sql.toString());
                       stmtUpd.close();
               }
               rs.close();
               stmtSel.close();
               Conn.close();
       }}