sybaseASE安装使用手册.doc

一、Sybase ASE 15.0.3 开发版安装1、解压CD - ASE 15.0.3 Product for Windows x86 - 32bit2、进入目录CD - ASE 15.0.3 Product for Windows x86 - 32bit，点击setup.exe 3、点击下一步 4、点击下一步默认安装在C盘可以更改安装目录 5、点击下一步选择自定义安装6、选择上ASE ODBC 和ASE OLEDB 点击下一步7、点击下一步按如下选择8、点击下一步 9、点击下一步根据自己需要选择10、点击下一步11、点击下一步12、点击下一步13、点击下一步14、点击下一步 15、选择下一步16、安装完成 二、安装启动问题参考1、 数据库服务不能启动1 网络问题ip地址或端口被占有（默认5000） 2、 启动后自动停止问题 启动后自动停止查看本机上其他软件是否阻止了服务例如（安全卫士不要选择系统服务）三、创建数据库。1、创建设备2、创建数据库3、选择设备四、数据库连接1 平台连接配置 jdbc.driver=com.sybase.jdbc3.jdbc.SybDataSourcejdbc.url=jdbc:sybase:Tds:02:5000/cms2 必须是ip地址 不能用localhost Sybase不支持 jdbc.dialect=org.hibernate.dialect.SybaseDialectjdbc.username=sajdbc.passwd=jdbc.max.active=3jdbc.show.hql=true 2、sybase官网提供/*Programmer: Ali Chalhoub Date: Feb. 25, 2000 Purpose: This small application establish a connection to an ASA6.x database. It requires the IP address and the database name. If IP address is not giving then the default will take place that is localhost. IP can be the name of the server machine or the IP number. i.e java JConnect ServerName Databasename */import com.sybase.jdbc.*;import java.sql.*;/import java.io.*;/import java.util.*;/import java.util.Properties;/import sybase.sql.*;public class JConnectpublic static void main(String argv) try /setting the connection driver.System.out.println(Connecting.);String databaseName=;String ipAddress=;/databaseName = argv1; /set the database nameClass.forName(com.sybase.jdbc.SybDriver).newInstance(); if (argv.length 2) ipAddress = localhost; databaseName= argv0; /display ip address. System.out.println(IP used : +ipAddress); else ipAddress = argv0; databaseName=argv1; /display ip address. System.out.println(IP used : +ipAddress); testConnection(databaseName,ipAddress);/System.out.println(Connected Successfully); catch( Exception e)System.out.println(e.getMessage(); /printing out an error if so. public static void testConnection(String dbName,String ipad)throws SQLExceptiontry/connecting to the database using port 2638; Database name = Lab1Connection conn=DriverManager.getConnection(jdbc:sybase:Tds:+ipad+:2638?ServiceName=+dbName,dba,sql);System.out.println(Connected successfully to +dbName+ database using JConnect); catch(Exception e) System.out.println(error: + e.getMessage(); e.printStackTrace(); 2、import java.sql.Statement;import java.util.Properties;import com.sybase.jdbcx.SybDriver;public class SybaseT /* *sybase 数据库连接测试 * 刘金宝 * 2009-3-10 */ public static void main(String args) try SybDriver sybDriver = (SybDriver) Class.forName (com.sybase.jdbc2.jdbc.SybDriver).newInstance(); sybDriver.setVersion (com.sybase.jdbcx.SybDriver.VERSION_5); DriverManager.registerDriver(sybDriver); /Class.forName(com.sybase.jdbcx.SybDriver).newInstance(); catch (InstantiationException e) / TODO 自动生成 catch 块 e.printStackTrace(); catch (IllegalAccessException e) / TODO 自动生成 catch 块 e.printStackTrace(); catch (ClassNotFoundException e) / TODO 自动生成 catch 块 e.printStackTrace(); catch (SQLException e) / TODO 自动生成 catch 块 e.printStackTrace(); String url = jdbc:sybase:Tds:0:5000/oa; Properties sysProps = System.getProperties(); sysProps.put(user,sa); sysProps.put(password,); try Connection conn= DriverManager.getConnection(url, sysProps); Statement stmt = null; stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(select * from users); System.out.println(); catch (SQLException e) e.printStackTrace(); Jsp 源码 % /以try开始 try Connection con; Statement stmt; ResultSet rs; /加载驱动程序，下面的代码为加载JDBD-ODBC驱动程序 Class.forName(com.sybase.jdbc.SybDriver).newInstance(); String url=jdbc:sybase:Tds:0:5000/oa; /oa为数据库名字 /建立连接，类似于ASP中的创建数据库联接 con= DriverManager.getConnection(url, sa,); stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); /创建一个JDBC声明 String strSql=; strSql=select * from users ; rs = stmt.executeQuery(strSql); /输出查询结果 out.println(); out.println(); out.println(+ID+); out.println(+名字+); out.println(+密码+); out.println(+角色+); out.println(); int n=0; while (rs.next() int id = rs.getInt(id); String name =getStr(rs.getString(NAME); String pass = getStr(rs.getString(password); int roleid = rs.getInt(roleid); /打印所显示的数据 out.println(); out.println(+id+); out.println(+name+); out.println(+pass+); out.println(+roleid+); out.println(); n=n+1;