• 大小: 556KB
    文件类型: .zip
    金币: 1
    下载: 0 次
    发布日期: 2021-05-14
  • 语言: Java
  • 标签: Java  使用sql  简单  

资源简介

基于Java的源代码 使用时只需要需要自己建立一个数据库并连接即可,数据源我定的adminDB 可自己改,数据库名可自己设,表名也可自己设,但是不要忘了修改代码中的名字哦!

资源截图

代码片段和文件信息

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

public class Addcoach extends JPanel implements ActionListener{
private JLabel coachidcoachnamecoachsexagecoachbirthdaycoachclass;
private JTextField idtxtnametxtsextxtagetxtbirthdaytxtclasstxt;
private JButton tjqx;
private ImageIcon image;
private JLabel imglbl;
DBmanager db;

public Addcoach(){
this.setLayout(null);

coachid=new JLabel(“教练ID“);
coachname=new JLabel(“姓      名“);
coachsex=new JLabel(“性      别“);
age=new JLabel(“年      龄“);
coachbirthday=new JLabel(“生日“);
coachclass=new JLabel(“课程“);
idtxt=new JTextField(50);
nametxt=new JTextField(50);
sextxt=new JTextField(50);
agetxt=new JTextField(50);
birthdaytxt=new JTextField(50);
classtxt=new JTextField(80);

tj=new JButton(“添加“);
qx=new JButton(“取消“);

coachid.setBounds(704010040);
coachname.setBounds(7010010040);
coachsex.setBounds(7016010040);
age.setBounds(7022010040);
coachbirthday.setBounds(7028010040);
coachclass.setBounds(7034010040);
idtxt.setBounds(1504015040);
nametxt.setBounds(15010015040);
sextxt.setBounds(15016015040);
agetxt.setBounds(15022015040);
birthdaytxt.setBounds(15028015040);
classtxt.setBounds(15034018040);
tj.setBounds(7040010040);
qx.setBounds(20040010040);

add(coachid);
add(idtxt);
add(coachname);
add(nametxt);
add(coachsex);
add(sextxt);
add(age);
add(agetxt);
add(coachbirthday);
add(birthdaytxt);
add(coachclass);
add(classtxt);
add(tj);
add(qx);

image=new ImageIcon(“coach.jpg“);
imglbl=new JLabel(image);
imglbl.setBounds(00image.getIconWidth()image.getIconHeight());
add(imglblnew Integer(Integer.MIN_VALUE));
setOpaque(false);

tj.addActionListener(this);
qx.addActionListener(this);

setSize(600600);
setVisible(true);
}
public void actionPerformed(ActionEvent e){
if(e.getSource()==qx){
idtxt.setText(““);
nametxt.setText(““);
sextxt.setText(““);
agetxt.setText(““);
birthdaytxt.setText(““);
classtxt.setText(““);
}else{
if(idtxt.getText().equals(““)||nametxt.getText().equals(““)||sextxt.getText().equals(““)||agetxt.getText().equals(““)||birthdaytxt.getText().equals(““)||classtxt.getText().equals(““))
JOptionPane.showMessageDialog(null “教练信息不完整!“);
else{
db=new DBmanager();
String sql=“insert into coach values(‘“+idtxt.getText()+“‘‘“+nametxt.getText()+“‘‘“+sextxt.getText()+“‘‘“+agetxt.getText()+“‘‘“+birthdaytxt.getText()+“‘‘“+classtxt.getText()+“‘)“;
if(db.updatesql(sql)){
JOptionPane.showMessageDialog(null “添加成功!“);
idtxt.setText(““);
nametxt.setText(““);
sextxt.setText(““);
agetxt.setText(““);
birthdaytxt.setText(““);
classtxt.setText(““);
}
else{
JOptionPane.showMessageDialog(null “添加失败!“);

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2014-11-06 21:41  HealthClub\
     文件         301  2014-10-26 15:08  HealthClub\.classpath
     文件         386  2014-10-26 15:08  HealthClub\.project
     目录           0  2014-11-01 15:50  HealthClub\.settings\
     文件         598  2014-10-26 15:08  HealthClub\.settings\org.eclipse.jdt.core.prefs
     目录           0  2014-11-07 15:15  HealthClub\bin\
     文件        1032  2014-11-07 16:14  HealthClub\bin\Addcoach.class
     文件        3495  2014-11-07 15:15  HealthClub\bin\Addequipment.class
     文件        4245  2014-11-07 15:15  HealthClub\bin\Addstuff.class
     文件        1792  2014-11-07 15:37  HealthClub\bin\Addvip.class
     文件        6499  2014-11-07 15:15  HealthClub\bin\Adminmain.class
     文件        1570  2014-11-07 15:15  HealthClub\bin\DBmanager.class
     文件        4467  2014-11-07 15:15  HealthClub\bin\Delcoach.class
     文件        3811  2014-11-07 15:15  HealthClub\bin\Delequipment.class
     文件        4811  2014-11-07 15:15  HealthClub\bin\Delstuff.class
     文件        4711  2014-11-07 15:15  HealthClub\bin\Delvip.class
     文件        1065  2014-11-07 15:15  HealthClub\bin\Inquirecoach$1.class
     文件        4339  2014-11-07 15:15  HealthClub\bin\Inquirecoach.class
     文件        1093  2014-11-07 15:15  HealthClub\bin\Inquireequipment$1.class
     文件        4261  2014-11-07 15:15  HealthClub\bin\Inquireequipment.class
     文件        1065  2014-11-07 15:15  HealthClub\bin\Inquirestuff$1.class
     文件        4383  2014-11-07 15:15  HealthClub\bin\Inquirestuff.class
     文件        1051  2014-11-07 15:15  HealthClub\bin\Inquirevip$1.class
     文件        4131  2014-11-07 15:15  HealthClub\bin\Inquirevip.class
     文件        5562  2014-11-07 15:15  HealthClub\bin\Login.class
     文件        4573  2014-11-07 15:15  HealthClub\bin\Updatecoach.class
     文件        4098  2014-11-07 15:15  HealthClub\bin\Updateequipment.class
     文件        4937  2014-11-07 15:15  HealthClub\bin\Updatestuff.class
     文件        4831  2014-11-07 15:15  HealthClub\bin\Updatevip.class
     文件        5612  2014-11-07 15:15  HealthClub\bin\VIPmain.class
     文件       68124  2014-11-06 21:41  HealthClub\coach.jpg
............此处省略25个文件信息

评论

共有 条评论