 |
|
|
 首页 |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
package person.fane.test; /* * 创建日期 2005-7-15 * created by Fane */ import java.sql.*; /** * A JDBC test application for Sybase * @author Fane * @version 1.0.0 * @since JDK1.4 */ public class SybaseTest { private final String sybaseDriverName = \"com.sybase.jdbc3.jdbc.SybDriver\"; private final String sybaseUrlToConnect =\"jdbc:sybase:Tds:192.168.0.201:7543/cpemyy?charset=cp850&jconnect_version=3\"; private Connection myConnection = null; /** * To load the jdbc driver * */ public SybaseTest() { try { Class.forName(sybaseDriverName); }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(sybaseUrlToConnect,\"sa\",\"\"); }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) { SybaseTest mySybaseTest = new SybaseTest(); try { Connection myConnection = mySybaseTest.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(1)+\" \"); myStringBuffer.append(myResultSet.getString(2)+\" \"); myStringBuffer.append(myResultSet.getString(3)+\" \"); myStringBuffer.append(myResultSet.getString(4)+\" \"); myStringBuffer.append(myResultSet.getInt(5)+\" \"); myStringBuffer.append(myResultSet.getInt(6)+\" /n\"); } System.out.println(new String(myStringBuffer.toString().getBytes(\"ISO-8859-1\"),\"GBK\")); }catch(Exception ex) { System.out.println(mySybaseTest.getErrorMessage(ex,\"Application error,please contact to your Software Designer!\").toString()); } } } 返回类别: 教程 上一教程: Java核心编程：卷I??学习小记 下一教程: Acme包中的以Post方法发送数据的例子。 您可以阅读与"在JAVA中连接Sybase数据库(例子)"相关的教程: · 在JAVA中连接SYBASE数据库(例子) · 在JAVA中连接Oracle数据库(例子) · 在JAVA中连接ORACLE数据库(例子) · 关于JAVA中连接各类数据库的代码及其补充说明 · JAVA连接SYBASE数据库 |
  |
| 快精灵印艺坊 版权所有 |
首页 会员中心在线印刷在线编辑付款方式索取样品设计指南连锁门店
|
||
