JDBCアクセスSybase
1563 ワード
一、sybaseのjdbcドライバをCLASSSPATH(eclipse構築経路)にコピーする
/opt/sybase/jConnect-16_0/classes/jconn4.JArまたは/opt/sybase/shared/lib/jconn 4.jar
二、テストコード
/opt/sybase/jConnect-16_0/classes/jconn4.JArまたは/opt/sybase/shared/lib/jconn 4.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 row = 1; row <= col_count; row++) {
System.out.print(rs.getString(row));
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();
}
}
}