?? denglu.java
字號(hào):
import java.io.*;
import java.sql.*;
import java.awt.*;
import java.applet.*;
import java.awt.event.*;
class ConnectDataBase extends Frame implements ActionListener
{
Button b1,b2,b3,b4,b5,b6,b7;
TextArea t1;
Dialog my;
TextField T1,T2,T3,T4,T5,T6,T7,T8;
Label L1,L2,L3,L4,L5,L6,L7;
/*public static void driver()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException a)
{
System.out.println(a.getMessage());
}
}*/
public ConnectDataBase()
{
super("商品銷售管理系統(tǒng)");
b1=new Button("商品管理");
b2=new Button("商品銷售登記");
b3=new Button("商品訂貨計(jì)劃");
b4=new Button("商品入庫(kù)管理");
b5=new Button("商品出庫(kù)管理");
b6=new Button("員工管理");
b7 = new Button("退出");
t1=new TextArea("查詢結(jié)果為:",10,50);
setLayout(new FlowLayout());
add(t1);
add(b1);
b1.addActionListener(this);
add(b2);
b2.addActionListener(this);
addWindowListener(new closeWin());
}
public void actionPerformed(ActionEvent e)
{
b1.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException a)
{
t1.append(a.getMessage());
}
String url="jdbc:odbc:goods";
String sql="SELECT * FROM Spname WHERE Shno!=0";
try
{
Connection con=DriverManager.getConnection(url,"u1","123456");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
String s1=rs.getString("Shno");//貨號(hào)
String s2=rs.getString("Spname");//品名
String s3= rs.getString("Stype");//規(guī)格
String s4 = rs.getString("Sprice");//單價(jià)
int p=rs.getInt("Rjprice");//進(jìn)價(jià)
int s=rs.getInt("Rcprice");//售價(jià)
t1.append("貨號(hào):"+s1+"\n");
t1.append("品名"+s2+"\n");
t1.append("規(guī)格" + s3 + "\n");
t1.append("品名" + s4+ "\n");
t1.append("進(jìn)價(jià):"+p+"\n");
t1.append("售價(jià):"+s+"\n");
}
stmt.close();
con.close();
}
catch(SQLException ex)
{
t1.append(ex.getMessage());
}
}
});
b2.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
L1=new Label("編號(hào)");
L2=new Label("貨號(hào)");
L3=new Label("工號(hào)");
L4=new Label("數(shù)量");
L5=new Label("銷售日期");
L6=new Label("客戶名");
T1=new TextField(20);
T2=new TextField(20);
T3=new TextField(20);
T4=new TextField(20);
T5=new TextField(20);
T6=new TextField(15);
my=new Dialog(ConnectDataBase.this,"商品銷售登記",true);
my.setLayout(new FlowLayout());
my.add(L1);my.add(T1);
my.add(L2);my.add(T2);
my.add(L3);my.add(T3);
my.add(L4);my.add(T4);
my.add(L5);my.add(T5);
my.add(L6);my.add(T6);
my.add(b2);my.add(b7);
my.setSize(250,300);
my.setVisible(true);
}
});
b3.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
L1=new Label("貨號(hào)");
L2=new Label("品名");
L3=new Label("規(guī)格");
L4=new Label("單價(jià)");
L5=new Label("數(shù)量");
T1=new TextField(20);
T2=new TextField(20);
T3=new TextField(20);
T4=new TextField(20);
T5=new TextField(20);
my=new Dialog(ConnectDataBase.this,"商品訂貨計(jì)劃",true);
my.setLayout(new FlowLayout());
my.add(L1);my.add(T1);
my.add(L2);my.add(T2);
my.add(L3);my.add(T3);
my.add(L4);my.add(T4);
my.add(L5);my.add(T5);
my.setSize(250,300);
my.setVisible(true);
}
});
b4.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
L1=new Label("貨號(hào)");
L2=new Label("進(jìn)價(jià)");
L3=new Label("售價(jià)");
L4=new Label("庫(kù)存量");
L5=new Label("最低庫(kù)存");
L6=new Label("訂貨量");
T1=new TextField(20);
T2=new TextField(20);
T3=new TextField(20);
T4=new TextField(20);
T5=new TextField(20);
T6=new TextField(15);
my=new Dialog(ConnectDataBase.this,"商品庫(kù)存",true);
my.setLayout(new FlowLayout());
my.add(L1);my.add(T1);
my.add(L2);my.add(T2);
my.add(L3);my.add(T3);
my.add(L4);my.add(T4);
my.add(L5);my.add(T5);
my.add(L6);my.add(T6);
my.setSize(250,300);
my.setVisible(true);
}
});
b5.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
L1=new Label("編號(hào)");
L2=new Label("貨號(hào)");
L3=new Label("數(shù)量");
T1=new TextField(20);
T2=new TextField(20);
T3=new TextField(20);
my=new Dialog(ConnectDataBase.this,"商品出庫(kù)",true);
my.setLayout(new FlowLayout());
my.add(L1);my.add(T1);
my.add(L2);my.add(T2);
my.add(L3);my.add(T3);
my.setSize(250,300);
my.setVisible(true);
}
});
b6.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
L1=new Label("工號(hào)");
L2=new Label("姓名");
L3=new Label("地址");
L4=new Label("電話");
L5=new Label("出生日期");
L6=new Label("起聘日期");
L7=new Label("基本工資");
T1=new TextField(20);
T2=new TextField(20);
T3=new TextField(20);
T4=new TextField(20);
T5=new TextField(20);
T6=new TextField(15);
T7=new TextField(15);
my=new Dialog(ConnectDataBase.this,"員工管理",true);
my.setLayout(new FlowLayout());
my.add(L1);my.add(T1);
my.add(L2);my.add(T2);
my.add(L3);my.add(T3);
my.add(L4);my.add(T4);
my.add(L5);my.add(T5);
my.add(L6);my.add(T6);
my.add(L7);my.add(T7);
my.setSize(250,300);
my.setVisible(true);
}
});
b2.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException a)
{
System.out.println(a.getMessage());
}
String url="jdbc:odbc:liu";
String sql1="INSERT INTO goods VALUES('"+T1.getText()+"','"+T2.getText()+"','"+T3.getText()+"','"+T4.getText()+"',"+Integer.parseInt(T5.getText())+")";
String sql2="INSERT INTO goods VALUES('"+T1.getText()+"','"+T6.getText()+"',"+T7.getText()+","+null+")";
try
{
Connection con=DriverManager.getConnection(url,"u1","123456");
Statement stmt=con.createStatement();
stmt.executeUpdate(sql1);
stmt.executeUpdate(sql2);
stmt.close();
con.close();
}
catch(SQLException ex)
{
t1.append(ex.getMessage()+"\n");
}
}
});
b7.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
my.dispose();
}
});
}
}
class closeWin extends WindowAdapter
{
public void windowClosing(WindowEvent e)
{
Window w=e.getWindow();
w.dispose();
}
}
public class denglu extends Frame implements ActionListener
{
Label L1,L2,L3;
TextField T1,T2;
Button b1,b2;
boolean f=false;
Dialog errorDialog;
public denglu()
{
super("登錄對(duì)話框");
L1=new Label("用戶名:");
L2=new Label("密碼");
L3=new Label("該用戶不存在！您沒(méi)有授權(quán)！");
b2=new Button("確定");
T1=new TextField(20);
T2=new TextField(20);
T2.setEchoChar('*');
b1=new Button("登錄");
setLayout(new FlowLayout());
add(L1);add(T1);
add(L2);add(T2);
add(b1);
b1.addActionListener(this);
addWindowListener(new closeWin());
}
public void actionPerformed(ActionEvent e)
{
b1.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
String t1,t2;
t1=T1.getText();
t2=T2.getText();
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException a)
{
System.out.println(a.getMessage());
}
String url="jdbc:odbc:goods";
String sql="SELECT * FROM SQLUser";
try
{
Connection con=DriverManager.getConnection(url,t1,t2);
Statement stmt=con.createStatement();
f=true;
}
catch(SQLException ex)
{
f=false;
System.out.println(ex.getMessage());
}
if(f)
{
ConnectDataBase c=new ConnectDataBase();
c.setSize(400,350);
c.setVisible(true);
}
else
{
errorDialog=new Dialog(denglu.this,"用戶不存在",true);
errorDialog.setLayout(new FlowLayout());
errorDialog.add(L3);
errorDialog.add(b2);
errorDialog.setSize(200,200);
errorDialog.setVisible(true);
}
}
});
b2.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
errorDialog.dispose();
}
});
}
public static void main(String args[])
{
denglu d=new denglu();
d.setSize(200,200);
d.setVisible(true);
}
}?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -