一、把sybase的jdbc驱动拷入CLASSPATH(eclipse构建路径)
/opt/sybase/jConnect-16_0/classes/jconn4.jar或/opt/sybase/shared/lib/jconn4.jar
二、测试代码
package com.zjptcc.wxw.test;
import java.sql.*;
public class SampleCode {
public static void main(String args[]) {
try {
/*
* Open the connection. May throw a SQLException.
*/
DriverManager.registerDriver((Driver) Class.forName(
"com.sybase.jdbc4.jdbc.SybDriver").newInstance());
Connection conn = DriverManager.getConnection(
"jdbc:sybase:Tds:127.0.1.1:5000/master", "sa",
"you_passwd");
//这里把you_passwd改为自己的密码
/*
* Create a statement object, the container for the SQL statement.
* May throw a SQLException.
*/
Statement st = conn.createStatement();
/*
* Create a result set object by executing the query. May throw a
* SQLException.
*/
ResultSet rs = st.executeQuery("SELECT * FROM spt_values");
int col_count = st.getResultSet().getMetaData().getColumnCount();
/*
* Process the result set.
*/
while (rs.next()) {
for (int col = 1; col <= col_count; col++) {
System.out.print(rs.getString(col));
System.out.print(" ");
}
System.out.println();
}
rs.close();
st.close();
conn.close();
} catch (SQLException sqe) {
System.out.println("Unexpected exception : " + sqe.toString()
+ ", sqlstate = " + sqe.getSQLState());
System.exit(1);
} catch (Exception e) {
e.printStackTrace();
}
}
}