北大青鸟s1结课考试机试一套试题的答案

package untitled1; import java.awt.BorderLayout; import java.awt.Dimension; import java.sql.*; import javax.swing.JOptionPane; import javax.swing.JFrame; import javax.swing.JPanel; import javax.swing.JLabel; import java.awt.*; import javax.swing.JTextField; import javax.swing.JButton; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; /** * <p>Title: </p> * * <p>Description: </p> * * <p>Copyright: Copyright (c) 2008</p> * * <p>Company: </p> * * @author not attributable * @version 1.0 */ public class warestockFrm extends JFrame { JPanel contentPane; JLabel jLabel1 = new JLabel(); JLabel name = new JLabel(); JLabel liang = new JLabel(); JLabel shucu = new JLabel(); JTextField txtName = new JTextField(); JTextField txtLiang = new JTextField(); JButton tianjia = new JButton(); JButton chongzhi = new JButton(); JButton guanbi = new JButton(); DBCon dbc = new DBCon(); ResultSet rs; public warestockFrm() { try { setDefaultCloseOperation(EXIT_ON_CLOSE); jbInit(); } catch (Exception exception) { exception.printStackTrace(); } } /** * Component initialization. * * @throws java.lang.Exception */ private void jbInit() throws Exception { contentPane = (JPanel) getContentPane(); contentPane.setLayout(null); setSize(new Dimension(400, 300)); setTitle("添加变更库存量"); jLabel1.setText("添加库存"); jLabel1.setBounds(new Rectangle(116, 21, 164, 30)); name.setText("商品名称"); name.setBounds(new Rectangle(21, 80, 93, 30)); liang.setText("库存量"); liang.setBounds(new Rectangle(19, 126, 94, 33)); shucu.setBounds(new Rectangle(32, 206, 330, 24)); txtName.setBounds(new Rectangle(109, 80, 202, 30)); txtLiang.setBounds(new Rectangle(109, 124, 203, 31)); tianjia.setBounds(new Rectangle(40, 243, 96, 41)); tianjia.setText("添加"); tianjia.addActionListener(new warestockFrm_tianjia_actionAdapter(this)); chongzhi.setBounds(new Rectangle(159, 243, 96, 41)); chongzhi.setText("重置"); chongzhi.addActionListener(new warestockFrm_chongzhi_actionAdapter(this)); guanbi.setBounds(new Rectangle(280, 241, 96, 41)); guanbi.setText("关闭"); guanbi.addActionListener(new warestockFrm_guanbi_actionAdapter(this)); contentPane.add(jLabel1); contentPane.add(name); contentPane.add(liang); contentPane.add(shucu); contentPane.add(txtName); contentPane.add(txtLiang); contentPane.add(tianjia); contentPane.add(chongzhi); contentPane.add(guanbi); } public void guanbi_actionPerformed(ActionEvent e) { System.exit(0); } public void chongzhi_actionPerformed(ActionEvent e) { txtName.setText(""); txtLiang.setText(""); } public void tianjia_actionPerformed(ActionEvent e) { String name = txtName.getText().trim(); String liang = txtLiang.getText().trim(); int x =0; if(name.equals("") && liang.equals("")) { JOptionPane.showMessageDialog(null,"请输入完整信息","提 示",JOptionPane.WARNING_MESSAGE); return; } try { x = Integer.parseInt(liang); } catch (NumberFormatException ex1) { JOptionPane.showMessageDialog(this,"数量格式输入错误！","错误",JOptionPane.ERROR_MESSAGE); return; } try { String sql = "select wareamount from waretable where warename= '" + name + "'"; dbc.getCon(); rs = dbc.select(sql); if (rs.next()) { int kucun = rs.getInt(1); sql = "update waretable set wareamount = "+(kucun+x)+" where warename = '"+name+"'"; dbc.update(sql); dbc.close(); shucu.setText(name+","+"现在库存量为"+(kucun+x)); JOptionPane.showMessageDialog(null,"添加完成","提 示",JOptionPane.WARNING_MESSAGE); } else { JOptionPane.showMessageDialog(null,"没有该商品","提 示",JOptionPane.WARNING_MESSAGE); } } catch (SQLException ex) { ex.printStackTrace(); } } } class warestockFrm_tianjia_actionAdapter implements ActionListener { private warestockFrm adaptee; warestockFrm_tianjia_actionAdapter(warestockFrm adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.tianjia_actionPerformed(e); } } class warestockFrm_chongzhi_actionAdapter implements ActionListener { private warestockFrm adaptee; warestockFrm_chongzhi_actionAdapter(warestockFrm adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.chongzhi_actionPerformed(e); } } class warestockFrm_guanbi_actionAdapter implements ActionListener { private warestockFrm adaptee; warestockFrm_guanbi_actionAdapter(warestockFrm adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.guanbi_actionPerformed(e); } }