 |
|
|
 首页 |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
* 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()); } } } 返回类别: 教程 上一教程: java中访问数据库操作 下一教程: Java核心编程：卷I??学习小记 您可以阅读与"在JAVA中连接Oracle数据库(例子)"相关的教程: · 在JAVA中连接ORACLE数据库(例子) · 在JAVA中连接Sybase数据库(例子) · 在JAVA中连接SYBASE数据库(例子) · java连接Oracle数据库 · Java 实现连接sql server 2000（JDBC数据库访问例子） |
  |
| 快精灵印艺坊 版权所有 |
首页 会员中心在线印刷在线编辑付款方式索取样品设计指南连锁门店
|
||
