 |
|
|
 首页 |
名片设计 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()); } } } 返回类别: 教程 上一教程: JSP教程(七)-PLUGINACTION的使用 下一教程: 用正则表达式判定一个简朴的用户登陆的例子 您可以阅读与"在JAVA中连接ORACLE数据库(例子)"相关的教程: · 在JAVA中连接Oracle数据库(例子) · 在JAVA中连接SYBASE数据库(例子) · 在JAVA中连接Sybase数据库(例子) · 关于JAVA中连接各类数据库的代码及其补充说明 · java连接Oracle数据库 |
  |
| 快精灵印艺坊 版权所有 |
首页 会员中心在线印刷在线编辑付款方式索取样品设计指南连锁门店
|
||
