实验室设备管理系统(软件工程试验完整版)

import java.io.*; import java.net.*; import java.sql.*; import java.lang.*; import javax.sql.*;

import java.awt.*; import java.awt.event.*; import javax.swing.*;

import com.borland.jbcl.layout.*; import com.borland.dbswing.*;

public class Frame2 extends JFrame { JPanel contentPane;

JLabel jLabel1 = new JLabel(); XYLayout xYLayout1 = new XYLayout(); JLabel jLabel2 = new JLabel(); JLabel jLabel3 = new JLabel();

JTextField jTextField1 = new JTextField(); JLabel jLabel4 = new JLabel();

JTextField jTextField2 = new JTextField(); JPanel jPanel1 = new JPanel(); XYLayout xYLayout2 = new XYLayout();

JScrollPane jScrollPane1 = new JScrollPane(); JLabel jLabel5 = new JLabel();

JTextField jTextField3 = new JTextField(); public Frame2() {

enableEvents(AWTEvent.WINDOW_EVENT_MASK); try { jbInit(); }

catch(Exception e) { e.printStackTrace(); } }

private void jbInit() throws Exception { contentPane = (JPanel) this.getContentPane(); contentPane.setLayout(xYLayout1); this.setSize(new Dimension(600, 500)); this.setTitle(\实验室设备管理系统\); this.addHierarchyBoundsListener(new Frame2_this_hierarchyBoundsAdapter(this));

jLabel1.setFont(new java.awt.Font(\, 0, 25));

jLabel1.setForeground(Color.red); jLabel1.setText(\实验室设备管理系统\);

contentPane.setForeground(Color.black);

jLabel2.setFont(new java.awt.Font(\, 0, 30)); jLabel2.setText(\设备查询\);

// statusBar.setFont(new java.awt.Font(\ jLabel3.setFont(new java.awt.Font(\, 0, 20)); jLabel3.setText(\设备名称\); jTextField1.setText(\); jLabel4.setEnabled(true);

jLabel4.setFont(new java.awt.Font(\, 0, 20)); jLabel4.setText(\设备型号\); jTextField2.setText(\);

jTextField2.addActionListener(new Frame2_jTextField2_actionAdapter(this)); jPanel1.setLayout(xYLayout2);

jLabel5.setFont(new java.awt.Font(\, 0, 25)); jLabel5.setForeground(Color.red); jLabel5.setText(\该设备详细信息\); jTextField3.setText(\);

contentPane.add(jLabel1, new XYConstraints(200, 0, 300,50)); contentPane.add(jLabel2, new XYConstraints(200, 47, 231, 58)); contentPane.add(jLabel3, new XYConstraints(47, 102, 101, 42)); contentPane.add(jTextField1, new XYConstraints(128, 108, 112, 34));

contentPane.add(jTextField2, new XYConstraints(361, 107, 109, 36));

contentPane.add(jPanel1, new XYConstraints(75, 166, 453, 277)); jPanel1.add(jScrollPane1, new XYConstraints(14, 8, 433, 221)); jScrollPane1.getViewport().add(jTextField3, null);

jPanel1.add(jLabel5, new XYConstraints(112, 240, -1, -1)); contentPane.add(jLabel4, new XYConstraints(278, 111, -1, -1)); }

protected void processWindowEvent(WindowEvent e) { super.processWindowEvent(e);

if (e.getID() == WindowEvent.WINDOW_CLOSING) { System.exit(0); } }

void Select() { try {

String str1, str2;

str1 = jTextField1.getText(); str2 = jTextField2.getText(); Connection con = null;

String url = \; String user = \; String password = \;

Class.forName(\);

con = DriverManager.getConnection(url,user,password); Statement stmt =con.createStatement();

PreparedStatement pstmt = con.prepareStatement(

\设备基本信息 where 设备型号=? and 设备名=? \);

pstmt.setString(2, str1); pstmt.setString(1, str2);

ResultSet res = pstmt.executeQuery();

String id; String name;

String guige,danjia,day,changjia,peo,num;

String outputarea=\设备型号 \ +\设备名称 \+\规格 \+\

单价 \+\购买日期 \+\生产厂家 \+\数量 \+\责任人 \+'\\n';

if(res.next()){ } else{

jTextField3.setText(\不存在\); }

do{ }

while(res.next());

id = res.getString(1); name = res.getString(2); guige = res.getString(3); danjia = res.getString(4); day=res.getString(5);

changjia = res.getString(6); peo=res.getString(7); num=res.getString(8);

outputarea+=\+id+\+name+\+guige+\+danjia+\jTextField3.setText(outputarea);

\+day+\+changjia+\+peo+\+num+\+\;

}catch (ClassNotFoundException e) { System.out.println(e.getMessage()); }catch (SQLException edd) { edd.printStackTrace() ;

System.out.println(edd.getMessage()); } }

void this_ancestorMoved(HierarchyEvent e) { }

void jTextField2_actionPerformed(ActionEvent e) { Select(); } }

class Frame2_this_hierarchyBoundsAdapter extends java.awt.event.HierarchyBoundsAdapter { Frame2 adaptee;

Frame2_this_hierarchyBoundsAdapter(Frame2 adaptee) { this.adaptee = adaptee; }

public void ancestorMoved(HierarchyEvent e) { adaptee.this_ancestorMoved(e); } }

class Frame2_jTextField2_actionAdapter implements java.awt.event.ActionListener { Frame2 adaptee;

Frame2_jTextField2_actionAdapter(Frame2 adaptee) { this.adaptee = adaptee; }

public void actionPerformed(ActionEvent e) { adaptee.jTextField2_actionPerformed(e); } }