23-例子1
import java.sql.*;
public class Example23_1
{public static void main(String args[])
  { String name,xuehao;Date date; int math,physics,english;
    Connection con;Statement sql; ResultSet rs;
    try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  }
    catch(ClassNotFoundException e){}
    try
      { 
         con=DriverManager.getConnection("jdbc:odbc:redsun","snow","ookk");
         sql=con.createStatement();
         rs=sql.executeQuery("SELECT * FROM chengjibiao");
       while(rs.next())
        {   name=rs.getString(2);  xuehao=rs.getString(1);
          date  =rs.getDate(3);    math=rs.getInt("數(shù)學(xué)");
          physics=rs.getInt("物理"); english=rs.getInt("英語");
          System.out.println("姓名："+name);
          System.out.println("學(xué)號(hào)："+xuehao);  
          System.out.println("出生："+date.toString());
          System.out.println("數(shù)學(xué)："+math);
          System.out.println("物理："+physics);  
    System.out.println("英語："+english);
       }
con.close();
     }
   catch(SQLException e1) {}
  } 
}  
23-例子2
import java.sql.*;
public class Example23_2
{public static void main(String args[])
  { String name,xuehao;Date date; int math,physics,english;
    Connection con;Statement sql; ResultSet rs;
    try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  }
    catch(ClassNotFoundException e){}
    try
      { 
     con=DriverManager.getConnection("jdbc:odbc:redsun","snow","ookk");
     sql=con.createStatement();
      rs=sql.executeQuery("SELECT * FROM chengjibiao WHERE 學(xué)號(hào) = '4' ");
       while(rs.next())
        { name=rs.getString(2); xuehao=rs.getString(1);
          date =rs.getDate(3);   math=rs.getInt("數(shù)學(xué)");
          physics=rs.getInt("物理");english=rs.getInt("英語");
          System.out.println("姓名："+name);
          System.out.println("學(xué)號(hào)："+xuehao);  
          System.out.println("出生："+date.toString());
          System.out.println("數(shù)學(xué)："+math);
          System.out.println("物理："+physics);  
          System.out.println("英語："+english);
                 }
       con.close(); 
     }
   catch(SQLException e1) {}
  } 
}
23-例子3
import java.sql.*;
public class Example23_3
{public static void main(String args[])
  { String name,xuehao;Date date; int math,physics,english;
    Connection con;Statement sql; ResultSet rs;
    try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  }
    catch(ClassNotFoundException e){}
    try
   { con=DriverManager.getConnection("jdbc:odbc:redsun","snow","ookk");
    sql=con.createStatement();
   rs=sql.executeQuery("SELECT * FROM chengjibiao WHERE 英語 >= 90 ");
     while(rs.next())
      {   name=rs.getString(2); xuehao=rs.getString(1);
      date=rs.getDate(3); math=rs.getInt("數(shù)學(xué)");
    physics=rs.getInt("物理"); english=rs.getInt("英語");
    System.out.println("姓名："+name); System.out.println("學(xué)號(hào)："+xuehao);
      System.out.println("出生："+date.toString());
      System.out.println("數(shù)學(xué)："+math);
      System.out.println("物理："+physics);  
      System.out.println("英語："+english);
       }
       con.close(); 
     }
   catch(SQLException e1) {}
 } 
}



