Java课程设计人事管理系统的设计与实现Word文档格式.docx
- 文档编号:21297632
- 上传时间:2023-01-29
- 格式:DOCX
- 页数:16
- 大小:217.37KB
Java课程设计人事管理系统的设计与实现Word文档格式.docx
《Java课程设计人事管理系统的设计与实现Word文档格式.docx》由会员分享,可在线阅读,更多相关《Java课程设计人事管理系统的设计与实现Word文档格式.docx(16页珍藏版)》请在冰豆网上搜索。
Stringuser=jTextField1.getText().trim();
Stringpassword=jTextField2.getText().trim();
if(user.equals("
wsm"
)&
&
password.equals("
)){
newyuangongxinxiguanli().setVisible(true);
setVisible(false);
}else{
JOptionPane.showMessageDialog(null,"
请正确输入!
"
);
}
publicstaticvoidmain(Stringargs[]){
java.awt.EventQueue.invokeLater(newRunnable(){
publicvoidrun(){
newdenglu().setVisible(true);
});
员工信息关系系统界面:
package人事管理系统;
publicclassyuangongxinxiguanliextendsjavax.swing.JFrame{
publicyuangongxinxiguanli(){
initComponents();
setLocation(450,220);
@SuppressWarnings("
unchecked"
)
//<
editor-folddefaultstate="
collapsed"
desc="
GeneratedCode"
>
privatevoidinitComponents(){
jButton1=newjavax.swing.JButton();
jButton2=newjavax.swing.JButton();
jButton3=newjavax.swing.JButton();
jLabel1=newjavax.swing.JLabel();
jButton4=newjavax.swing.JButton();
jButton5=newjavax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jButton1.setText("
查询员工信息"
jButton1.addActionListener(newjava.awt.event.ActionListener(){
publicvoidactionPerformed(java.awt.event.ActionEventevt){
jButton1ActionPerformed(evt);
jButton2.setText("
添加员工信息"
jButton2.addActionListener(newjava.awt.event.ActionListener(){
jButton2ActionPerformed(evt);
jButton3.setText("
删除员工信息"
jButton3.addActionListener(newjava.awt.event.ActionListener(){
jButton3ActionPerformed(evt);
jLabel1.setFont(newjava.awt.Font("
宋体"
0,24));
//NOI18N
jLabel1.setText("
员工信息管理系统"
jButton4.setText("
修改员工信息"
jButton4.addActionListener(newjava.awt.event.ActionListener(){
jButton4ActionPerformed(evt);
jButton5.setText("
退出系统"
jButton5.addActionListener(newjava.awt.event.ActionListener(){
jButton5ActionPerformed(evt);
javax.swing.GroupLayoutlayout=newjavax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(91,91,91)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,false)
.addComponent(jButton1,javax.swing.GroupLayout.DEFAULT_SIZE,javax.swing.GroupLayout.DEFAULT_SIZE,Short.MAX_VALUE)
.addComponent(jButton4,javax.swing.GroupLayout.DEFAULT_SIZE,javax.swing.GroupLayout.DEFAULT_SIZE,Short.MAX_VALUE)
.addComponent(jButton2,javax.swing.GroupLayout.DEFAULT_SIZE,javax.swing.GroupLayout.DEFAULT_SIZE,Short.MAX_VALUE)
.addComponent(jButton3,javax.swing.GroupLayout.DEFAULT_SIZE,javax.swing.GroupLayout.DEFAULT_SIZE,Short.MAX_VALUE)
.addComponent(jButton5,javax.swing.GroupLayout.DEFAULT_SIZE,javax.swing.GroupLayout.DEFAULT_SIZE,Short.MAX_VALUE)))
.addGap(47,47,47)
.addComponent(jLabel1)))
.addContainerGap(52,Short.MAX_VALUE))
);
layout.setVerticalGroup(
.addGap(14,14,14)
.addComponent(jLabel1,javax.swing.GroupLayout.PREFERRED_SIZE,37,javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18,18,18)
.addComponent(jButton1,javax.swing.GroupLayout.PREFERRED_SIZE,33,javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jButton2,javax.swing.GroupLayout.PREFERRED_SIZE,32,javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton4,javax.swing.GroupLayout.PREFERRED_SIZE,34,javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton3,javax.swing.GroupLayout.PREFERRED_SIZE,31,javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton5,javax.swing.GroupLayout.PREFERRED_SIZE,33,javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(36,Short.MAX_VALUE))
pack();
}//<
/editor-fold>
chaxunch=newchaxun();
ch.setVisible(true);
ch.setLocation(400,220);
privatevoidjButton2ActionPerformed(java.awt.event.ActionEventevt){
tianjiati=newtianjia();
ti.setVisible(true);
ti.setLocation(400,220);
//TODOaddyourhandlingcodehere:
privatevoidjButton4ActionPerformed(java.awt.event.ActionEventevt){
xiugaixi=newxiugai();
xi.setVisible(true);
xi.setLocation(400,220);
privatevoidjButton3ActionPerformed(java.awt.event.ActionEventevt){
shanchush=newshanchu();
sh.setVisible(true);
sh.setLocation(400,220);
privatevoidjButton5ActionPerformed(java.awt.event.ActionEventevt){
System.exit(0);
//Variablesdeclaration-donotmodify
privatejavax.swing.JButtonjButton1;
privatejavax.swing.JButtonjButton2;
privatejavax.swing.JButtonjButton3;
privatejavax.swing.JButtonjButton4;
privatejavax.swing.JButtonjButton5;
privatejavax.swing.JLabeljLabel1;
//Endofvariablesdeclaration
}
查询按钮代码:
可选择项查询按钮代码:
try{
Stringxuanze=jComboBox1.getSelectedItem().toString().trim();
Stringtianxie=jTextField1.getText().trim();
Class.forName("
com.microsoft.jdbc.sqlserver.SQLServerDriver"
Stringurl="
jdbc:
microsoft:
sqlserver:
+"
//127.0.0.1:
1433;
DatabaseName=员工信息管理库"
;
Connectioncon=DriverManager.getConnection(url,"
sa"
"
900526"
java.sql.Statementstmt=con.createStatement();
ResultSetrs=stmt.executeQuery("
select*from员工where"
+xuanze+"
='
+tianxie+"
'
DefaultTableModeldt=(DefaultTableModel)jTable1.getModel();
dt.getDataVector().clear();
dt.fireTableDataChanged();
while(rs.next())
{Vectorv1=newVector();
v1.add(rs.getString
(1));
v1.add(rs.getString
(2));
v1.add(rs.getString(3));
v1.add(rs.getString(4));
v1.add(rs.getString(5));
v1.add(rs.getString(6));
v1.add(rs.getString(7));
dt.addRow(v1);
rs.close();
stmt.close();
con.close();
}catch(ClassNotFoundExceptionex){
ex.getMessage();
}catch(SQLExceptionex){
查询全部信息按钮代码:
try{
select*from员工"
Logger.getLogger(chaxun.class.getName()).log(Level.SEVERE,null,ex);
newchaxun().setVisible(true);
添加界面代码:
try{
Stringyuangonghao=jtf_yuangonghao.getText().trim();
Stringphonenumber=jtf_phonenumber.getText().trim();
Stringname=jtf_name.getText().trim();
Stringage=jtf_age.getText().trim();
Stringsex=jtf_sex.getText().trim();
Stringpost=jtf_post.getText().trim();
Stringpay=jtf_pay.getText().trim();
Stringurl="
Connectioncon=DriverManager.getConnection(url,"
"
Stringstr="
insertinto员工values(?
?
)"
PreparedStatementstmt=con.prepareStatement(str);
stmt.setString(1,yuangonghao);
stmt.setString(2,name);
stmt.setString(3,age);
stmt.setString(4,sex);
stmt.setString(5,post);
stmt.setString(6,phonenumber);
stmt.setString(7,pay);
ResultSetrs=stmt.executeQuery();
}catch(SQLExceptionex){
if(ex.getSQLState().equals("
HY000"
添加成功"
if((ex.getSQLState().equals("
23000"
))){
JOptionPan
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Java 课程设计 人事管理系统 设计 实现
![提示](https://static.bdocx.com/images/bang_tan.gif)