JAVA程序综合设计(数据库设计)_(39页).doc

《JAVA程序综合设计(数据库设计)_(39页).doc》由会员分享，可在线阅读，更多相关《JAVA程序综合设计(数据库设计)_(39页).doc（39页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、-JAVA程序综合设计(数据库设计)_-第 39 页北华大学开放实验报告 实验项目名称: JAVA程序综合设计（数据库设计） 所属课程名称: 面对象程序设计JAVA 实 验 类 型: 设 计 型 班 级: 信 息112 一、 实验目的与要求1. 学会基于JDBC的数据库编程技术2. 了解服务器端和客户端的类3. 学会使用Sever类、GetConnection类、SocketIO和Client类等类的设计。4. 学会运用AWT和Swing组件美化系统用户界面。二、 实验环境 XP操作传统、Eclipse开发环境和JDK6.0三、 实验原理JDBC（Java Data Base Connecti

2、vity,java数据库连接）是一种用于执行SQL语句的Java API，可以为多种关系数据库提供统一访问，它由一组用Java语言编写的类和接口组成。JDBC提供了一种基准，据此可以构建更高级的工具和接口，使数据库开发人员能够编写数据库应用程序。AWT(Abstract Windowing Toolkit)，中文译为抽象窗口工具包，是Java提供的用来建立和设置Java的图形用户界面的基本工具。AWT由Java中的java.awt包提供，里面包含了许多可用来建立与平台无关的图形用户界面(GUI)的类，这些类又被称为组件(components)。Swing是由100%纯Java实现的，Swing

3、组件是用Java实现的轻量级（ light-weight）组件，没有本地代码，不依赖操作系统的支持，这是它与AWT组件的最大区别。四、实验内容1、图书管理系统登录程序代码为：import java.awt.Container;import java.awt.FlowLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.Icon;import javax.swing.ImageIcon;import javax.swing.JApplet;import ja

