- <%@ page contentType="text/html;charset=gb2312"%>
- <%@ page import="java.sql.*"%>
- <html>
- <body>
- <%
- //Class.forName("com.sybase.jdbc3.jdbc.SybDriver").newInstance();//通过jdbc方式连接
- Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();//通过jtds方式连接
- //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为数据库名
- Connection conn= DriverManager.getConnection(url, "sa","");
- Statement stmt=conn.createStatement();
- String sql="select * from bookinfo";
- ResultSet rs=stmt.executeQuery(sql);
- while(rs.next())
- {
- out.println("id="+rs.getString("id")+";标题="+rs.getString("title")+";作者="+rs.getString("author")+"<br/>");
- }
- try
- {
- rs.close();
- stmt.close();
- conn.close();
- }
- catch(Exception e)
- {
- out.println("数据库关闭出错");
- }
- %>
- </body>
- </html>
在hibernat中配置sybase
最新推荐文章于 2024-04-22 12:24:09 发布