通过JDBC链接Sybase的方法

来源：互联网发布：新的淘宝店铺怎么装修编辑：程序博客网时间：2024/06/06 20:33

2种方法代码如下：

public void getConnection() {try {//String url ="jdbc:sybase:Tds:192.168.102.100:5000/test";//通过jdbc方式连接,test为数据库名String url = "jdbc:jtds:sybase://192.168.102.100:5000/test";//通过jtds方式连接，test为数据库名//Class.forName("com.sybase.jdbc3.jdbc.SybDriver").newInstance();//通过jdbc方式连接Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();//通过jtds方式连接Connection conn = DriverManager.getConnection(url, "sa", "");Statement stmt = conn.createStatement();String sql = "select * from bookinfo";ResultSet rs = stmt.executeQuery(sql);while (rs.next()) {System.out.println("id=" + rs.getString("id") + "；标题＝"+ rs.getString("title") + "；作者＝" + rs.getString("author")+ "<br/>");}try {rs.close();stmt.close();conn.close();} catch (Exception e) {System.out.println("数据库关闭出错");}} catch (InstantiationException e1) {e1.printStackTrace();} catch (IllegalAccessException e1) {e1.printStackTrace();} catch (ClassNotFoundException e1) {e1.printStackTrace();} catch (SQLException e) {e.printStackTrace();}}