amaze ui 案例:JAVA 如何和ORACLE相连

来源:百度文库 编辑:高校问答 时间:2024/04/28 06:45:10

好好看看JDBC的相关知识就明白了,这方面的东西多的是
下面是一个代码:

import java.sql.*;

public class ConnOracle {
String serverName = "localhost";
String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin:@"+serverName+":1521:ora";
Connection connect = null;
ResultSet rs = null;

public ConnOracle() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println( e.getMessage());
}
}

public ResultSet query(String sql) {
try {
connect = DriverManager.getConnection(sConnStr, "scott", "tiger");
Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
}

public int update(String sql) {
int result = 0;
try {
connect = DriverManager.getConnection(sConnStr, "scott", "tiger");
Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
result = stmt.executeUpdate(sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return result;
}

}

先去下ORACLE的驱动程序,然后在用JDBC连接
具体看看JDBC的知识就知道了

java中有JDBC啊