📄 house.java
字号:
}
catch(SQLException ex)
{ System.out.println(ex);
}
}
if(e.getSource()==btn2){setVisible(false);}
}
}
////////////////////浏览全部房屋信息////////////////////////
class V_House extends JFrame
{
V_House(String s)
{super(s);
Container con=getContentPane();
con.setLayout(new BorderLayout());
JTextArea te=new JTextArea();
JScrollPane croll=new JScrollPane(te);
con.add(croll,BorderLayout.CENTER);
Connection conn;
Statement sql;
ResultSet rs;
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 house");
if( rs.next()==false)
{te.append("");
te.append("数据库中的记录为0!");}
else
while(rs.next())
{
te.append("房屋编号: "+rs.getString(1)+" ");
te.append("房屋地址: "+rs.getString(2)+" ");
te.append("房屋朝向: "+rs.getString(3)+" ");
te.append("房屋类型: "+rs.getString(4)+" ");
te.append("房屋面积: "+rs.getString(5)+" ");
te.append("房屋价格: "+rs.getString(6)+" ");
te.append("\n");
}
conn.close();
}
catch(SQLException ex)
{ System.out.println(ex);}
setVisible(true);
setBounds(200,200,550,500);
}
};
////////////////////修改房屋信息////////////////////////
class Change_House 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_House(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=bname.getText().toString().trim();
String s4=sname.getText().toString().trim();
String s5=date.getText().toString().trim();
String s6=value.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 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);
bname.setText(sc);
sname.setText(sd);
date.setText(se);
value.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 SET 房屋地址='"+s2+"',房屋朝向='"+s3+"',房屋类型='"+s4+"',房屋面积='"+s5+"',房屋价格='"+s6+"'WHERE 房屋编号='"+s1+"'");
setVisible(false);
JOptionPane.showMessageDialog(null,"你已经成功修改房屋信息！");
conn.close();
}
catch(SQLException ex)
{ System.out.println(ex);
}
}
if(e.getSource()==btn2){setVisible(false);}
}
}
////////////////////删除房屋信息/////////////////////////
class Del_House extends JFrame implements ActionListener
{
private JLabel label;
private JTextField text;
private JButton button1,button2;
private JPanel p;
Del_House(String s)
{
super(s);
Container con=getContentPane();
con.setLayout(new BorderLayout());
label=new JLabel("房屋编号");
text=new JTextField("输入删除的房屋编号",10);
button1=new JButton("删除");
button2=new JButton("取消");
p=new JPanel();
p.add(label);
p.add(text);
p.add(button1);
button1.addActionListener(this);
p.add(button2);
button2.addActionListener(this);
con.add("Center",p);
setVisible(true);
setBounds(250,250,400,80);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==button1)
{
Connection conn;
Statement sql;
ResultSet rs;
int sum=0;
String house_number=text.getText().toString().trim();
if(house_number.equals(""))
{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 house where 房屋编号='"+house_number+"'");
while(rs.next())
{sum++;}
if(sum==0){JOptionPane.showMessageDialog(null,"没有你想删除的房屋信息！");}
else
{
sql.executeUpdate("DELETE * FROM house WHERE 房屋编号='"+house_number+"'");
setVisible(false);
JOptionPane.showMessageDialog(null,"你已成功删除房屋信息");
}
conn.close();
}
catch(SQLException ex)
{ System.out.println(ex);}
}
}
else
{setVisible(false);}
}
}
//////////////////////
class V_Sell extends JFrame
{
V_Sell(String s)
{super(s);
Container con=getContentPane();
con.setLayout(new BorderLayout());
JTextArea te=new JTextArea();
JScrollPane croll=new JScrollPane(te);
con.add(croll,BorderLayout.CENTER);
Connection conn;
Statement sql;
ResultSet rs;
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 house_sell");
if( rs.next()==false)
{te.append("");
te.append("数据库中的记录为0!");}
else
while(rs.next())
{
te.append("销售编号: "+rs.getString(1)+" ");
te.append("房屋编号: "+rs.getString(2)+" ");
te.append("交易价格: "+rs.getString(3)+" ");
te.append("交易日期: "+rs.getString(4)+" ");
te.append("购买者: "+rs.getString(5)+" ");
te.append("销售者: "+rs.getString(6)+" ");
te.append("\n");
}
conn.close();
}
catch(SQLException ex)
{ System.out.println(ex);}
setVisible(true);
setBounds(200,200,550,500);
}
};
////////////////////添加房屋销售信息/////////////////////
class Add_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;
Container con=getContentPane();
Add_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("2007-12-30",10);
value=new JTextField(10);
btn1=new JButton("保存");
btn2=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(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,400,200);
setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==btn1)
{
Connection conn;
Statement sql;
ResultSet rs;
String s1=sid.getText().toString().trim();
String s2=hid.getText().toString().trim();
String s3=bname.getText().toString().trim();
String s4=sname.getText().toString().trim();
String s5=date.getText().toString().trim();
String s6=value.getText().toString().trim();
int sum=0;
if(s1.equals(""))
{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 house_sell where 销售编号='"+s1+"'");
while(rs.next())
{
sum++;
}
if(sum==1)
{
JOptionPane.showMessageDialog(null,"销售编号已经存在，请使用其他编号!");
}
else
{
sql.executeUpdate("INSERT INTO house_sell VALUES('"+s1+"','"+s2+"','"+s3+"','"+s4+"','"+s5+"','"+s6+"')");
setVisible(false);
JOptionPane.showMessageDialog(null,"你已经成功添加房屋销售信息！");
}
conn.close();
}
catch(SQLException ex)
{ System.out.println(ex);
}
}
}
else{setVisible(false);}
}
}
/////////////////////////删除销售信息////////////////
class Del_Sell extends JFrame implements ActionListener
{
private JLabel label;
private JTextField text;
private JButton button1,button2;
private JPanel p;
Del_Sell(String s)
{
super(s);
Container con=getContentPane();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -