sybase jdbc demo
package com.cn.rgryre.databae;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class dbTest {
public static void main(String[] srg) {
// String driverName = "com.sybase.jdbc3.jdbc.SybDriver"; //加载JDBC驱动
// String dbURL = "jdbc:sybase:Tds:localhost"; //连接服务器和数据库sample
// String userName = "dba"; //默认用户名
// String userPwd = "sql"; //密码
// Connection dbConn;
try {
// Sybase的加载JDBC驱动程序
Class.forName("com.sybase.jdbc3.jdbc.SybDriver").newInstance();
// 与Sybase数据库建立连接
Connection dbConn = DriverManager.getConnection(
"jdbc:sybase:Tds:localhost:1100/test", "dba", "sql");
// 创建Statement
// Statement st=dbConn.createStatement();
int resultSetType;
Statement st = dbConn
.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
// 创建一个JDBC声明
String query = "SELECT * from hzw_ov where Product_ID='0609010021'";
// Execute the desired DML statement and then call dispResultSet to
// display the rows and columns
ResultSet rs = st.executeQuery(query);
//结果集指针知道最后一行数据
rs.last();
int count=rs.getRow();
System.out.println(count);
//将结果集指针指回到开始位置，这样才能通过while获取rs中的数据
rs.beforeFirst();
while (rs.next()) {
String Product_ID=rs.getString(1);// 获得数据库结果集中第1列（结果集从1开始）
System.out.println("Product_ID:"+Product_ID);
String Product_name=rs.getString(2);// 获得数据库结果集中第3列
System.out.println("Product_name:"+Product_name);
String Product_ctg=rs.getString(5);// 获得数据库结果集中第2列
System.out.println("Product_ctg:"+Product_ctg);
}
/*while (rs.next()) {
for (int i = 1; i < rs.getRow(); i++)
System.out.println(rs.getString(i) + ";"); // 获得数据库第i列);
}
*/dbConn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
页:
[1]