?? 第二十三章例子.txt
字號:
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("數學");
physics=rs.getInt("物理"); english=rs.getInt("英語");
System.out.println("姓名："+name);
System.out.println("學號："+xuehao);
System.out.println("出生："+date.toString());
System.out.println("數學："+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 學號 = '4' ");
while(rs.next())
{ name=rs.getString(2); xuehao=rs.getString(1);
date =rs.getDate(3); math=rs.getInt("數學");
physics=rs.getInt("物理");english=rs.getInt("英語");
System.out.println("姓名："+name);
System.out.println("學號："+xuehao);
System.out.println("出生："+date.toString());
System.out.println("數學："+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("數學");
physics=rs.getInt("物理"); english=rs.getInt("英語");
System.out.println("姓名："+name); System.out.println("學號："+xuehao);
System.out.println("出生："+date.toString());
System.out.println("數學："+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("輸入被查詢的學生的姓名："));
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("查詢結果"+'\n');
try{ Liststudent1();}
catch(SQLException ee) {}
}
else if(e.getSource()==button2)
{ text.setText("查詢結果"+'\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("數學");
physics=rs.getInt("物理"); english=rs.getInt("英語");
sum=english+math+physics;
if((name.trim()).equals(xingming.getText().trim()))
{text.append("***"+"\n"+name+"的成績: "+"\n"+"數學："+math+" 英語：
"+english+"物理:"+physics+"總分："+sum+'\n');
}
}
if((text.getText().trim()).equals("查詢結果"))
{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("數學");
physics=rs.getInt("物理");english=rs.getInt("英語");
sum=english+math+physics;
text.append("***"+"\n"+name+"的成績: "+"\n"+"數學："+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.*;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -