sybasetest.java~2~

使用Jbuider访问Sybase数据库的JSP程序

package sybasetest;

import java.sql.*;

public class SybaseTest {
    public static void main(String[] args) {
        try {
            Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
            String url = "jdbc:sybase:Tds:66.2.5.188:5000/juddi";
            Connection con = DriverManager.getConnection(url, "sa", "123456");
            PreparedStatement pstmt = con.prepareStatement(
                    "select * from PUBLISHER");
            //pstmt.setInt(1,101);
            ResultSet rs = pstmt.executeQuery();
            while (rs.next()) {
                System.out.println(rs.getString(1) + " " + rs.getString(2) +
                                   " " + rs.getString(3));
            }
            rs.close();
            con.close();
        }catch(Exception e){e.printStackTrace();}
    }
}