Posted by À±°æ±¸ on April 08, 1997 at 21:26:16:
In Reply to: DAO Á¢±Ù........ posted by ±è´ë¼ö on April 08, 1997 at 15:54:49:
¾ÆÁÖ °£´ÜÇÑ ¿¹Á¦ÀÔ´Ï´Ù. ½ÇÁ¦·Î ÀÌ ¾ÖÇø´Àº ½ÇÇàÀÌ µÇÁö ¾Ê½À´Ï´Ù.
odbc µå¶óÀ̹ö¿¡ ¾×¼¼½ºÇÏ´Â °ÍÀº ¾ÖÇø´¿¡°Ô ±ÝÁöµÇ¾î ÀÖ½À´Ï´Ù.
¾ÖÇø´ºä¾îÀÇ º¸¾ÈÀ» UNRESTRICTED·Î ÇÏ¸é °¡´ÉÇÒ °ÍÀÔ´Ï´Ù.
Á¦¾îÆÇÀÇ ODBC µå¶óÀ̹ö¿¡ ÇØ´ç µ¥ÀÌÅͺ£À̽º ÆÄÀÏÀ» µî·ÏÇصξî¾ß ÇÕ´Ï´Ù.
¿©±â¼´Â ¾×¼¼½º 7.0À» »ç¿ëÇß½À´Ï´Ù.
Å×À̺í À̸§Àº t_counterÀÌ°í Çʵå·Î counter_page(¹®ÀÚ¿)¿Í count(Á¤¼ö)¸¦ °¡Áý´Ï´Ù.
ÀÌ·¸°Ô »ç¿ëÇϸé Ç¥ÁØ SQL¹®À» »ç¿ëÇÏ¿© ODBC¿¡ Á¢¼ÓÇÒ ¼ö ÀÖ½À´Ï´Ù.
import java.net.URL; import java.sql.*; import java.awt.*; public class Counter extends java.applet.Applet { int count = 0; public void init () { try { Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver"); DriverManager.setLogStream(System.out); Connection con = DriverManager.getConnection ("jdbc:odbc:MS Access 7.0 Database", "yoonforh", "passwd"); String query = null; Statement stmt = con.createStatement (); String this_page = "my_homepage" query = "SELECT count FROM t_counter WHERE counter_page='"+this_page+"';"; // ÁúÀǸ¦ º¸³» ÀÌ ÆäÀÌÁö°¡ µî·ÏµÇ¾î ÀÖ´ÂÁö È®ÀÎ ResultSet rs = stmt.executeQuery (query); if (rs.next()) { /* ResultSetÀº óÀ½¿¡´Â °¡Àå ¾ÕÀÇ ·¹ÄÚµå ¹Ù·Î ¾Õ¿¡ * Ä¿¼¸¦ µÎ°í ÀÖ¾î next µµ±¸¸¦ ÇÑ ¹ø È£ÃâÇϸé * ù ¹ø° ·¹Äڵ忡 Ä¿¼°¡ °¡°Ô µÈ´Ù. */ count=rs.getInt("count"); query="UPDATE t_counter SET count=count+1 WHERE counter_page='"+this_page+"';"; } else { // ·¹Äڵ尡 Çϳªµµ ¾ø´Ù. Áï, ÀÌ ÆäÀÌÁö´Â µî·ÏµÇ¾î ÀÖÁö ¾Ê´Ù. count=1; query="INSERT INTO t_counter(counter_page, count) VALUES('"+this_page+"', 1);"; } stmt.close(); stmt=con.createStatement(); stmt.executeUpdate(query); rs.close(); stmt.close(); con.close(); } catch (SQLException e) { traceSQLException(e); } catch (Exception e) { System.out.println("Unable to connect DataBase"); e.printStackTrace (); } } public void paint(Graphics g) { g.setFont(new Font("TimesRoman", Font.BOLD, 15)); g.drawString(String.valueOf(count), 10, 10); } private void traceSQLException(SQLException e) { // SQL ¿¹¿Ü ¹ß»ý ½Ã ³»¿ë ÃßÀû Ãâ·Â System.out.println("---SQL Exception Occurred---"); while (e != null) { System.out.println ("SQLState: " + e.getSQLState ()); System.out.println ("Message: " + e.getMessage ()); System.out.println ("Vendor: " + e.getErrorCode ()); e = e.getNextException (); System.out.println (""); } } }µµ¿òÀÌ µÇ±æ...