java连接oracle
Connection conn = null;
Class.forName("oracle.jdbc.driver.OracleDriver");//加入oracle的驱动，“”里面是驱动的路径
String url = "jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL";// 数据库连接，oracle代表链接的是oracle数据库；thin:@MyDbComputerNameOrIP代表的是数据库所在的IP地址（可以保留thin:）；1521代表链接数据库的端口号；ORCL代表的是数据库名称
String UserName = "root";// 数据库用户登陆名 ( 也有说是 schema 名字的 )
String Password = "2006";// 密码
conn = DriverManager.getConnection(url， UserName， Password);
2. 怎样使用java 连接oracle数据库
Connection conn = null;
Class.forName("oracle.jdbc.driver.OracleDriver");//加入oracle的驱动，“”里面是驱动的路径
String url = "jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL";
/*数据库连接，oracle代表链接的是oracle数据库；thin:@MyDbComputerNameOrIP代表的是数据库所在的IP地址（可以保留thin:）；1521代表链接数据库的端口号；ORCL代表的是数据库名称*/
String UserName = "root";// 数据库用户登陆名 ( 也有说是 schema 名字的 )
String Password = "2006";// 密码
conn = DriverManager.getConnection(url, UserName, Password);
3. 怎么用Java连接oracle数据库
public class OracleJdbcTest
{
String driverClass = "oracle.jdbc.driver.OracleDriver";
Connection con;
public void init(FileInputStream fs) throws Exception
{
Properties props = new Properties();
props.load(fs);
String url = props.getProperty("db.url");
String userName = props.getProperty("db.user");
String password = props.getProperty("db.password");
Class.forName(driverClass);
con=DriverManager.getConnection(url, userName, password);
}
public void fetch() throws sqlException, IOException
{
PreparedStatement ps = con.prepareStatement("select SYSDATE from al");
ResultSet rs = ps.executeQuery();
while (rs.next())
{
// do the thing you do
}
rs.close();
ps.close();
}
public static void main(String[] args)
{
OracleJdbcTest test = new OracleJdbcTest();
test.init();
test.fetch();
}
}
[代码] db.properties
db.url = jdbc:oracle:thin:@<hostname>:<port>:<sid>
db.user = sa
db.password =
4. java与oracle要怎样连接
JDBC啊，六大步，
String url = "jdbc:oracle:thin:@localhost:1521:XE";//固定的，照着写就行
String username = "system";//oracle用户名
String pwd = "123";//oracle密码
String sql = "select sum(cost) from orders where userid = ? and orderstatusid = 3";
String sql2 = "select * from vidmember where id = ?";
/*
* 根据id查找出该人消费的总金额。
* */
public int MoneyfindById(int id) {
int a = 0;
Connection conn = null;
PreparedStatement pst = null;
ResultSet rs = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(url, username, pwd);
pst = conn.prepareStatement(sql);
pst.setInt(1,id);
rs = pst.executeQuery();
if(rs.next()){
a = rs.getInt("sum(cost)");
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return a;
}
5. 怎么实现用java访问oracle数据库
用JDBC啊,
首先去oracle网站下个java连接oracle的驱动,www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc9201.html
代码列子:
import java.sql.*;
public class TestDBOracle {
public static void main(String[] args)
throws ClassNotFoundException, SQLException
{
Class.forName("oracle.jdbc.driver.OracleDriver");
//
// or
// DriverManager.registerDriver
// (new oracle.jdbc.driver.OracleDriver());
String url = "jdbc:oracle:thin:@//server.local:1521/prod";
// jdbc:oracle:thin:@//host:port/service
// or
// String url = "jdbc:oracle:thin:@server.local:1521:prodsid";
// jdbc:oracle:thin:@host:port:SID
Connection conn =
DriverManager.getConnection(url,"scott", "tiger");
conn.setAutoCommit(false);
Statement stmt = conn.createStatement();
ResultSet rset =
stmt.executeQuery("select BANNER from SYS.V_$VERSION");
while (rset.next()) {
System.out.println (rset.getString(1));
}
stmt.close();
System.out.println ("Ok.");
}
}
6. 谁教我怎么用java连 oracle数据库
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());//Class.forname("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl"; //127.0.0.1是安装有Oracle实例的机器IP,当然这里也可以写机器名,1521是Oracle的端口号,应该没人在安装时会改吧,orcl是数据库实例名
Connection conn = DriverManager.getConnection(url,"scott","tiger");
提示:看自己的机器名,在cmd窗口下输入hostname,看机器的IP,则输入ipconfig
这种连接方式用的比较多,是"瘦"连接方式,可以跨机器访问非本地的Oracle实例,
还有一种连接方式叫做"胖"连接方式,只能连接本地的Oracle实例,前提是本地安装了的Oracle实例.用的比较少,开发中也不常用.
7. 怎么用java连接oracle数据库，需要详细解释
1)首先你要有java连接oracle数据库的驱动类,下载好后导入到工程里
2)代码:
import java.sql.*;
public class JDBCTest {
/**
* @param args
* @throws ClassNotFoundException
*/
public static void main(String[] args)
throws ClassNotFoundException, SQLException{
//1.准备参数
String ip = "192.168.0.26";
String sid = "tarena";
String port = "1521";
String dbUser = "openlab";
String dbPassword = "open123";
String driver
= "oracle.jdbc.driver.OracleDriver";
//2.构造驱动实例
Class.forName(driver);
//3.创建连接
//连接字符串是固定的形式,oracle的形式:
String url
= "jdbc:oracle:thin:@"
+ ip + ":" + port + ":" + sid;
Connection conn
= DriverManager.getConnection
(url, dbUser, dbPassword);
//4.执行SQL语句
String sql = "select id, password, name from user_sd1104 " +
"where id = 1001 and password = '1234'";
Statement stmt = conn.createStatement();
ResultSet rs
= stmt.executeQuery(sql);//执行sql语句
while(rs.next()){
int id = rs.getInt(1);
String pwd = rs.getString(2);
String name = rs.getString(3);
System.out.println("welcome," + name);
}
rs.close();
stmt.close();
conn.close();
}
}
8. java jdbc连接oracle数据库步骤
跟连接mysql一样的；
如果java类连接，网上搜索一个连接代码即可，若是controller，在里面写上
spring.datasource.secondary.jdbc-url=
spring.datasource.secondary.username=
spring.datasource.secondary.password=
oracle同理
9. 求Java 连接Oracle数据库有哪几种方式
Sys，它是一个 DBA用户名，具有最大的数据库操作权限，sys 必须以sysdba的身份登录；
System，它也是一个 DBA用户名，权限仅次于 Sys用户，system 以正常身份登录，具有一般操作权限！
DBSNMP 该用户负责Oracle系统的智能代理（Intelligent Agent），该用户的缺省密码也是“DBSNMP”。它具有一个比较危险的系统权限" unlimited tablespace
SYSMAN oracle超级管理员！