Prev이전 문서
Next다음 문서
jsp로 게시판 만들고 있는데요.
오라클은 데이터베이스 연결이 되는데요
큐브리드는 어떻게 연결해야 되는지 구체적으로 알고 싶어요.
추천
비추천
<%@ page language="java" contentType="text/html; charset=euc-kr" import="java.sql.*" %><html><head> <title>sql test</title></head><body><pre><%Class.forName("cubrid.jdbc.driver.CUBRIDDriver");Connection conn = DriverManager.getConnection("jdbc:cubrid:localhost:33000:dbname:::", "id", "pw");
//단일 값 가져오기 예제int cnt;{ Statement stm = conn.createStatement(); ResultSet rs = stm.executeQuery("SELECT COUNT(*) CNT FROM DB_CLASS WHERE CLASS_NAME='temp'"); if(rs.next()){ cnt = rs.getInt("CNT"); }else{ throw new Exception(); } rs.close(); stm.close();}
//단순 실행 쿼리 예제{ Statement stm = conn.createStatement(); stm.execute(cnt == 0 ? "CREATE CLASS TEMP(ATT INT)" : "DELETE FROM TEMP"); stm.close();}
//파라미터 설정 예제for(int i=0; i<10; i++){ PreparedStatement ps = conn.prepareStatement("INSERT INTO TEMP(ATT) VALUES(?)"); ps.setInt(1, i); ps.execute(); ps.close();}
//여러값 가져오기 예제{ Statement stm = conn.createStatement(); ResultSet rs = stm.executeQuery("SELECT * FROM TEMP"); while(rs.next()){ out.println(rs.getInt("ATT")); } rs.close(); stm.close();}
conn.close();%></pre></body></html>
디비생성에러
<%@ page language="java" contentType="text/html; charset=euc-kr" import="java.sql.*" %>
<html>
<head>
<title>sql test</title>
</head>
<body>
<pre>
<%
Class.forName("cubrid.jdbc.driver.CUBRIDDriver");
Connection conn = DriverManager.getConnection("jdbc:cubrid:localhost:33000:dbname:::", "id", "pw");
//단일 값 가져오기 예제
int cnt;
{
Statement stm = conn.createStatement();
ResultSet rs = stm.executeQuery("SELECT COUNT(*) CNT FROM DB_CLASS WHERE CLASS_NAME='temp'");
if(rs.next()){
cnt = rs.getInt("CNT");
}else{
throw new Exception();
}
rs.close();
stm.close();
}
//단순 실행 쿼리 예제
{
Statement stm = conn.createStatement();
stm.execute(cnt == 0 ? "CREATE CLASS TEMP(ATT INT)" : "DELETE FROM TEMP");
stm.close();
}
//파라미터 설정 예제
for(int i=0; i<10; i++){
PreparedStatement ps = conn.prepareStatement("INSERT INTO TEMP(ATT) VALUES(?)");
ps.setInt(1, i);
ps.execute();
ps.close();
}
//여러값 가져오기 예제
{
Statement stm = conn.createStatement();
ResultSet rs = stm.executeQuery("SELECT * FROM TEMP");
while(rs.next()){
out.println(rs.getInt("ATT"));
}
rs.close();
stm.close();
}
conn.close();
%>
</pre>
</body>
</html>