📄 house.java
字号:
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import java.sql.*;
/////////////登录界面模块////////////////
class Load extends JFrame implements ActionListener
{
private JLabel lname,lpassword;
private JTextField tname;
JPasswordField tpassword;
private JPanel p1,p2,p3;
private JButton btn1,btn2;
Load(String s)
{
super(s);
lname=new JLabel("用户名");
lpassword=new JLabel("密 码");
tname=new JTextField(15);
tpassword=new JPasswordField(15);
btn1=new JButton("登录");
btn2=new JButton("取消");
Container con=getContentPane();//获取容器
con.setLayout(new FlowLayout());//布局为FlowLayout
JPanel p1=new JPanel();
JPanel p2=new JPanel();
JPanel p3=new JPanel();
p1.add(lname);
p1.add(tname);
p2.add(lpassword);
p2.add(tpassword);
p3.add(btn1);
btn1.addActionListener(this);
p3.add(btn2);
btn2.addActionListener(this);
con.add(p1);
con.add(p2);
con.add(p3);
addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent e)
{ System.exit(0);}
}); //窗口关闭事件，匿名类
setBounds(300,200,300,150);
setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==btn1)
{
Connection conn;
Statement sql;
ResultSet rs;
String username=tname.getText().toString().trim();
String password=tpassword.getText().toString().trim();
int sum=0;
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ee)
{ System.out.println(""+ee);
}
try { conn=DriverManager.getConnection("jdbc:odbc:house","","");
sql=conn.createStatement();
rs=sql.executeQuery("SELECT * FROM user where user='"+username+"'and psw='"+password+"'");
while(rs.next())
{ String id=rs.getString(1);
String ps=rs.getString(2);
sum++;
}
conn.close();
}
catch(SQLException ex)
{ System.out.println(ex);
}
if(sum==1)
{
setVisible(false);
Main main=new Main("房屋销售管理系统");
}
else
{ JOptionPane.showMessageDialog(null,"登录失败!");}
}
if(e.getSource()==btn2)
{
System.exit(0);
}
}
}
///////////////////主界面//////////////////////
class Main extends Frame implements ActionListener
{
private MenuBar menubar;
Menu menu1, menu2, menu3, menu4;
MenuItem item1,item3,item4,item5,item6,item7,item8,item9,item10,item11,item12;
Main(String s)
{
super(s);
menubar=new MenuBar();
menu1=new Menu("系统管理");
menu2=new Menu("房屋管理");
menu3=new Menu("销售管理");
menu4=new Menu("查询信息");
item1=new MenuItem("修改密码");
item3=new MenuItem("系统退出");
item4=new MenuItem("浏览房屋信息");
item5=new MenuItem("添加房屋信息");
item6=new MenuItem("修改房屋信息");
item7=new MenuItem("删除房屋信息");
item8=new MenuItem("浏览房屋销售信息");
item9=new MenuItem("增加房屋销售信息");
item10=new MenuItem("修改房屋销售信息");
item11=new MenuItem("删除房屋销售信息");
item12=new MenuItem("查询信息");
menu1.add(item1);
item1.addActionListener(this);
menu1.add(item3);
item3.addActionListener(this);
menu2.add(item4);
item4.addActionListener(this);
menu2.add(item5);
item5.addActionListener(this);
menu2.add(item6);
item6.addActionListener(this);
menu2.add(item7);
item7.addActionListener(this);
menu3.add(item8);
item8.addActionListener(this);
menu3.add(item9);
item9.addActionListener(this);
menu3.add(item10);
item10.addActionListener(this);
menu3.add(item11);
item11.addActionListener(this);
menu4.add(item12);
item12.addActionListener(this);
menubar.add(menu1);
menubar.add(menu2);
menubar.add(menu3);
menubar.add(menu4);
setMenuBar(menubar);
addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent e)
{ System.exit(0);
}
});
setVisible(true);
setBounds(200,200,600,300);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==item1)
{
Change_psw ch=new Change_psw("修改密码");
}
if(e.getSource()==item3)
{
System.exit(0);
}
if(e.getSource()==item4)
{
V_House vah=new V_House("浏览房屋信息");
}
if(e.getSource()==item5)
{
Add_House house=new Add_House("添加房屋信息");
}
if(e.getSource()==item6)
{
Change_House c_house=new Change_House("修改房屋信息");
}
if(e.getSource()==item7)
{
Del_House d_house=new Del_House("删除房屋信息");
}
if(e.getSource()==item8)
{
V_Sell vsell=new V_Sell("浏览房屋销售信息");
}
if(e.getSource()==item9)
{
Add_Sell sell_infor=new Add_Sell("添加房屋销售信息");
}
if(e.getSource()==item10)
{
Change_Sell csi=new Change_Sell("修改房屋销售信息");
}
if(e.getSource()==item11)
{
Del_Sell del_sell=new Del_Sell("删除房屋销售信息");
}
if(e.getSource()==item12)
{
Querytest query=new Querytest("查询信息");
}
}
}
//////////////////////修改密码////////////////////
class Change_psw extends JFrame implements ActionListener
{
private JLabel luser,lpassword1,lpassword2,lpassword3;
private JTextField tuser;
private JPasswordField tpassword1,tpassword2,tpassword3;
private JButton btn1,btn2;
private JPanel p1,p2,p3,p4,p5;
Change_psw(String s)
{
super(s);
Container con=getContentPane();
con.setLayout(new FlowLayout());
luser=new JLabel("请输入你的用户名");
lpassword1=new JLabel("请输入原始的密码");
lpassword2=new JLabel("请输入你的新密码");
lpassword3=new JLabel("请再次输入新密码");
tuser=new JTextField(10);
tpassword1=new JPasswordField(10);
tpassword2=new JPasswordField(10);
tpassword3=new JPasswordField(10);
btn1=new JButton("确认");
btn2=new JButton("取消");
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
p5=new JPanel();
p1.add(luser);
p1.add(tuser);
p2.add(lpassword1);
p2.add(tpassword1);
p3.add(lpassword2);
p3.add(tpassword2);
p4.add(lpassword3);
p4.add(tpassword3);
p5.add(btn1);
btn1.addActionListener(this);
p5.add(btn2);
btn2.addActionListener(this);
con.add(p1);
con.add(p2);
con.add(p3);
con.add(p4);
con.add(p5);
setBounds(200,200,350,250);
setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==btn1)
{
Connection conn;
Statement sql;
ResultSet rs;
int sum=0;
String u1=tuser.getText().toString().trim();
String w1=tpassword1.getText().toString().trim();
String w2=tpassword2.getText().toString().trim();
String w3=tpassword3.getText().toString().trim();
if(w2.equals(""))
{JOptionPane.showMessageDialog(null,"新密码不能为空！");}
if(!(w2.equals(w3)))
{
JOptionPane.showMessageDialog(null,"两次新密码不相同！");
}
else
{
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException ee)
{ System.out.println(""+ee);}
try { conn=DriverManager.getConnection("jdbc:odbc:house","","");
sql=conn.createStatement();
rs=sql.executeQuery("SELECT * FROM user where user='"+u1+"'and psw='"+w1+"'");
while(rs.next())
{
sum++;}
if(sum==0)
{JOptionPane.showMessageDialog(null,"原用户名和密码错误！");}
else
{
sql.executeUpdate("UPDATE user SET psw='"+w2+"'WHERE user='"+u1+"'");
setVisible(false);
JOptionPane.showMessageDialog(null,"修改密码成功！");}
conn.close();
}
catch(SQLException ex)
{ System.out.println(ex);}
}
}
else
{setVisible(false);}
}
}
/////////////////////修改销售信息///////////////////////////
class Change_Sell extends JFrame implements ActionListener
{
private JLabel sell_id,house_id,buyer_name,seller_name,sell_date,sell_value;
private JTextField sid,hid,bname,sname,date,value;
private JPanel p1,p2,p3,p4;
private JButton btn1,btn2,querybtn;
Container con=getContentPane();
Change_Sell(String s)
{
super(s);
sell_id=new JLabel("销售编号");
house_id=new JLabel("房屋编号");
buyer_name=new JLabel("购买者");
seller_name=new JLabel("销售者");
sell_date=new JLabel("销售日期");
sell_value=new JLabel("销售价格");
sid=new JTextField(10);
hid=new JTextField(10);
bname=new JTextField(10);
sname=new JTextField(10);
date=new JTextField(10);
value=new JTextField(10);
btn1=new JButton("修改");
btn2=new JButton("取消");
querybtn=new JButton("显示修改的销售信息");
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
p1.add(sell_id);
p1.add(sid);
p1.add(house_id);
p1.add(hid);
p2.add(sell_value);
p2.add(value);
p2.add(sell_date);
p2.add(date);
p3.add(buyer_name);
p3.add(bname);
p3.add(seller_name);
p3.add(sname);
p4.add(querybtn);
querybtn.addActionListener(this);
p4.add(btn1);
btn1.addActionListener(this);
p4.add(btn2);
btn2.addActionListener(this);
con.setLayout(new FlowLayout());
con.add(p1);
con.add(p2);
con.add(p3);
con.add(p4);
pack();
setBounds(200,200,600,200);
setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
Connection conn;
Statement sql;
ResultSet rs;
String s1=sid.getText().toString().trim();
String s2=hid.getText().toString().trim();
String s3=value.getText().toString().trim();
String s4=date.getText().toString().trim();
String s5=bname.getText().toString().trim();
String s6=sname.getText().toString().trim();
int sum=0;
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ee)
{ System.out.println(""+ee);
}
if(e.getSource()==querybtn)
{
try
{
conn=DriverManager.getConnection("jdbc:odbc:house","","");
sql=conn.createStatement();
rs=sql.executeQuery("SELECT * FROM house_sell where 销售编号='"+s1+"'");
while(rs.next())
{
String sa=rs.getString(1);
String sb=rs.getString(2);
String sc=rs.getString(3);
String sd=rs.getString(4);
String se=rs.getString(5);
String sf=rs.getString(6);
hid.setText(sb);
value.setText(sc);
date.setText(sd);
bname.setText(se);
sname.setText(sf);
sum++;
}
if(sum==0)
{
JOptionPane.showMessageDialog(null,"你要修改的销售信息不存在！");
}
conn.close();
}
catch(SQLException ex)
{ System.out.println(ex);
}
}
if(e.getSource()==btn1)
{
try
{
conn=DriverManager.getConnection("jdbc:odbc:house","","");
sql=conn.createStatement();
sql.executeUpdate("UPDATE house_sell SET 房屋编号='"+s2+"',交易价格='"+s3+"',交易时间='"+s4+"',购买者='"+s5+"',销售者='"+s6+"'WHERE 销售编号='"+s1+"'");
setVisible(false);
JOptionPane.showMessageDialog(null,"你已经成功修改销售信息！");
conn.close();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -