import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;import javax.swing.JButton;
import javax.swing.JFrame;public class Main extends JFrame{
JButton jb = new JButton();
static ResultSet rs = null;
static Statement stmt = null;
static Connection conn = null;
public Main(){
this.setTitle("Test");
this.setBounds(200, 200, 400, 200);
this.setLayout(null);
jb.setText("OK");
jb.setBounds(100, 100, 60, 30);
jb.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e) {
call();
}
});
this.add(jb);
this.setVisible(true);
}
public void call(){
try{
String id = rs.getString("EXAMID");
String name = rs.getString("NAME");
int age = rs.getInt("AGE");
System.out.println(id + ": " + name + " " + age);
}catch(Exception ex){
ex.printStackTrace();
}
}
public static void main(String[] args) {
try {
new Main();
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@127.0.0.1:1521:XE", "sa", "sa");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery("select * from SYS.STUBINFOX");
rs.next();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}上面的代码用来测试TYPE_SCROLL_SENSITIVE参数,我修改数据库以后,再点击一下按钮,可是打印出来的没有改变,不是说TYPE_SCROLL_SENSITIVE对修改是敏感的吗?昨天晚上在家测试连接ACCESS(家里机器装不了Oracle),结果恰好相反,无论是TYPE_SCROLL_SENSITIVE参数还是TYPE_SCROLL_INSENSITIVE都敏感,只要数据库一修改,打印的结果马上就跟着修改。完全没有头绪,请教给予支持!!!谢谢!!!!!!
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;import javax.swing.JButton;
import javax.swing.JFrame;public class Main extends JFrame{
JButton jb = new JButton();
static ResultSet rs = null;
static Statement stmt = null;
static Connection conn = null;
public Main(){
this.setTitle("Test");
this.setBounds(200, 200, 400, 200);
this.setLayout(null);
jb.setText("OK");
jb.setBounds(100, 100, 60, 30);
jb.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e) {
call();
}
});
this.add(jb);
this.setVisible(true);
}
public void call(){
try{
String id = rs.getString("EXAMID");
String name = rs.getString("NAME");
int age = rs.getInt("AGE");
System.out.println(id + ": " + name + " " + age);
}catch(Exception ex){
ex.printStackTrace();
}
}
public static void main(String[] args) {
try {
new Main();
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@127.0.0.1:1521:XE", "sa", "sa");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery("select * from SYS.STUBINFOX");
rs.next();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}上面的代码用来测试TYPE_SCROLL_SENSITIVE参数,我修改数据库以后,再点击一下按钮,可是打印出来的没有改变,不是说TYPE_SCROLL_SENSITIVE对修改是敏感的吗?昨天晚上在家测试连接ACCESS(家里机器装不了Oracle),结果恰好相反,无论是TYPE_SCROLL_SENSITIVE参数还是TYPE_SCROLL_INSENSITIVE都敏感,只要数据库一修改,打印的结果马上就跟着修改。完全没有头绪,请教给予支持!!!谢谢!!!!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货