JAVA swing界面实现数据库增删改查.docx
- 文档编号:1765217
- 上传时间:2022-10-23
- 格式:DOCX
- 页数:14
- 大小:89.04KB
JAVA swing界面实现数据库增删改查.docx
《JAVA swing界面实现数据库增删改查.docx》由会员分享,可在线阅读,更多相关《JAVA swing界面实现数据库增删改查.docx(14页珍藏版)》请在冰豆网上搜索。
JAVAswing界面实现数据库增删改查界面实现数据库增删改查数据库程序设计大作业班级:
2012级软件外包服务一班学号:
201215140117姓名:
。
时间:
2013-6-191功能描述1.1功能简介用swing做出图形化界面形式,实现数据库的增删改查把员工表跟部门表连接起来,实现数据的增加,删除,修改,查找。
1.2实现步骤
(1)安装好虚拟机,并在其下确认oracle已安装成功(可以在dos下输入相关命令来检查是否安装成功)。
(2)在网络中心修改pc机上的VMwareNetworkAdapter的IP、子网页码(默认)、网关。
(3)修改虚拟机的IP、网掩码(默认)、网关,确保PC机上的网关和虚拟机的IP一致。
(在控制面板网络和共享中心本地连接3属性中,修改IP、网掩码)(4)在PC机的dos命令控制台ping虚拟机的IP,确保正常,能ping通(即将虚拟机内外ping通)。
(5)配置好虚拟机下的oracle的数据库和监听。
(6)在eclipse中编写相关代码,并用jtable实现图形化界面,用以实现与数据库的连接和操作数据库等功能。
(7)在eclipse中导入数据库的驱动。
(8)运行eclipse,查看运行结果。
2.核心代码2.11.数据库连接packageorg.lxh.info.dbc;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;publicclassDatabaseConnectionpublicstaticvoidmain(Stringargs)Connectionconn=null;Statementstmt=null;ResultSetrs=null;tryClass.forName(oracle.jdbc.driver.OracleDriver);Stringurl=jdbc:
oracle:
thin:
192.168.0.128:
1521/WFJ;conn=DriverManager.getConnection(url,hr,hr);stmt=conn.createStatement();Stringsql=select*fromdepartments;rs=stmt.executeQuery(sql);while(rs.next()System.out.print(rs.getInt(department_id);System.out.print(t);System.out.print(rs.getString(department_name);System.out.print(t);System.out.print(rs.getInt(manager_id);System.out.print(t);System.out.print(rs.getInt(location_id);System.out.println();catch(ClassNotFoundExceptione)e.printStackTrace();catch(SQLExceptione)e.printStackTrace();finallytryif(rs!
=null)rs.close();if(stmt!
=null)stmt.close();if(conn!
=null)conn.close();catch(SQLExceptione)/TODOAuto-generatedcatchblocke.printStackTrace();2.生成getset方法packageedu;publicclassCountryprivateStringdepartment_id;privateStringdepartment_name;privateStringarea;privateStringpopulation;publicStringgetdepartment_id()returndepartment_id;publicvoidsetdepartment_id(Stringdepartment_name)this.name=department_id;publicStringgetdepartment_name()returndepartment_name;publicvoidsetdepartment_name(Stringdepartment_name)this.department_name=department_name;publicStringgetmanager_id()returnmanager_id;publicvoidsetmanager_id(Stringmanager_id)this.manager_id=manager_id;publicStringgetlocation_id()returnlocation_id;publicvoidsetlocation_id(Stringlocation_idn)this.location_id=location_id;3实现方法packagetuxinghua;importjava.awt.Color;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.io.Serializable;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.util.ArrayList;importjava.util.List;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JScrollPane;importjavax.swing.JTable;importjavax.swing.JTextField;importjavax.swing.table.DefaultTableModel;importjava.awt.event.MouseAdapter;importjava.awt.event.MouseEvent;publicclassAppStudentextendsJFrameprivateJTextFielddepartment_idField;privateJTextFielddepartment_nameField;privateJTextFieldmanager_idField;privateJTextFieldlocation_idField;privateJTabletable;privateDefaultTableModelmodel;privateStringcolumns=department_id,department_name,manager_id,location_id;privateListdata;privateStudenttmp;publicAppStudent()data=newArrayList();getContentPane().setLayout(null);JLabellblemployee=newJLabel(department_id);lblemployee.setBounds(12,10,220,13);getContentPane().add(lblemployee);department_idField=newJTextField();department_idField.setBounds(100,7,96,19);getContentPane().add(department_idField);department_idField.setColumns(10);JLabellblAge=newJLabel(department_name);lblAge.setBounds(252,10,220,13);getContentPane().add(lblAge);department_nameField=newJTextField();department_nameField.setBounds(365,7,96,19);getContentPane().add(department_nameField);department_nameField.setColumns(10);JLabellblStuno=newJLabel(manager_id);lblStuno.setBounds(12,36,220,13);getContentPane().add(lblStuno);manager_idField=newJTextField();manager_idField.setColumns(10);manager_idField.setBounds(100,33,96,19);getContentPane().add(manager_idField);JLabellblClass=newJLabel(location_id);lblClass.setBounds(252,36,220,13);getContentPane().add(lblClass);location_idField=newJTextField();location_idField.setColumns(10);location_idField.setBounds(365,33,96,19);getContentPane().add(location_idField);JButtonbtnAdd=newJButton(增加);btnAdd.addActionListener(newActionListener()publicvoidactionPerformed(ActionEvente)add(););btnAdd.setBounds(75,59,77,21);getContentPane().add(btnAdd);JButtonbtnDel=newJButton(删除);btnDel.addActionListener(newActionListener()publicvoidactionPerformed(ActionEvente)del(););btnDel.setBounds(180,59,77,21);getContentPane().add(btnDel);JButtonbtnUpdate=newJButton(更新);btnUpdate.addActionListener(newActionListener()publicvoidactionPerformed(ActionEvente)update(););btnUpdate.setBounds(280,59,77,21);getContentPane().add(btnUpdate);JButtonbtnFind=newJButton(查找);btnFind.addActionListener(newActionListener()publicvoidactionPerformed(ActionEvente)find(););btnFind.setBounds(380,59,
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- JAVA swing界面实现数据库增删改查 swing 界面 实现 数据库 增删