简单地java链接oracle数据库
import java.sql.Connection;import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* 链接数据库的类
* @author Administrator
*
*/
public class DBUtil {
private static Connection conn = null;//链接
private static String url ="jdbc:oracle:" + "thin:@127.0.0.1:1521:orcl";// 127.0.0.1是本机地址，XE是精简版Oracle的默认数据库名
//使用的Scott账户，密码设置为root 其中在实验中给了scott用户dba权限
private static String user = "scott";
private static String password = "root";
public static Connection getConn(){
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}// 加载Oracle驱动程序
try {
conn = DriverManager.getConnection(url, user, password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}// 获取连接
return conn;
}
}
页:
[1]