【IT168 技术文档】在JAVA中连接Sybase数据库
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("selectarea_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,"Applicationerror,please contact to your Software Designer!").toString()); } } }