如何用JAVA实现读取ORACLE 中的Long类型字段啊?有简单的例子吗?大家帮帮忙吧
解决方案 »
- 求解答
- swing中的getCellRendererComponent为什么会调用两遍
- 关于RandomAccessFile的read(c, 0, 5)方法的疑问,请帮忙!
- 分享一本不错的书<<The Definitive Guide to Java Swing Edition Third Edition>>
- 帮我看看这个例子!
- 用GUI怎么样才能实现幻动片的效果?
- 奇怪的事,设置了CLASSPATH,还是找不到类
- thinking in java英文版啊,请问那里有的下载??急急急!!谢谢了
- 求教URL转码问题
- 请实现一个函数用来判断字符串是否表示数值(包括整数和小数)
- 如何把项目打包生成exe文件?
- 问个arraylist用clone方法的问题
* 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();
}}