 |
|
|
 首页 |
名片设计 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()); } } } 返回类别: 教程 上一教程: 初学JSP心得 下一教程: JSP连接各类数据库大全SQL SERVER2000 JDBC驱动的完整安装及测试 您可以阅读与"在JAVA中连接SYBASE数据库(例子)"相关的教程: · 在JAVA中连接Sybase数据库(例子) · 在JAVA中连接Oracle数据库(例子) · 在JAVA中连接ORACLE数据库(例子) · JAVA连接SYBASE数据库 · [分享]eclipse 3.0 中jre设置的小错误导致在java文件中连接数据库失败 |
  |
| 快精灵印艺坊 版权所有 |
首页 会员中心在线印刷在线编辑付款方式索取样品设计指南连锁门店
|
||
