Class.forName("com.sybase.jdbc.SybDriver").newInstance();
//test--数据库名
String url =" jdbc:sybase:Tds:localhost:5007/test";
Properties sysProps = System.getProperties();
sysProps.put("user","userid");
sysProps.put("password","user_password");
Connection conn= DriverManager.getConnection(url, SysProps);
Statement stmt=conn.createStatement();
String sql="select * from mytable";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
rs.getString(1);
}
rs.close();
stmt.close();
conn.close();
//test--数据库名
String url =" jdbc:sybase:Tds:localhost:5007/test";
Properties sysProps = System.getProperties();
sysProps.put("user","userid");
sysProps.put("password","user_password");
Connection conn= DriverManager.getConnection(url, SysProps);
Statement stmt=conn.createStatement();
String sql="select * from mytable";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
rs.getString(1);
}
rs.close();
stmt.close();
conn.close();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货