ZhangYu's Blog

import java.sql.*;
public class test
{
    public static void main(String args[])
    {
        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306";
        String user = "root";
        String password = "123123";
 
        try
        {
            Class.forName(driver);
            Connection connection = DriverManager.getConnection(url, user, password);
            if (!connection.isClosed())
            {
                System.out.println("Succeeded in connecting to the Database!");
                Statement statement = connection.createStatement();
                String sql = "SET NAMES `utf8`";
                statement.executeUpdate(sql);
 
                sql = "USE `mydatabase`";
                statement.executeUpdate(sql);
 
                sql = "SELECT * FROM `mytable`";
                ResultSet result_set = statement.executeQuery(sql);
                while(result_set.next())
                {
                    String name = result_set.getString("first");
                    System.out.println(name);
                }
                result_set.close();
                connection.close();
            }
        }catch(Exception ex)
        {
            ex.printStackTrace();
        }
    }
}

class OutClass
{
 private int num;
 public OutClass(int i)
 {
  num = i;
 }
 public void test()
 {
  System.out.println("num is " + getNum() + " from Out Class");
 }
 public int getNum()
 {
  return num;
 }
}
public class Test
{
 public static void main(String[] args)
 {
  new Test().show();
 }
 public void show()
 {
  OutClass a = new OutClass(356)
  {
   public void test()
   {
    System.out.println("num is " + getNum() + " from Inner Class");
   }
  };
  a.test();
 }
}