+++ /dev/null
-package org.sqlite;\r
-\r
-import java.awt.Color;\r
-import java.awt.Graphics;\r
-import java.security.AccessController;\r
-import java.security.PrivilegedAction;\r
-import java.sql.Connection;\r
-import java.sql.DriverManager;\r
-import java.sql.ResultSet;\r
-import java.sql.Statement;\r
-\r
-import javax.swing.JApplet;\r
-\r
-import org.junit.Ignore;\r
-import org.junit.Test;\r
-\r
-/**\r
- * A demo for using SQLite JDBC inside a Java Applet.\r
- * \r
- * @author leo\r
- * \r
- */\r
-public class AppletTest extends JApplet\r
-{\r
- /**\r
- * \r
- */\r
- private static final long serialVersionUID = 1L;\r
-\r
- public AppletTest()\r
- {\r
- this.setSize(200, 200);\r
- }\r
-\r
- @SuppressWarnings("unchecked")\r
- public void init()\r
- {\r
- AccessController.doPrivileged(new PrivilegedAction() {\r
- public Object run()\r
- {\r
- try\r
- {\r
- Class.forName("org.sqlite.JDBC");\r
- }\r
- catch (ClassNotFoundException e)\r
- {\r
- e.printStackTrace();\r
- }\r
-\r
- return null;\r
- }\r
- });\r
- }\r
-\r
- public void paint(Graphics g)\r
- {\r
- try\r
- {\r
- Connection conn = DriverManager.getConnection("jdbc:sqlite:");\r
- Statement stmt = conn.createStatement();\r
- stmt.executeUpdate("create table sample(id, name)");\r
- stmt.executeUpdate("insert into sample values(1, \"leo\")");\r
- stmt.executeUpdate("insert into sample values(2, \"yui\")");\r
-\r
- int yOffset = 50;\r
- ResultSet rs = stmt.executeQuery("select * from sample");\r
- while (rs.next())\r
- {\r
- int id = rs.getInt(1);\r
- String name = rs.getString(2);\r
- g.drawString(String.format("id=%d, name=%s", id, name), 10, yOffset);\r
- yOffset += 50;\r
- }\r
-\r
- stmt.close();\r
- conn.close();\r
-\r
- g.setColor(Color.DARK_GRAY);\r
- g.drawRect(5, 5, 180, 180);\r
-\r
- }\r
- catch (Exception ex)\r
- {\r
- ex.printStackTrace();\r
- }\r
- }\r
-\r
- @Ignore\r
- @Test\r
- public void test()\r
- {\r
-\r
- }\r
-}
\ No newline at end of file