sybasecontest.java

农业银行ATM对帐查询系统后台类包的源代码,实现了FTP,数据库管理等等功能

package boco.shabank.dbmanager;

import java.sql.*;
import java.util.*;
import com.sybase.jdbc2.jdbc.SybDriver;
public class SybaseConTest{
    ChineseTransfer ct = new ChineseTransfer();
  String url =" jdbc:sybase:Tds:196.168.1.132:4333/apdb";
  public SybaseConTest(){
  try{
    Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance() ;
    //tsdata为你的数据库名
    Properties SysProps = System.getProperties();
    SysProps.put("user","apdbo");
    SysProps.put("password","apdbop");
    Connection conn= DriverManager.getConnection(url, SysProps);
    Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
    String sql="select * from abisrespcode order by abisrespcode              ";
    ResultSet rs=stmt.executeQuery(sql);
    ResultSetMetaData rsmd=rs.getMetaData();
    int ColNums = rsmd.getColumnCount();
    for(int i=0;i<ColNums;i++){
        System.out.println(rsmd.getColumnName(i+1)) ;
        System.out.println("type=="+ rsmd.getColumnTypeName(i+1));
    }
    System.out.println("column=="+ColNums) ;
    while(rs.next()) {
      System.out.println("您的第一个字段内容为:"+rs.getString(1));
      System.out.println("您的第3个字段内容为:"+ct.AsciiToChineseString(rs.getString(3)));
    }
    System.out.print("数据库操作成功，恭喜你");
    rs.close();
    stmt.close();
    conn.close();
    }
    catch(Exception ex){
      System.out.print(ex.getMessage()) ;
    }
  }
   public static void main(String arg[]){
    new SybaseConTest();
   }
}