龙盟编程博客 | 无障碍搜索 | 云盘搜索神器
快速搜索
主页 > 软件开发 > JAVA开发 >

在JAVA中连接Sybase数据库(例子)

时间:2009-12-23 15:42来源:未知 作者:admin 点击:
分享到:
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 sybaseD

  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)+"  ");
  }
  
  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());
  }
  
  }
  
  }
  
精彩图集

赞助商链接