0001 // HelloWorldAppletMySQLJDBC.java
0002 import java.applet.Applet;
0003 import java.sql.*;
0004 import java.awt.*;
0005 
0006 public class HelloWorldAppletMySQLJDBC extends Applet {
0007 
0008   public void paint(Graphics g) {
0009     try {
0010       Class.forName("org.gjt.mm.mysql.Driver");
0011 
0012       Connection con = DriverManager.getConnection
0013                    ("jdbc:mysql:///hellodb");
0014       System.out.println("MySQL 検索結果");
0015       g.drawString("MySQL 検索結果",20,30);
0016       Statement stmt = con.createStatement();
0017       String sql = "SELECT * FROM hello_world_table";
0018       ResultSet rs = stmt.executeQuery(sql);
0019 
0020       int r = 50;
0021       while(rs.next()){
0022          int no = rs.getInt("NO");
0023          String lang = rs.getString("LANGUAGE");
0024          String msg = rs.getString("MESSAGE");
0025          String txt = no + "  " + lang + "  " + msg ;
0026          g.drawString(txt,20,r);
0027          r = r + 15;
0028          System.out.println("console : " + txt);
0029       }
0030 
0031       stmt.close();
0032       con.close();
0033 
0034     } catch (SQLException e) {
0035       System.out.println("Excep:" + e.getMessage());
0036       System.out.println(" SQL :" + e.getSQLState());
0037       System.out.println(" Code:" + e.getErrorCode());
0038     } catch (Exception e2) {
0039       System.out.println("Excep:" + e2.getMessage());
0040     }
0041   }
0042 }