java增删改查代码_增删改查java代码库云代码

[java]代码库package www.baidu.com;

import java.awt.Frame;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import javax.swing.JButton;

import javax.swing.JDialog;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JTextField;

public class revise extends JDialog implements ActionListener {

private JTextField setName,setNumber,setSex,setAge,setPost,setWage,setJop;

private JLabel name,number,age,sex,wage,post,jop;

private JButton Addyes,Addno;

private Connection con&＃61;null;

private Statement sql&＃61;null;

private ResultSet rs&＃61;null;

private String SQLname,SQLsex,SQLpost,SQLjop;

private int SQLnumber,SQLage,SQLwage;

//chaxun xx;

revise(Frame fck,String ckm,Boolean msck,chaxun xx,int j){

super(fck, ckm,msck);

if(j&＃61;&＃61;-1){

JOptionPane.showMessageDialog(null,"请选中要修改的行");

return;

}

//xx&＃61;new chaxun();

setNumber&＃61;new JTextField(5);

setNumber.setText((String)xx.getValueAt(j,0).toString());

setNumber.setEditable(false);//设置为不能修改&＃xff0c;防止出错

setName&＃61;new JTextField(5);

setName.setText((String)xx.getValueAt(j,1));

setAge&＃61;new JTextField(5);

setAge.setText((String)xx.getValueAt(j,3).toString());

setSex&＃61;new JTextField(5);

setSex.setText((String)xx.getValueAt(j,2));

setPost&＃61;new JTextField(5);

setPost.setText((String)xx.getValueAt(j,4));

setWage&＃61;new JTextField(5);

setWage.setText((String)xx.getValueAt(j,5).toString());

setJop&＃61;new JTextField(5);

setJop.setText((String)xx.getValueAt(j,6));

name&＃61;new JLabel("姓名");

number&＃61;new JLabel("学号");

age&＃61;new JLabel("年龄");

sex&＃61;new JLabel("性别");

post&＃61;new JLabel("职位");

wage&＃61;new JLabel("工资");

jop&＃61;new JLabel("地点");

Addyes&＃61;new JButton("确定");

Addno&＃61;new JButton("取消");

this.add(number);this.add(setNumber);

this.add(name);this.add(setName);

this.add(sex);this.add(setSex);

this.add(age);this.add(setAge);

this.add(post);this.add(setPost);

this.add(wage);this.add(setWage);

this.add(jop);this.add(setJop);

this.add(Addyes); this.add(Addno);

this.Addyes.addActionListener(this);

this.Addno.addActionListener(this);

this.setSize(350,400);

this.setLocation(100, 260);

this.setLayout(new GridLayout(8,2));

this.setVisible(true);

this.setResizable(false);

}

&＃64;Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

if(e.getSource()&＃61;&＃61;Addyes){

try{

// 获得连接

Class.forName("com.mysql.jdbc.Driver");

con &＃61; DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/nature","root","root");

// 建立查询条件

String recode &＃61; " update nature set name&＃61;?,sex&＃61;?,age&＃61;?,post&＃61;?,wage&＃61;?,jop&＃61;? where number&＃61;?";

PreparedStatement input&＃61;con.prepareStatement(recode);

SQLnumber&＃61;Integer.parseInt(setNumber.getText());

SQLage&＃61; Integer.parseInt(setAge.getText());

SQLwage&＃61; Integer.parseInt(setWage.getText());

// input.setInt(1, SQLnumber);

input.setString(1, setName.getText());

input.setString(2,setSex.getText());

input.setInt(3,SQLage);

input.setString(4,setPost.getText());

input.setInt(5,SQLwage);

input.setString(6,setJop.getText());

input.setInt(7, SQLnumber); //修改的条件

input.executeUpdate();

JOptionPane.showMessageDialog(null, "修改成功");

this.dispose();

}

catch(NumberFormatException nu){

JOptionPane.showMessageDialog(null,"你还没有输入哦","错误",JOptionPane.ERROR_MESSAGE);

}

catch(ClassNotFoundException cnfe){

JOptionPane.showMessageDialog(null,"数据源错误","错误",JOptionPane.ERROR_MESSAGE);

}

catch(SQLException sqle){

sqle.printStackTrace();

JOptionPane.showMessageDialog(null,"数据操作错误","错误",JOptionPane.ERROR_MESSAGE);

}

finally

{

try {

if(rs!&＃61;null)

{

rs.close();

}

if(sql!&＃61;null)

{

sql.close();

}

if(con!&＃61;null)

{

con.close();

}

} catch (Exception e1){}

}

}

if(e.getSource()&＃61;&＃61;Addno){

this.dispose();

}

}

}

[源代码打包下载]

增删改查.zip(50积分)[5 次下载]