Posted on 2006-06-14 15:03
氧氣中毒 閱讀(279)
評論(0) 編輯 收藏 所屬分類:
數據處理
/**/
/*
?*?創建日期?2006-6-13
?*
?*?java連接oracle數據庫
?
*/
package
?person.fane.test;
import
?java.sql.
*
;
/**?*/
/**
?*?A?JDBC?test?application?for?Oracle
?*?
@author
?Fane
?*?
@version
?1.0.0
?*?
@since
?JDK1.4
?
*/
public
?
class
?OracleTest?
{
????
private
?
final
?String?oracleDriverName?
=
?
"
oracle.jdbc.driver.OracleDriver
"
;
????
????
//
以下使用的Test就是Oracle里的表空間
????
private
?
final
?String?oracleUrlToConnect?
=
"
jdbc:oracle:thin:@192.168.0.36:1521:Test
"
;?
????
private
?Connection?myConnection?
=
?
null
;
????
/**?*/
/**
?????*?To?load?the?jdbc?driver
?????*?
?????
*/
????
public
?OracleTest()
????
{
????????
try
????????
{
????????????Class.forName(oracleDriverName);
????????}
catch
(ClassNotFoundException?ex)
????????
{
????????????System.out.println(getErrorMessage(ex,
"
The?Driver?loaded?error,please?contact?to?your?Software?Designer!
"
).toString());
????????}
????}
????
????
public
?StringBuffer?getErrorMessage(Exception?ex,String?alarmMessage)
????
{
????????StringBuffer?errorStringBuffer?
=
?
new
?StringBuffer();
????????errorStringBuffer.append(alarmMessage);
????????errorStringBuffer.append(ex.getMessage());
????????
return
?errorStringBuffer;
????}
????
????
/**?*/
/**
?????*?getConnection?method?
?????*?
@return
?Connection
?????
*/
????
public
?Connection?getConnection()
????
{
????????
try
????????
{
????????????
this
.myConnection?
=
?DriverManager.getConnection(oracleUrlToConnect,
"
Fane
"
,
"
201
"
);
????????????
????????}
catch
(Exception?ex)
????????
{
????????????System.out.println(getErrorMessage(ex,
"
Can?not?get?connection,please?contact?to?your?Software?Designer!
"
).toString());
????????}
????????
????????
return
?
this
.myConnection;
????????
????}
????
????
/**?*/
/**
?????*?
@param
?args
?????
*/
????
public
?
static
?
void
?main(String[]?args)?
{
????????OracleTest?myOracleTest?
=
?
new
?OracleTest();
????????
try
????????
{
????????????Connection?myConnection?
=
?myOracleTest.getConnection();
????????????System.out.println(
"
Now?begin?to?excute.
"
);
????????
????????????PreparedStatement?myPreparedStatement?
=
?myConnection.prepareStatement(
"
select?area_id,?area_name,ip_address,tel,area_type,pc_id?from?c_area_info
"
);
????????????
//
myPreparedStatement.setInt(1,2);
????????????ResultSet?myResultSet?
=
?myPreparedStatement.executeQuery();
????????????StringBuffer?myStringBuffer?
=
?
new
?StringBuffer();
????????????
????????????
while
(myResultSet.next())
????????????
{
????????????????
????????????????myStringBuffer.append(myResultSet.getInt(
"
area_id
"
)
+
"
??
"
);
????????????????myStringBuffer.append(myResultSet.getString(
"
area_name
"
)
+
"
??
"
);
????????????????myStringBuffer.append(myResultSet.getString(
"
ip_address
"
)
+
"
??
"
);
????????????????myStringBuffer.append(myResultSet.getString(
"
tel
"
)
+
"
??
"
);
????????????????myStringBuffer.append(myResultSet.getInt(
"
area_type
"
)
+
"
??
"
);
????????????????myStringBuffer.append(myResultSet.getInt(
"
pc_id
"
)
+
"
\n
"
);
????????????}
????????????System.out.println(myStringBuffer.toString());
????????????
//
System.out.println(new?String(myStringBuffer.toString().getBytes("ISO-8859-1"),"GBK"));
????????}
catch
(Exception?ex)
????????
{
????????????System.out.println(myOracleTest.getErrorMessage(ex,
"
Application?error,please?contact?to?your?Software?Designer!
"
).toString());
????????}
????}
}