java 實現(xiàn) jdbc連接oracle 數(shù)據(jù)庫的java代碼怎么寫

package com.jdbc.test;

站在用戶的角度思考問題，與客戶深入溝通，找到新平網(wǎng)站設(shè)計與新平網(wǎng)站推廣的解決方案，憑借多年的經(jīng)驗，讓設(shè)計與互聯(lián)網(wǎng)技術(shù)結(jié)合，創(chuàng)造個性化、用戶體驗好的作品，建站類型包括：做網(wǎng)站、網(wǎng)站制作、企業(yè)官網(wǎng)、英文網(wǎng)站、手機(jī)端網(wǎng)站、網(wǎng)站推廣、主機(jī)域名、網(wǎng)站空間、企業(yè)郵箱。業(yè)務(wù)覆蓋新平地區(qū)。

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class JDBCTest {

public static void main(String[] args) throws Exception {

//1.加載驅(qū)動

//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

//Class.forName("com.mysql.jdbc.Driver");

Class.forName("oracle.jdbc.driver.OracleDriver");

//2.創(chuàng)建數(shù)據(jù)庫連接對象

//Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=db","sa","sqlpass");

//Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db?useUnicode=truecharacterEncoding=UTF-8","root","123456");

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","Oracle123");

//3.創(chuàng)建數(shù)據(jù)庫命令執(zhí)行對象

Statement stmt = conn.createStatement();

// PreparedStatement ps = conn.prepareStatement("select * from t_user");

//4.執(zhí)行數(shù)據(jù)庫命令

ResultSet rs = stmt.executeQuery("select * from t_user");

// ResultSet rs = ps.executeQuery();

//5.處理執(zhí)行結(jié)果

while (rs.next()) {

int id = rs.getInt("id");

String username = rs.getString("username");

String password = rs.getString("password");

System.out.println(id + "\t" + username + "\t" + password);

}

//6.釋放數(shù)據(jù)庫資源

if (rs != null) {

rs.close();

}

// if (ps != null) {

// ps.close();

// }

if (stmt != null) {

stmt.close();

}

if (conn != null) {

conn.close();

}

}

}

這是以前寫的3中數(shù)據(jù)庫的鏈接已經(jīng)測試過了。

oracle按條件進(jìn)行循環(huán)的代碼怎么編寫

begin

v_cnt number:=0;

loop

delete from a where rownum=100000;

v_cnt:=SQL%ROWCOUNT;

commit;

exit when v_cnt=0;

end loop;

end;

java 連接oracle rac c3p0代碼怎么寫

不是很懂你的意思

c3p0連接數(shù)據(jù)庫跟連接其他的數(shù)據(jù)庫是一樣的啊

配置數(shù)據(jù)源，綁定數(shù)據(jù)源，再就是與其他的框架整合的問題

數(shù)據(jù)源配置：

driverClass=oracle.jdbc.driver.OracleDriver

jdbcUrl=jdbc:oracle:thin:@localhost:1521:orcl

user=sys

password=sun123

c3p0配置：

!--?c3p0?--

bean?id="dataSource"?class="com.mchange.v2.c3p0.ComboPooledDataSource"

property?name="driverClass"?value="${driverClass}"/

property?name="jdbcUrl"?value="${jdbcUrl}"/property

property?name="user"?value="${user}"?/

property?name="password"?value="${password}"/

/bean

oracle數(shù)據(jù)庫求寫完整代碼

6

declare

s?int;

begin

s?:=?1;

for?s?in?1?..?100?loop

if?s?=?33?or?s?=?74?or?s?=?96?then

null;

else

dbms_output.put_line(s);

end?if;

end?loop;

end;

7沒看懂

8

declare

n?int;

s?int;

begin

n?:=?1;

s?:=?0;

for?n?in?1?..?100?loop

if?mod(n,?2)?=?1?then

s?:=?s?+?n;

else

null;

end?if;

end?loop;

dbms_output.put_line(s);

end;

SOS!!!怎樣寫連接ORACLE數(shù)據(jù)庫的代碼？

============ORACLE 8i============================

Class.forName ("oracle.jdbc.driver.OracleDriver");

Connection conn =

DriverManager.getConnection ("jdbc:oracle:thin:@myhost:1521:orcl",

"scott", "tiger");

=============MySQL=================================

Class.forName("org.gjt.mm.mysql.Driver").newInstance();

conn = DriverManager.getConnection("jdbc:mysql://myhost:3306/dbname","user","passwd");

============InfoMax================================

Class.forName("com.informix.jdbc.IfxDriver");

conn = DriverManager.getConnection("jdbc:informix-sqli://myhost:1533:informixserver=myserver;user=rdtest;password=test");

============InforMix================================

Class.forName("com.informix.jdbc.IfxDriver");

conn = DriverManager.getConnection("jdbc:informix-sqli://myhost:1533:informixserver=myserver;user=rdtest;password=test");

=============SQLServer2000=========================

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

Connection conn = DriverManager.getConnection

("jdbc:microsoft:sqlserver://server1:1433","username","password");

///////////////////////////////////

jdbc driver download:

SQLServer:

MySQL:

Oracle:

---------------------DB2--------------------

--------------------- --------------------

Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();//For Application

String url = "jdbc:db2:sample";

con = DriverManager.getConnection(url, userid, passwd);

Class.forName("COM.ibm.db2.jdbc.net.DB2Driver").newInstance();//For Applet

String url = "jdbc:db2:// "+server+":"+port+"/sample";

con = DriverManager.getConnection(url, userid, password );

補(bǔ)充oracle的連接方法：

DriverManager.registerDriver (new OracleDriver());

Connection conn73 = DriverManager.getConnection

("jdbc:oracle:oci8:@ora8idev","scott","tiger");

網(wǎng)站名稱：oracle代碼怎么寫,oracle教程 菜鳥教程
文章分享：http://www.chinadenli.net/article6/dseohig.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供外貿(mào)建站、電子商務(wù)、網(wǎng)站排名、App設(shè)計、虛擬主機(jī)、云服務(wù)器

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)