import java.awt.BorderLayout;
import javax.swing.JPanel;
import javax.swing.JFrame;
import java.awt.Font;
import java.awt.Rectangle;
import java.awt.Dimension;
import java.sql.*;
import java.awt.*;
import javax.swing.JButton;
import java.awt.Color;
import java.awt.SystemColor;
import java.awt.ComponentOrientation;
import javax.swing.ImageIcon;
import javax.swing.JTextArea;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.SwingConstants;
import javax.swing.JToolBar;
import javax.swing.JTable;
import javax.swing.JScrollPane;
public class searchRenter extends JFrame {
private Connection connection;
private Statement statement;
private ResultSet resultSet;
private static final long serialVersionUID = 1L;
private JPanel jContentPane = null;
private JButton jButton1 = null;
private JLabel jLabel = null;
private JLabel jLabel1 = null;
private JLabel jLabel2 = null;
private JLabel jLabel3 = null;
private JLabel jLabel4 = null;
private JLabel jLabel5 = null;
private JTextField jTextField = null;
private JTextField jTextField1 = null;
private JTextField jTextField2 = null;
private JTextField jTextField3 = null;
private JTextField jTextField4 = null;
private JTextField jTextField5 = null;
private JLabel jLabel6 = null;
private JButton jButton2 = null;
private JToolBar jJToolBarBar = null;
private JButton jButton = null;
private JTextArea jTextArea = null;
private JButton jButton3 = null;
private JScrollPane jScrollPane = null;
/**
* This is the default constructor
*/
public searchRenter() {
super();
initialize();
}
private void initialize() {
this.setSize(676, 465);
this.setBackground(SystemColor.controlHighlight);
this.setContentPane(getJContentPane());
this.setName("frmae()");
this.setFont(new Font("Dialog", Font.PLAIN, 12));
this.setTitle("租赁者信息查询");
}
private JPanel getJContentPane() {
if (jContentPane == null) {
jLabel6 = new JLabel();
jLabel6.setBounds(new Rectangle(128, 37, 341, 30));
jLabel6.setHorizontalTextPosition(SwingConstants.CENTER);
jLabel6.setHorizontalAlignment(SwingConstants.CENTER);
jLabel6.setBackground(new Color(255, 255, 51));
jLabel6.setForeground(new Color(51, 0, 255));
jLabel6.setText("请输入租赁者的信息进行查询");
jLabel5 = new JLabel();
jLabel5.setBounds(new Rectangle(295, 113, 99, 18));
jLabel5.setText("RPhoneNumber:");
jLabel4 = new JLabel();
jLabel4.setBounds(new Rectangle(20, 116, 63, 18));
jLabel4.setText("RAddress:");
jLabel3 = new JLabel();
jLabel3.setBounds(new Rectangle(366, 77, 65, 18));
jLabel3.setText("RBirthday:");
jLabel2 = new JLabel();
jLabel2.setBounds(new Rectangle(276, 79, 38, 18));
jLabel2.setText("RSex:");
jLabel1 = new JLabel();
jLabel1.setBounds(new Rectangle(147, 79, 51, 18));
jLabel1.setText("RName:");
jLabel = new JLabel();
jLabel.setBounds(new Rectangle(25, 79, 56, 18));
jLabel.setText("RenterID:");
jContentPane = new JPanel();
jContentPane.setLayout(null);
jContentPane.setForeground(Color.lightGray);
jContentPane.setBackground(new Color(0, 255, 51));
jContentPane.add(jLabel, null);
jContentPane.add(jLabel1, null);
jContentPane.add(jLabel2, null);
jContentPane.add(jLabel3, null);
jContentPane.add(jLabel4, null);
jContentPane.add(jLabel5, null);
jContentPane.add(getJTextField(), null);
jContentPane.add(getJTextField1(), null);
jContentPane.add(getJTextField2(), null);
jContentPane.add(getJTextField3(), null);
jContentPane.add(getJTextField4(), null);
jContentPane.add(getJTextField5(), null);
jContentPane.add(jLabel6, null);
jContentPane.add(getJButton2(), null);
jContentPane.add(getJJToolBarBar(), null);
jContentPane.add(getJButton3(), null);
jContentPane.add(getJScrollPane(), null);
}
return jContentPane;
}
/**
* This method initializes jButton1
*
* @return javax.swing.JButton
*/
private JButton getJButton1() {
if (jButton1 == null) {
jButton1 = new JButton();
jButton1.setForeground(new Color(51, 51, 51));
jButton1.setBackground(new Color(238, 238, 238));
jButton1.setBounds(new Rectangle(16, 1, 90, 25));
jButton1.setText("退出");
jButton1.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseEntered(java.awt.event.MouseEvent e) {
jButton1.setBackground(Color.red);
}
public void mouseExited(java.awt.event.MouseEvent e) {
jButton1.setBackground(new Color(238, 238, 238));
// TODO Auto-generated Event stub mouseExited()
}
public void mouseClicked(java.awt.event.MouseEvent e) {
dispose(); // TODO Auto-generated Event stub mouseClicked()
}
});
}
return jButton1;
}
/**
* This method initializes jTextField
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField() {
if (jTextField == null) {
jTextField = new JTextField();
jTextField.setBounds(new Rectangle(84, 79, 59, 22));
}
return jTextField;
}
/**
* This method initializes jTextField1
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField1() {
if (jTextField1 == null) {
jTextField1 = new JTextField();
jTextField1.setBounds(new Rectangle(201, 77, 62, 22));
}
return jTextField1;
}
/**
* This method initializes jTextField2
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField2() {
if (jTextField2 == null) {
jTextField2 = new JTextField();
jTextField2.setBounds(new Rectangle(321, 77, 43, 22));
}
return jTextField2;
}
/**
* This method initializes jTextField3
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField3() {
if (jTextField3 == null) {
jTextField3 = new JTextField();
jTextField3.setBounds(new Rectangle(436, 76, 198, 22));
}
return jTextField3;
}
/**
* This method initializes jTextField4
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField4() {
if (jTextField4 == null) {
jTextField4 = new JTextField();
jTextField4.setBounds(new Rectangle(88, 112, 198, 22));
}
return jTextField4;
}
/**
* This method initializes jTextField5
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField5() {
if (jTextField5 == null) {
jTextField5 = new JTextField();
jTextField5.setBounds(new Rectangle(398, 111, 126, 22));
}
return jTextField5;
}
/**
* This method initializes jButton2
*
* @return javax.swing.JButton
*/
private JButton getJButton2() {
if (jButton2 == null) {
jButton2 = new JButton();
jButton2.setBounds(new Rectangle(549, 109, 89, 20));
jButton2.setBackground(new Color(153, 153, 0));
jButton2.setText("点击查询");
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
String url = "jdbc:jtds:sqlserver://localhost:1433;DatabaseName=housesystem";
try {
Class.forName("net.sourceforge.jtds.jdbc.Driver");
Connection con = DriverManager.getConnection(url,"ss","123456");
Statement stmt = con.createStatement();
String RenterID = jTextField.getText();
String RName = jTextField1.getText();
String RSex = jTextField2.getText();
String RBirthday = jTextField3.getText();
String RAddress = jTextField4.getText();
String RPhoneNumber = jTextField5.getText();
String SQL="SELECT * FROM Renter WHERE RenterID=('"+RenterID+"') OR RName=('"+RName+"') OR RSex=('"+RSex+"') OR RBirthday=('"+RBirthday+"') OR RAddress=('"+RAddress+"') OR RPhoneNumber=('"+RPhoneNumber+"')";
ResultSet rs = stmt.executeQuery(SQL);
房屋租赁系统
5星 · 超过95%的资源 需积分: 50 17 浏览量
2012-09-20
20:12:26
上传
评论 3
收藏 327KB RAR 举报 
房屋租赁系统 （126个子文件） 
searchRenter.class 7KB MainClass.class 7KB UpdateRenter.class 6KB HouseImformation.class 6KB HouseImformation.class 6KB UpdateRenter.class 6KB Renter.class 6KB UpdateHouseOwner.class 6KB DeleteHouseImformation.class 6KB Renter.class 6KB UpdateHouseImformation.class 6KB DeleteRenter.class 6KB HouseOwner.class 6KB UpdateHouseImformation.class 6KB HouseOwner.class 6KB UpdateHouseOwner.class 5KB DeleteHouseOwner.class 5KB searchHouseOwner.class 5KB HouseSystem.class 4KB searchHouseImformation.class 3KB searchRenter$2.class 3KB ShowRenter.class 3KB ShowHouseImformation.class 3KB ShowHomeowners.class 3KB UpdateHouseImformation$1.class 2KB UpdateRenter$1.class 2KB searchRenter$3.class 2KB UpdateHouseOwner$1.class 2KB searchRenter$4.class 2KB HouseImformation$1.class 2KB searchHouseImformation$2.class 2KB DeleteRenter$2.class 2KB UpdateHouseImformation$1.class 2KB searchHouseOwner$1.class 2KB DeleteHouseOwner$1.class 2KB DeleteHouseImformation$1.class 2KB HouseImformation$1.class 2KB UpdateRenter$1.class 2KB UpdateHouseOwner$1.class 2KB Renter$1.class 2KB HouseOwner$1.class 2KB HouseOwner$1.class 2KB Renter$1.class 2KB DatabaseUtil.class 1KB UpdateHouseImformation$3.class 1KB searchRenter$1.class 1KB DeleteHouseImformation$3.class 1KB HouseImformation$3.class 1KB UpdateHouseImformation$3.class 1KB UpdateRenter$3.class 1KB UpdateRenter$3.class 1KB UpdateHouseOwner$3.class 1KB UpdateHouseOwner$3.class 1022B HouseImformation$3.class 1022B DeleteRenter$3.class 994B Renter$3.class 994B HouseOwner$3.class 985B DeleteHouseOwner$3.class 985B Renter$3.class 952B HouseOwner$3.class 943B UpdateHouseImformation$2.class 777B UpdateHouseImformation$2.class 742B DeleteHouseImformation$2.class 742B UpdateHouseOwner$2.class 741B searchHouseImformation$1.class 732B HouseSystem$3.class 730B HouseSystem$1.class 726B MainClass$11.class 725B MainClass$10.class 718B UpdateRenter$2.class 717B MainClass$2.class 716B MainClass$8.class 715B MainClass$12.class 715B searchHouseImformation$3.class 711B HouseImformation$2.class 710B MainClass$1.class 709B MainClass$7.class 709B MainClass$13.class 708B MainClass$3.class 706B DeleteHouseOwner$2.class 706B UpdateHouseOwner$2.class 706B MainClass$9.class 705B HouseSystem$4.class 703B HouseSystem$2.class 699B MainClass$5.class 690B ShowHouseImformation$1.class 687B MainClass$4.class 684B UpdateRenter$2.class 682B Renter$2.class 681B MainClass$6.class 680B HouseImformation$2.class 675B searchHouseOwner$2.class 675B HouseOwner$2.class 674B ShowHomeowners$1.class 651B DeleteRenter$1.class 651B Renter$2.class 646B HouseOwner$2.class 639B ShowRenter$1.class 627B .classpath 288B searchRenter.java 12KB共 126 条
- 1
- 2
- 1
- 2
- 3
前往页