java 连接sybase数据库_Jdbc连Sybase数据库的几种方法_MySQL

SybaseJDBC

1.单用一个JSP文件测试SYBASE jconnect-5_2 JDBC数据库接口：

JSP测试SYBASE jconnect-5_2 JDBC数据库接口

JSP测试SYBASE jconnect-5_2 JDBC数据库接口

Class.forName("com.sybase.jdbc2.jdbc.SybDriver");

String url ="jdbc:sybase:Tds:localhost:2638";

Connection conn= DriverManager.getConnection(url, "dba","sql");

Statement stmt=conn.createStatement();

String sql="select emp_lname,dept_id,street,city,state from employee order by emp_lname";

ResultSet rs=stmt.executeQuery(sql);

while(rs.next()) {

out.print("

"+rs.getString("emp_lname")+"");

out.print(""+rs.getString("dept_id")+"");

out.print(""+rs.getString("street")+"");

out.print(""+rs.getString("city")+