java添加（修改）一段查询数据库并返回的代码

Question

java数据库

Answer 1

class CEdit extends JDialog implements ActionListener{
String number="",name="",gender="",classname="";
int age=0,score=0;
JLabel label1,label2,label3,label4,label5,label6;
JTextField tf1,tf2,tf3,tf4,tf5,tf6;
JButton button1,button2;
Object data[]=new Object[6];
Boolean EditTF=false;

CEdit(Frame parent,Object a[]){
super(parent,true);
data=a;
setTitle("添加学生记录");
this.setSize(300,400);
setLocationRelativeTo(parent);
this.addWindowListener(new WindowAdapter(){
      public void windowActivated(WindowEvent e){
      //tf1.requestFocus();//设置初始化焦点位置
      }
      public void windowOpened(WindowEvent e){
      tf1.requestFocus();//设置初始化焦点位置
      }
      });

label1=new JLabel("学号:");
label2=new JLabel("姓名:");
label3=new JLabel("性别:");
label4=new JLabel("年龄:");
label5=new JLabel("班级:");
label6=new JLabel("Java成绩:");
tf1=new JTextField();
tf2=new JTextField();
tf3=new JTextField();
tf4=new JTextField();
    tf5=new JTextField();
tf6=new JTextField();
button1=new JButton("提交");
button2=new JButton("重置");
button1.addActionListener(this);
button2.addActionListener(this);

Container ct=getContentPane();
ct.setLayout(null);//使用自定义布局

label1.setBounds(20,20,80,40);
label2.setBounds(20,70,80,40);
label3.setBounds(20,120,80,40);
label4.setBounds(20,170,80,40);
label5.setBounds(20,220,80,40);
label6.setBounds(20,270,80,40);

tf1.setBounds(120,20,160,40);
tf2.setBounds(120,70,160,40);
tf3.setBounds(120,120,160,40);
tf4.setBounds(120,170,160,40);
tf5.setBounds(120,220,160,40);
tf6.setBounds(120,270,160,40);
button1.setBounds(60,320,80,30);
button2.setBounds(160,320,80,30);

tf1.setText((String)data[0]);
tf2.setText((String)data[1]);
tf3.setText((String)data[2]);
tf4.setText((String)data[3]);
tf5.setText((String)data[4]);
tf6.setText((String)data[5]);

ct.add(label1);//加入标签
ct.add(tf1);//加入文本框
ct.add(label2);
ct.add(tf2);
ct.add(label3);
ct.add(tf3);
ct.add(label4);
ct.add(tf4);
ct.add(label5);
ct.add(tf5);
ct.add(label6);
ct.add(tf6);
ct.add(button1);//加入按钮
ct.add(button2);

setVisible(true);
}

public void actionPerformed(ActionEvent ent){
if(ent.getSource()==button1){
number=tf1.getText().trim();
name=tf2.getText().trim();
gender=tf3.getText().trim();
String sage=tf4.getText().trim();
if(!sage.equals(""))age=Integer.parseInt(sage);
classname=tf5.getText().trim();
String sscore=tf6.getText().trim();
if(!sscore.equals(""))score=Integer.parseInt(sscore);
if(number.equals("")){
JOptionPane.showMessageDialog(this,"学号不能为空","错误提示",JOptionPane.WARNING_MESSAGE);
tf1.requestFocus();
return;
}
else if(name.equals("")){
JOptionPane.showMessageDialog(this,"姓名不能为空","错误提示",JOptionPane.ERROR_MESSAGE);
tf2.requestFocus();
return;
}
else if(gender.equals("")){
JOptionPane.showMessageDialog(this,"性别不能为空","错误提示",JOptionPane.INFORMATION_MESSAGE);
tf3.requestFocus();
return;
}
else if(sage.equals("")){
JOptionPane.showMessageDialog(this,"年龄不能为空","错误提示",JOptionPane.QUESTION_MESSAGE);
tf4.requestFocus();
return;
}
else if(classname.equals("")){
JOptionPane.showMessageDialog(this,"班级不能为空","错误提示",JOptionPane.QUESTION_MESSAGE);
tf5.requestFocus();
return;
}
else if(sscore.equals("")){
JOptionPane.showMessageDialog(this,"Java成绩不能为空","错误提示",JOptionPane.QUESTION_MESSAGE);
tf6.requestFocus();
return;
}
else setVisible(false);
EditTF=true;
}
else if(ent.getSource()==button2){
tf1.setText("");
tf2.setText("");
tf3.setText("");
tf4.setText("");
tf5.setText("");
tf6.setText("");
tf1.requestFocus();
repaint();
}
}

public String getSql(){
String sqlState="Update student set 姓名='"+name+"',性别='"+gender+"',年龄="+age+",班级='"+classname+"',Java成绩="+score+" Where 学号='"+number+"'";
//String sqlState="Update student set 姓名='abc',性别='男',年龄=22,班级='0541',Java成绩=72 Where 学号='01'";
if(!EditTF)sqlState="";
return sqlState;
}
}//查询窗口
class CSou extends JDialog implements ActionListener{
String number="",name="",gender="",classname="";
int age=0,score=0;
JLabel label1,label2,label3,label4,label5,label6;
JTextField tf1,tf2,tf3,tf4,tf5,tf6;
JButton button1,button2;
Boolean InsertYN=false;

CSou(Frame parent){
super(parent,true);
setTitle("查询学生记录");
this.setSize(300,400);
setLocationRelativeTo(parent);
this.addWindowListener(new WindowAdapter(){
      public void windowActivated(WindowEvent e){
      //tf1.requestFocus();//设置初始化焦点位置
      }
      public void windowOpened(WindowEvent e){
      tf1.requestFocus();//设置初始化焦点位置
      }
      });

label1=new JLabel("学号:");
label2=new JLabel("姓名:");
label3=new JLabel("性别:");
label4=new JLabel("年龄:");
label5=new JLabel("班级:");
label6=new JLabel("Java成绩:");
tf1=new JTextField();
tf2=new JTextField();
tf3=new JTextField();
tf4=new JTextField();
    tf5=new JTextField();
tf6=new JTextField();
button1=new JButton("提交");
button2=new JButton("重置");
button1.addActionListener(this);
button2.addActionListener(this);

Container ct=getContentPane();
ct.setLayout(null);//使用自定义布局

label1.setBounds(20,20,80,40);
label2.setBounds(20,70,80,40);
label3.setBounds(20,120,80,40);
label4.setBounds(20,170,80,40);
label5.setBounds(20,220,80,40);
label6.setBounds(20,270,80,40);

tf1.setBounds(120,20,160,40);
tf2.setBounds(120,70,160,40);
tf3.setBounds(120,120,160,40);
tf4.setBounds(120,170,160,40);
tf5.setBounds(120,220,160,40);
tf6.setBounds(120,270,160,40);
button1.setBounds(60,320,80,30);
button2.setBounds(160,320,80,30);

ct.add(label1);//加入标签
ct.add(tf1);//加入文本框
ct.add(label2);
ct.add(tf2);
ct.add(label3);
ct.add(tf3);
ct.add(label4);
ct.add(tf4);
ct.add(label5);
ct.add(tf5);
ct.add(label6);
ct.add(tf6);
ct.add(button1);//加入按钮
ct.add(button2);

setVisible(true);
}

public void actionPerformed(ActionEvent ent){
if(ent.getSource()==button1){
number=tf1.getText().trim();
name=tf2.getText().trim();
gender=tf3.getText().trim();
String sage=tf4.getText().trim();
if(!sage.equals(""))age=Integer.parseInt(sage);
classname=tf5.getText().trim();
String sscore=tf6.getText().trim();
if(!sscore.equals(""))score=Integer.parseInt(sscore);
if(number.equals("")){
JOptionPane.showMessageDialog(this,"学号不能为空","错误提示",JOptionPane.WARNING_MESSAGE);
tf1.requestFocus();
return;
}
else if(name.equals("")){
JOptionPane.showMessageDialog(this,"姓名不能为空","错误提示",JOptionPane.ERROR_MESSAGE);
tf2.requestFocus();
return;
}
else if(gender.equals("")){
JOptionPane.showMessageDialog(this,"性别不能为空","错误提示",JOptionPane.INFORMATION_MESSAGE);
tf3.requestFocus();
return;
}
else if(sage.equals("")){
JOptionPane.showMessageDialog(this,"年龄不能为空","错误提示",JOptionPane.QUESTION_MESSAGE);
tf4.requestFocus();
return;
}
else if(classname.equals("")){
JOptionPane.showMessageDialog(this,"班级不能为空","错误提示",JOptionPane.QUESTION_MESSAGE);
tf5.requestFocus();
return;
}
else if(sscore.equals("")){
JOptionPane.showMessageDialog(this,"Java成绩不能为空","错误提示",JOptionPane.QUESTION_MESSAGE);
tf6.requestFocus();
return;
}
else setVisible(false);
InsertYN=true;
}
else if(ent.getSource()==button2){
tf1.setText("");
tf2.setText("");
tf3.setText("");
tf4.setText("");
tf5.setText("");
tf6.setText("");
tf1.requestFocus();
repaint();
}
}
public String getSql(){
String sqlState="Insert into student values('"+number+"','"+name+"','"+gender+"',"+age+",'"+classname+"',"+score+")";
if(!InsertYN)sqlState="";
return sqlState;
}
}