房屋租赁管理系统源码+数据库脚本

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);