4、vax.swing.JButton;import javax.swing.JLabel;import javax.swing.JTextField;SuppressWarnings(serial)public class t1 extends JApplet implements ActionListenerContainer cp=getContentPane();Icon ro=new ImageIcon(getClass().getResource(g1.gif);JLabel lb0=new JLabel(,ro,JLabel.CENTER);JLabel lb1=new JLabel

5、();JTextField tf1=new JTextField(10);JLabel lb2=new JLabel(密码：,JLabel.CENTER);JTextField tf2=new JTextField(10);JButton bt1=new JButton(登入);JButton bt2=new JButton(重置);String IP=null;public void init()cp.setLayout(new FlowLayout();cp.add(lb0);cp.add(lb1);lb1.setText(用户名：);cp.add(tf1);cp.add(lb2);cp.

6、add(tf2);cp.add(bt1);bt1.addActionListener(this);cp.add(bt2);bt2.addActionListener(this);public void actionPerformed(ActionEvent e) 运行结果：2、新书订购管理程序代码为：package jihu;import java.awt.EventQueue;import javax.swing.JFrame;import javax.swing.JPanel;import javax.swing.border.EmptyBorder;import java.awt.Fon

7、t;import javax.swing.JLabel;import javax.swing.GroupLayout;import javax.swing.GroupLayout.Alignment;import java.awt.Color;import java.awt.SystemColor;import javax.swing.LayoutStyle.ComponentPlacement;import javax.swing.JTextField;import javax.swing.JRadioButton;import javax.swing.JButton;import java

8、.awt.event.ActionListener;import java.awt.event.ActionEvent;import javax.swing.border.TitledBorder;import javax.swing.UIManager;import javax.swing.JComboBox;public class t2 extends JFrame private static final long serialVersionUID = 4180756712362285535L;private JPanel contentPane;private JTextField

9、textField;private JTextField textField_1;private JTextField textField_2;private JTextField textField_3;private JTextField textField_4;private JTextField textField_5;private JTextField textField_6;public static void main(String args) EventQueue.invokeLater(new Runnable() public void run() try t2 fram

10、e = new t2();frame.setVisible(true);catch (Exception e) e.printStackTrace();public t2() setFont(new Font(华文楷体, Font.BOLD, 16);setTitle(u65B0u4E66u8BA2u8D2Du7BA1u7406);setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);setBounds(100, 100, 627, 410);contentPane = new JPanel();contentPane.setForeground(Col

11、or.CYAN);contentPane.setBorder(new EmptyBorder(5, 5, 5, 5);setContentPane(contentPane);JPanel panel = new JPanel();panel.setBorder(new TitledBorder(UIManager.getBorder(TitledBorder.border), u56FEu4E66u4FE1u606F, TitledBorder.LEADING, TitledBorder.TOP, null, new Color(51, 153, 255);JPanel panel_1 = n

12、ew JPanel();panel_1.setBorder(new TitledBorder(null, u8BA2u8D2Du4FE1u606F, TitledBorder.LEADING, TitledBorder.TOP, null, SystemColor.textHighlight);JButton btnNewButton = new JButton(u6DFBu52A0);btnNewButton.setFont(new Font(宋体, Font.BOLD, 12);JButton btnNewButton_1 = new JButton(u9000u51FA);btnNewB

13、utton_1.addActionListener(new ActionListener() public void actionPerformed(ActionEvent e) btnNewButton_1.setFont(new Font(宋体, Font.BOLD, 12);GroupLayout gl_contentPane = new GroupLayout(contentPane);gl_contentPane.setHorizontalGroup(gl_contentPane.createParallelGroup(Alignment.LEADING).addComponent(

14、panel, GroupLayout.DEFAULT_SIZE, 601, Short.MAX_VALUE).addComponent(panel_1, GroupLayout.DEFAULT_SIZE, 601, Short.MAX_VALUE).addGroup(gl_contentPane.createSequentialGroup().addGap(211).addComponent(btnNewButton).addGap(33).addComponent(btnNewButton_1).addContainerGap(239, Short.MAX_VALUE)gl_contentP

15、ane.setVerticalGroup(gl_contentPane.createParallelGroup(Alignment.LEADING).addGroup(gl_contentPane.createSequentialGroup().addComponent(panel, GroupLayout.PREFERRED_SIZE, 163, GroupLayout.PREFERRED_SIZE).addPreferredGap(ComponentPlacement.RELATED).addComponent(panel_1, GroupLayout.PREFERRED_SIZE, 15

16、3, GroupLayout.PREFERRED_SIZE).addPreferredGap(ComponentPlacement.UNRELATED).addGroup(gl_contentPane.createParallelGroup(Alignment.BASELINE).addComponent(btnNewButton_1).addComponent(btnNewButton).addContainerGap(GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)JLabel lblNewLabel_5 = new JLabel(u8BA2u8D2Du

17、65E5u671FuFF1A);lblNewLabel_5.setFont(new Font(宋体, Font.BOLD, 12);JLabel lblNewLabel_6 = new JLabel(u64CDu4F5Cu5458uFF1A);lblNewLabel_6.setFont(new Font(宋体, Font.BOLD, 12);JLabel lblNewLabel_7 = new JLabel(u6298u6263uFF1A);lblNewLabel_7.setFont(new Font(宋体, Font.BOLD, 12);JLabel lblNewLabel_8 = new

18、JLabel(u8BA2u8D2Du6570u91CFuFF1A);lblNewLabel_8.setFont(new Font(宋体, Font.BOLD, 12);JLabel lblNewLabel_9 = new JLabel(u662Fu5426u9A8Cu6536uFF1A);lblNewLabel_9.setFont(new Font(宋体, Font.BOLD, 12);textField = new JTextField();textField.setColumns(10);textField_1 = new JTextField();textField_1.setBackg

19、round(UIManager.getColor(Button.light);textField_1.setColumns(10);textField_2 = new JTextField();textField_2.setColumns(10);textField_3 = new JTextField();textField_3.setColumns(10);JRadioButton rdbtnNewRadioButton = new JRadioButton(u662F);rdbtnNewRadioButton.setFont(new Font(宋体, Font.BOLD, 12);rdb

20、tnNewRadioButton.setSelected(true);JRadioButton rdbtnNewRadioButton_1 = new JRadioButton(u5426);rdbtnNewRadioButton_1.setFont(new Font(宋体, Font.BOLD, 12);GroupLayout gl_panel_1 = new GroupLayout(panel_1);gl_panel_1.setHorizontalGroup(gl_panel_1.createParallelGroup(Alignment.LEADING).addGroup(gl_pane

21、l_1.createSequentialGroup().addGroup(gl_panel_1.createParallelGroup(Alignment.LEADING).addComponent(lblNewLabel_5).addComponent(lblNewLabel_6).addComponent(lblNewLabel_7).addGap(101).addGroup(gl_panel_1.createParallelGroup(Alignment.LEADING, false).addComponent(textField_2).addComponent(textField, A

22、lignment.TRAILING).addComponent(textField_1, Alignment.TRAILING, GroupLayout.DEFAULT_SIZE, 131, Short.MAX_VALUE).addPreferredGap(ComponentPlacement.RELATED).addGroup(gl_panel_1.createParallelGroup(Alignment.LEADING).addComponent(lblNewLabel_9).addComponent(lblNewLabel_8).addGap(47).addGroup(gl_panel

23、_1.createParallelGroup(Alignment.LEADING).addGroup(gl_panel_1.createSequentialGroup().addComponent(rdbtnNewRadioButton).addGap(18).addComponent(rdbtnNewRadioButton_1).addContainerGap().addComponent(textField_3, GroupLayout.DEFAULT_SIZE, 176, Short.MAX_VALUE)gl_panel_1.setVerticalGroup(gl_panel_1.cre

24、ateParallelGroup(Alignment.LEADING).addGroup(gl_panel_1.createSequentialGroup().addGap(21).addGroup(gl_panel_1.createParallelGroup(Alignment.BASELINE).addComponent(lblNewLabel_5).addComponent(lblNewLabel_8).addComponent(textField, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PRE

25、FERRED_SIZE).addComponent(textField_3, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE).addPreferredGap(ComponentPlacement.RELATED, 13, Short.MAX_VALUE).addGroup(gl_panel_1.createParallelGroup(Alignment.BASELINE).addComponent(lblNewLabel_6).addComponent(lblNewLabel_9

26、).addComponent(textField_1, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE).addComponent(rdbtnNewRadioButton).addComponent(rdbtnNewRadioButton_1).addGap(18).addGroup(gl_panel_1.createParallelGroup(Alignment.BASELINE).addComponent(lblNewLabel_7).addComponent(textFiel

27、d_2, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE).addContainerGap()panel_1.setLayout(gl_panel_1);JLabel lblNewLabel = new JLabel(u4E66u7C4Du7F16u53F7uFF1A);lblNewLabel.setFont(new Font(宋体, Font.BOLD, 12);JLabel lblNewLabel_1 = new JLabel(u56FEu4E66u7C7Bu522BuFF1A

28、);lblNewLabel_1.setFont(new Font(宋体, Font.BOLD, 12);JLabel lblNewLabel_2 = new JLabel(u56FEu4E66u4EF7u683CuFF1A);lblNewLabel_2.setFont(new Font(宋体, Font.BOLD, 12);JLabel lblNewLabel_3 = new JLabel(u56FEu4E66u540Du79F0uFF1A);lblNewLabel_3.setFont(new Font(宋体, Font.BOLD, 12);JLabel lblNewLabel_4 = new

29、 JLabel(u51FAu7248u793EuFF1A);lblNewLabel_4.setFont(new Font(宋体, Font.BOLD, 12);textField_4 = new JTextField();textField_4.setColumns(10);textField_5 = new JTextField();textField_5.setColumns(10);textField_6 = new JTextField();textField_6.setColumns(10);JComboBox comboBox = new JComboBox();JComboBox

30、 comboBox_1 = new JComboBox();GroupLayout gl_panel = new GroupLayout(panel);gl_panel.setHorizontalGroup(gl_panel.createParallelGroup(Alignment.LEADING).addGroup(gl_panel.createSequentialGroup().addGroup(gl_panel.createParallelGroup(Alignment.LEADING).addComponent(lblNewLabel).addComponent(lblNewLabe

31、l_1).addComponent(lblNewLabel_2).addGap(102).addGroup(gl_panel.createParallelGroup(Alignment.TRAILING).addGroup(gl_panel.createSequentialGroup().addGroup(gl_panel.createParallelGroup(Alignment.TRAILING, false).addComponent(comboBox, 0, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE).addComponent(textFiel

32、d_4, GroupLayout.DEFAULT_SIZE, 125, Short.MAX_VALUE).addPreferredGap(ComponentPlacement.UNRELATED).addGroup(gl_panel.createParallelGroup(Alignment.LEADING).addComponent(lblNewLabel_3).addComponent(lblNewLabel_4).addPreferredGap(ComponentPlacement.RELATED, 69, Short.MAX_VALUE).addGroup(gl_panel.creat

33、eParallelGroup(Alignment.LEADING, false).addComponent(comboBox_1, 0, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE).addComponent(textField_5, GroupLayout.DEFAULT_SIZE, 143, Short.MAX_VALUE).addContainerGap().addGroup(gl_panel.createSequentialGroup().addComponent(textField_6, GroupLayout.DEFAULT_SIZE, 12

34、5, Short.MAX_VALUE).addGap(297)gl_panel.setVerticalGroup(gl_panel.createParallelGroup(Alignment.LEADING).addGroup(gl_panel.createSequentialGroup().addContainerGap().addGroup(gl_panel.createParallelGroup(Alignment.BASELINE).addComponent(lblNewLabel).addComponent(lblNewLabel_3).addComponent(textField_

35、4, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE).addComponent(textField_5, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE).addGroup(gl_panel.createParallelGroup(Alignment.LEADING).addGroup(gl_panel.createSequentialGroup().addGap(3

36、0).addGroup(gl_panel.createParallelGroup(Alignment.BASELINE).addComponent(lblNewLabel_1).addComponent(lblNewLabel_4).addComponent(comboBox, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE).addGap(32).addGroup(gl_panel.createParallelGroup(Alignment.BASELINE).addCompon

37、ent(lblNewLabel_2).addComponent(textField_6, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE).addGroup(gl_panel.createSequentialGroup().addGap(18).addComponent(comboBox_1, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE).addContainerG

38、ap(GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)panel.setLayout(gl_panel);contentPane.setLayout(gl_contentPane);运行结果为：3、图书验收程序代码为：import java.awt.EventQueue;import javax.swing.JFrame;import javax.swing.JPanel;import javax.swing.border.EmptyBorder;import javax.swing.GroupLayout;import javax.swing.GroupL

39、ayout.Alignment;import javax.swing.JTable;import java.awt.Font;import javax.swing.LayoutStyle.ComponentPlacement;import javax.swing.JLabel;import javax.swing.JTextField;import javax.swing.JButton;import javax.swing.JRadioButton;import javax.swing.table.DefaultTableModel;import javax.swing.border.Lin

40、eBorder;import java.awt.Color;public class t3 extends JFrame private static final long serialVersionUID = -7319664947163365781L;private JPanel contentPane;private JTable table;private JLabel lblNewLabel;private JLabel lblNewLabel_1;private JLabel lblNewLabel_2;private JLabel lblNewLabel_3;private JL

41、abel lblNewLabel_4;private JLabel lblNewLabel_5;private JLabel lblNewLabel_6;private JLabel lblNewLabel_7;private JLabel lblNewLabel_8;private JTextField textField;private JTextField textField_1;private JTextField textField_2;private JTextField textField_3;private JTextField textField_4;private JTex

42、tField textField_5;private JTextField textField_6;private JTextField textField_7;private JButton btnNewButton;private JButton btnNewButton_1;private JRadioButton rdbtnNewRadioButton;private JRadioButton rdbtnNewRadioButton_1;public static void main(String args) EventQueue.invokeLater(new Runnable()

43、public void run() try t3 frame = new t3();frame.setVisible(true);catch (Exception e) e.printStackTrace();public t3() setFont(new Font(宋体, Font.BOLD, 18);setTitle(u56FEu4E66u9A8Cu6536);setAlwaysOnTop(true);setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);setBounds(100, 100, 632, 396);contentPane = new JPanel();contentPane.setBorder(new EmptyBorder(5, 5, 5, 5);setContentPane(contentPane);table = new JTable();table.setBorder(new LineBorder(new Color(0, 0, 0);table.setModel(new DefaultTableModel(new Object