java房屋租赁系统的设计与实现

java房屋租赁系统的设计与实现java+sql房屋租赁系统例：import java.awt.BorderLayout;import javax.swing.JPanel;import javax.swing.JFrame;import java.awt.Dimension;import java.awt.SystemColor;import javax.swing.JLabel;import java.awt.Rectangle;import javax.swing.SwingConstants;import java.awt.Font;import java.awt.Point;import java.sql.Connection;import java.sql.DriverManager;import java.sql.Statement;import javax.swing.JTextField;import javax.swing.JButton;import database.DatabaseUtil;public class DeleteHouseImformation extends JFrame {private static final long serialVersionUID = 1L; private JPanel jContentPane = 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 JLabel jLabel6 = 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 JButton jButton = null;private JButton jButton1 = null;private JButton jButton2 = null;/*** This is the default constructor*/public DeleteHouseImformation() { super();initialize();}/*** This method initializes this** @return void*/private void initialize() {this.setSize(453, 286);this.setContentPane(getJContentPane()); this.setTitle("删除房屋信息");}/*** This method initializes jContentPane ** @return javax.swing.JPanel*/private JPanel getJContentPane() {if (jContentPane == null) {jLabel6 = new JLabel();jLabel6.setText("HouseStatus：");jLabel6.setSize(new Dimension(97, 18));jLabel6.setHorizontalAlignment(SwingConstants.RIGHT); jLabel6.setLocation(new Point(18, 210));jLabel5 = new JLabel();jLabel5.setText("HouseAddress：");jLabel5.setSize(new Dimension(97, 18));jLabel5.setHorizontalAlignment(SwingConstants.RIGHT); jLabel5.setLocation(new Point(18, 180));jLabel4 = new JLabel();jLabel4.setText("HousseStyle：");jLabel4.setSize(new Dimension(97, 18));jLabel4.setHorizontalAlignment(SwingConstants.RIGHT); jLabel4.setLocation(new Point(18, 150));jLabel3 = new JLabel();jLabel3.setText("MaxNumder：");jLabel3.setSize(new Dimension(97, 18));jLabel3.setHorizontalAlignment(SwingConstants.RIGHT);jLabel3.setLocation(new Point(18, 120));jLabel2 = new JLabel();jLabel2.setText("HouseRent：");jLabel2.setSize(new Dimension(97, 18));jLabel2.setHorizontalAlignment(SwingConstants.RIGHT);jLabel2.setLocation(new Point(18, 90));jLabel1 = new JLabel();jLabel1.setText("HouseID：");jLabel1.setSize(new Dimension(97, 18));jLabel1.setHorizontalAlignment(SwingConstants.RIGHT);jLabel1.setLocation(new Point(18, 60));jLabel = new JLabel();jLabel.setBounds(new Rectangle(75, 11, 295, 41));jLabel.setHorizontalAlignment(SwingConstants.CENTER);jLabel.setHorizontalTextPosition(SwingConstants.CENTER);jLabel.setFont(new Font("\u534e\u6587\u65b0\u9b4f", Font.BOLD, 24));jLabel.setText("请输入要删除的房屋信息");jContentPane = new JPanel();jContentPane.setLayout(null);jContentPane.setBackground(SystemColor.inactiveCaption);jContentPane.setFont(new Font("Dialog", Font.PLAIN, 12)); 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(jLabel6, 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(getJButton(), null);jContentPane.add(getJButton1(), null); jContentPane.add(getJButton2(), null);}return jContentPane;}/*** This method initializes jTextField** @return javax.swing.JTextField*/private JTextField getJTextField() {if (jTextField == null) {jTextField = new JTextField(); jTextField.setLocation(new Point(118, 58)); jTextField.setSize(new Dimension(130, 22)); }return jTextField;}/*** This method initializes jTextField1** @return javax.swing.JTextField*/private JTextField getJTextField1() {if (jTextField1 == null) {jTextField1 = new JTextField();jTextField1.setLocation(new Point(118, 90));jTextField1.setSize(new Dimension(130, 22)); }return jTextField1;}/*** This method initializes jTextField2** @return javax.swing.JTextField*/private JTextField getJTextField2() {if (jTextField2 == null) {jTextField2 = new JTextField();jTextField2.setLocation(new Point(118, 118)); jTextField2.setSize(new Dimension(130, 22)); }return jTextField2;}/*** This method initializes jTextField3** @return javax.swing.JTextField*/private JTextField getJTextField3() {if (jTextField3 == null) {jTextField3 = new JTextField();jTextField3.setLocation(new Point(118, 152)); jTextField3.setSize(new Dimension(130, 22)); }return jTextField3;}/*** This method initializes jTextField4** @return javax.swing.JTextField*/private JTextField getJTextField4() {if (jTextField4 == null) {jTextField4 = new JTextField();jTextField4.setLocation(new Point(118, 182)); jTextField4.setSize(new Dimension(130, 22)); }return jTextField4;}/*** This method initializes jTextField5** @return javax.swing.JTextField*/private JTextField getJTextField5() {if (jTextField5 == null) {jTextField5 = new JTextField();jTextField5.setLocation(new Point(118, 208)); jTextField5.setSize(new Dimension(130, 22)); }return jTextField5;}/*** This method initializes jButton** @return javax.swing.JButton*/private JButton getJButton() {if (jButton == null) {jButton = new JButton();jButton.setLocation(new Point(344, 122));jButton.setText("删除");jButton.setSize(new Dimension(64, 29));jButton.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent e) {//String url ="jdbc:jtds:sqlserver://localhost:1433;DatabaseName=housesystem";Connection con = DatabaseUtil.getConnection();try {//Class.forName("net.sourceforge.jtds.jdbc.Driver");//Connection con =DriverManager.getConnection(url,"sa","123456");Statement stmt = con.createStatement();String HouseID = jTextField.getText();String HouseRent = jTextField1.getText();String MaxNumder =jTextField2.getText();String HousseStyle = jTextField3.getText();String HouseAddress = jTextField4.getText();String HouseStatus = jTextField5.getText();String SQL="DELETE FROM HouseImformation WHERE HouseID=('"+HouseID+"') OR HouseRent=('"+HouseRent+"') OR MaxNumder=('"+MaxNumder+"') OR HousseStyle=('"+HousseStyle+"') OR HouseAddress=('"+HouseAddress+"') ORHouseStatus=('"+HouseStatus+"')";stmt.executeUpdate(SQL);stmt.close();con.close();} catch (Exception ex) {}System.out.println("删除成功！");// TODO Auto-generated Event stub actionPerformed()}});}return jButton;}/*** This method initializes jButton1** @return javax.swing.JButton*/private JButton getJButton1() {if (jButton1 == null) {jButton1 = new JButton();jButton1.setBounds(new Rectangle(348, 159, 64, 29));jButton1.setText("退出");jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent e) {dispose(); // TODO Auto-generated Event stub actionPerformed() }});}return jButton1;}/*** This method initializes jButton2** @return javax.swing.JButton*/private JButton getJButton2() {if (jButton2 == null) {jButton2 = new JButton();jButton2.setText("清空");jButton2.setSize(new Dimension(64, 29));jButton2.setLocation(new Point(350, 199));jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent e) {jTextField.setText("");jTextField1.setText("");jTextField2.setText("");jTextField3.setText("");jTextField4.setText("");jTextField5.setText(""); // TODO Auto-generated Event stub actionPerformed()}});}return jButton2;}} // @jve:decl-index=0:visual-constraint="205,9"。