Posted on 2006-06-14 15:03
氧气中毒 阅读(287)
评论(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());
}
}
}