23-例子4
import java.awt.*;import java.net.*;
import java.sql.*; import java.awt.event.*;
class Window extends Frame implements ActionListener
 { TextArea text;Panel panel;TextField xingming;
   Button button1,button2;
   Window()
  { super("成績查詢");
    setLayout(new BorderLayout()); setBackground(Color.cyan);
    setBounds(150,150,300,120); setVisible(true);
text=new TextArea();button1=new Button("確定");
button2=new Button("查詢所有人的成績");
    xingming=new TextField(16); panel=new Panel();
panel.add(new Label("輸入被查詢的學(xué)生的姓名："));
panel.add(xingming);panel.add(button1);
    add("North",panel); add(text,"Center");add(button2,"South");
    text.setEditable(false);text.setBackground(Color.pink);
    button1.addActionListener(this);button2.addActionListener(this);
    addWindowListener(new WindowAdapter()
     {public void windowClosing(WindowEvent e)
        { setVisible(false);System.exit(0);  } } );
 }
 public void actionPerformed(ActionEvent e)
  { if(e.getSource()==button1)
    {  text.setText("查詢結(jié)果"+'\n');
       try{ Liststudent1();}
       catch(SQLException ee) {}
    }
    else if(e.getSource()==button2)
    {  text.setText("查詢結(jié)果"+'\n');
       try{ Liststudent2();}
       catch(SQLException ee) {}
    }
  }
 public  void Liststudent1() throws SQLException
  {  String name;int math,english,physics,sum;
     try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
     catch(ClassNotFoundException e){}
     Connection con=DriverManager.getConnection("jdbc:odbc:redsun","chengjibiao","ookk");
    Statement sql=con.createStatement();
    ResultSet rs=sql.executeQuery("SELECT * FROM chengjibiao");  
    while(rs.next())
    {      name=rs.getString("姓名");  math=rs.getInt("數(shù)學(xué)");
           physics=rs.getInt("物理");  english=rs.getInt("英語");
           sum=english+math+physics; 
    if((name.trim()).equals(xingming.getText().trim()))
      {text.append("***"+"\n"+name+"的成績: "+"\n"+"數(shù)學(xué)："+math+" 英語：
       "+english+"物理:"+physics+"總分："+sum+'\n');   
      } 
    }
   if((text.getText().trim()).equals("查詢結(jié)果")) 
      {text.setText("沒有該人的成績");  }
 }
 public  void Liststudent2() throws SQLException
  { String name; int math,english,physics ,sum;
     try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
     catch(ClassNotFoundException e){}
    Connection con=DriverManager.getConnection("jdbc:odbc:redsun","snow","ookk");
    Statement sql=con.createStatement();
    ResultSet rs=sql.executeQuery("SELECT * FROM chengjibiao");  
    while(rs.next())
    { 
      name=rs.getString(2); math=rs.getInt("數(shù)學(xué)");
      physics=rs.getInt("物理");english=rs.getInt("英語");
      sum=english+math+physics;
     text.append("***"+"\n"+name+"的成績: "+"\n"+"數(shù)學(xué)："+math+" 英語：
"+english+"物理:"+physics+"總分："+sum+'\n');    
    }
  }
}
public class Example23_4
{ public static void main(String args[])
  {Window window=new Window();window.pack();
  }
}



23-例子5
import java.awt.*;import java.net.*;
import java.sql.*;import java.awt.event.*;
class DataWindow extends Frame implements ActionListener
 { TextField   待查英文單詞_文本條,漢語解釋_文本條,
                 更新英文單詞_文本條,更新漢語解釋_文本條,
                 填加英文單詞_文本條,填加漢語解釋_文本條; 
   Button       查詢按扭,更新按扭,填加按扭;
   int 查詢記錄=0;
   Connection Con=null;Statement Stmt=null;
  DataWindow()
  {  super("英漢小詞典");
     setBounds(150,150,300,120); 
     setVisible(true);setLayout(new GridLayout(3,1));
     try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
     catch(ClassNotFoundException e){}
      try{
Con=DriverManager.getConnection("jdbc:odbc:moon","gxy","ookk");
           Stmt=Con.createStatement();
         }
      catch(SQLException ee) {}
      待查英文單詞_文本條=new TextField(16);
漢語解釋_文本條=new TextField(16);
      更新英文單詞_文本條=new TextField(16);
更新漢語解釋_文本條=new TextField(16);
      填加英文單詞_文本條=new TextField(16);
填加漢語解釋_文本條=new TextField(16); 
      查詢按扭=new Button("查詢");
      更新按扭=new Button("更新");
      填加按扭=new Button("填加");
     Panel p1=new Panel(),p2=new Panel(),p3=new Panel();
     p1.add(new Label("輸入要查詢的英語單詞:"));
p1.add( 待查英文單詞_文本條);
     p1.add(new Label("顯示英語單詞的漢語解釋:"));
p1.add(漢語解釋_文本條);
     p1.add(查詢按扭);
     p2.add(new Label("輸入英語單詞:"));p2.add( 更新英文單詞_文本條);
     p2.add(new Label("輸入該單詞更新的漢語解釋:"));
p2.add(更新漢語解釋_文本條);
     p2.add(更新按扭);
     p3.add(new Label("輸入英語單詞:"));p3.add(  填加英文單詞_文本條);
     p3.add(new Label("輸入漢語解釋:"));p3.add(填加漢語解釋_文本條);
     p3.add(填加按扭);
     add(p1);add(p2);add(p3);
     查詢按扭.addActionListener(this);更新按扭.addActionListener(this);
     填加按扭.addActionListener(this);
     addWindowListener(new WindowAdapter()
     {public void windowClosing(WindowEvent e)
     {setVisible(false);System.exit(0);  } } );
  }
 public void actionPerformed(ActionEvent e)
  {if(e.getSource()==查詢按扭)
    {  查詢記錄=0;
       try{ 查詢();}
       catch(SQLException ee) {}
    }
   else if(e.getSource()==更新按扭)
    {  try{ 更新();}
       catch(SQLException ee) {}
    }
   else if(e.getSource()==填加按扭)
    {  try{ 填加();}
       catch(SQLException ee) {}
    }
  }
 public  void 查詢() throws SQLException
  { String cname,ename;
Con=DriverManager.getConnection("jdbc:odbc:moon","gxy","ookk");
    ResultSet rs=Stmt.executeQuery("SELECT * FROM 表1 ");  
    while (rs.next())
     {ename=rs.getString("單詞"); cname=rs.getString("解釋");
       if(ename.equals( 待查英文單詞_文本條.getText().trim()))
       {漢語解釋_文本條.setText(cname);查詢記錄=1; break;
       } 
     }
     Con.close();
   if(查詢記錄==0)
     {漢語解釋_文本條.setText("沒有該單詞");  
     }
 }
 public void 更新() throws SQLException
 {  String s1="'"+更新英文單詞_文本條.getText().trim()+"'",
           s2="'"+更新漢語解釋_文本條.getText().trim()+"'";
    String t=" 'womendouhao' ";
   String temp="UPDATE 表1 SET 解釋 ="+s2+" WHERE 單詞 = "+s1 ;
   Con=DriverManager.getConnection("jdbc:odbc:moon","gxy","ookk");
   Stmt.executeUpdate(temp);  Con.close();
 } 
 public void 填加() throws SQLException
 {  String s1="'"+填加英文單詞_文本條.getText().trim()+"'",
           s2="'"+填加漢語解釋_文本條.getText().trim()+"'";
    String temp="INSERT INTO 表1 VALUES ("+s1+","+s2+")";
    Con=DriverManager.getConnection("jdbc:odbc:moon","gxy","ookk");
    Stmt.executeUpdate(temp); 
    Con.close();
 }
}
public class Database
{ public static void main(String args[])
    {DataWindow window=new DataWindow();window.pack();
  }
}





23-例子6
(1) 客戶端程序:
import java.net.*;import java.io.*;
import java.awt.*;import java.awt.event.*;
import java.applet.*;