在JAVA中连接Oracle数据库
2024年03月06日
/**TODO要更改此生成的文件的模板,请转至
*窗口-首选项-Java-代码样式-代码模板
*/
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());
}
}