I didn't find the problem you said.
This is the test application:package beans;
import java.sql.*;
import java.math.*;
public class TestConn { public static void main(String[] args) { try {
DriverManager.registerDriver(
new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:@192.168.0.15:1521:ec",
"intranet", "intranet"); // Statement stmt = conn.createStatement();
// Statement stmt = conn.createStatement(
// ResultSet.TYPE_SCROLL_INSENSITIVE,
// ResultSet.CONCUR_UPDATABLE);
// ResultSet rs = stmt.executeQuery("select subject from jivemessage");
PreparedStatement pstmt = conn.prepareStatement("select subject from jivemessage",
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
String subject = rs.getString(1);
System.out.println(subject);
}
}
catch (SQLException se) {
}
}
}
This is the test application:package beans;
import java.sql.*;
import java.math.*;
public class TestConn { public static void main(String[] args) { try {
DriverManager.registerDriver(
new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:@192.168.0.15:1521:ec",
"intranet", "intranet"); // Statement stmt = conn.createStatement();
// Statement stmt = conn.createStatement(
// ResultSet.TYPE_SCROLL_INSENSITIVE,
// ResultSet.CONCUR_UPDATABLE);
// ResultSet rs = stmt.executeQuery("select subject from jivemessage");
PreparedStatement pstmt = conn.prepareStatement("select subject from jivemessage",
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
String subject = rs.getString(1);
System.out.println(subject);
}
}
catch (SQLException se) {
}
}
}
解决方案 »
- IO包中 字符串的问题
- 如何得到当前web应用中有多少session?每个session都有那些属性?
- 谁能帮忙做个用AWT做个界面啊。。。
- 各位大侠:在Dos命令行中能够运行applet吗?
- 请问 怎么把帖子保存下来
- 兄弟们给我一个用eclipse开发的数据库应用程序的例子,我的EMAIL:是[email protected]
- 谁有Eclipse的源代码?下载路径?
- 请问怎么做ServerSocket+Socket在一个文件里面呢??
- 小弟想写一个能繁简转换的WEB程序,但现手头上没任何资料,谁能提供???35分!小弟现在比较穷,只有35!
- 一些关于static modifier 的说明,我有点迷惑,请那位师兄给指点一下!
- to needle(),我还个问题!
- JAVA中如何使用剪贴板
pstm1.setString(1, ny);
rs1 = pstm1.executeQuery();
//
e1 = (mat.getLines()).elements();
while (e1.hasMoreElements()) {
i = 0;
rs1.first();
// rs1
while (rs1.next()) {
yt2 = rs1.getString("ytdwbm");
System.out.println(yt2);
}
}
}
pstm1.close();