±Û¾´ÀÌ :º¯»ó¼± 2000³â 3¿ù 15ÀÏ 17:51:12
»çÀ̺£À̽º µðºñ¿¡ ¿¬°áÇϱâ À§Çؼ jdbc¸¦ ¿¬°áÇÏ´Â ¼Ò½ºÀÔ´Ï´Ù.
¼¹öÀÇ À̸§Àº delphi
µ¥ÀÌŸº£À̽ºÀ̸§Àº tempdbÀÔ´Ï´Ù.
¿¡·¯ÀÇ ³»¿ëÀº ´ÙÀ½°ú °°½À´Ï´Ù.
jdbc.java:14: Class SybDriver not found in type declaration.
SybDriver sybDriver = (SybDriver)Class.forName("com.sybase.jdbc.SybDriver");
^
jdbc.java:14: Class SybDriver not found in type declaration.
SybDriver sybDriver = (SybDriver)Class.forName("com.sybase.jdbc.SybDriver");
^
jdbc.java:23: Incompatible type for =. Can't convert int to java.sql.ResultSet.
rs = stmt.executeUpdate(query);
^
3 errors
°í¼ö´ÔµéÀÇ µµ¿òÀ» ¹Ù¶ø´Ï´Ù.
Ȥ½Ã ºÎÁ·ÇÑ ºÎºÐÀÌ ÀÖÀ½ ¸ÞÀÏÁÖ½Ã¸é °¨»çÇÏ°Ú½À´Ï´Ù.
°í¸¿½À´Ï´Ù.
import java.sql.*;
public class jdbc{
public static void main(String args[]){
Connection conn = null;
Statement stmt = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
SybDriver sybDriver = (SybDriver)Class.forName("com.sybase.jdbc.SybDriver");
DriverManager.registerDriver(sybDriver);
conn = DriverManager.getConnection(
"jdbc:sybase:tempdb:211.41.87.51:5000/delphi", "sa", "");
String query = "CREATE table aaa(name char(10), address varchar(50)";
stmt = conn.createStatement();
rs = stmt.executeUpdate(query);
conn.close();
} catch(Exception e){
e.printStackTrace();
}
}
}