CUBIRD JDBC를 이용한 접속 예제
DBMS
2019. 9. 22. 15:29
package jdbc_test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
public class CubridJdbc10Test {
public static void main(String[] args) throws Exception {
String url = "jdbc:cubrid:localhost:30000:demodb:::";
String dbId = "dba";
String dbPw = "";
String className = "cubrid.jdbc.driver.CUBRIDDriver";
Class.forName(className);
Connection conn = DriverManager.getConnection(url, dbId, dbPw);
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
String query = "select * from code";
pstmt = conn.prepareStatement(query);
rs = pstmt.executeQuery();
ResultSetMetaData rsmd = rs.getMetaData();
int colCnt = rsmd.getColumnCount();
for (int i=1; i<=colCnt; ++i) {
System.out.print(rsmd.getColumnName(i) + " ");
}
System.out.println();
while (rs.next()) {
for (int i=1; i<=colCnt; ++i) {
System.out.print(rs.getString(i) + " ");
}
System.out.println();
}
} catch(Exception e) {
e.printStackTrace();
} finally {
if (rs != null) rs.close();
if (pstmt != null) pstmt.close();
if (conn != null) conn.close();
}
}
}
'DBMS' 카테고리의 다른 글
CUBRID 설치하기 (1) | 2019.09.22 |
---|