java代码实现：增、删、改、查

java员工信息系统的增删改查

java代码实现增删改查其实并不难，有很多方法
我这里就是举个例子，方法千千万，也不分好坏
写出来能运行的都是好方法!!!

首先：

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

然后，代码主体内容如下：

public class Genggai implements ActionListener{
	Connection con;
	Statement stmt;
	String sql;
	ResultSet rs;
	StringBuffer sb = new StringBuffer();

	JTextField jtf2 = new JTextField("Tom",10);

	JTextField jtf3 = new JTextField(10);

	JTextField jtf4 = new JTextField(10);

	JTextField jtf7 = new JTextField(10);

	JTextField jtf5 = new JTextField(10);

	JTextField jtf6 = new JTextField(10);

	JTextField jtf8 = new JTextField(10);

	JTextField jtf9 = new JTextField(10);

	JTextArea jta10 = new JTextArea(50, 40);

	public void actionPerformed(ActionEvent e) {
	String str = e.getActionCommand();
	if ("查询".equals(str)) {
	searchEmp();
	} else if ("增加".equals(str)) {
	addEmp();
	} else if ("修改".equals(str)) {
	alterEmp();
	} else if ("撤除".equals(str)) {
	deleteEmp();
	}
	}

	Genggai() {
	createGUI();
	connectToDataBase();
	alterEmp();
	}

	public Connection connectToDataBase() {
	System.out.println(con);
	return con;
	}
	
	
	public void searchEmp() {
	jta10.setText("");
	try {
	stmt = con.createStatement();
	sql = "select * from Mstar where chineseName="
	+ jtf2.getText().toLowerCase().trim() + "or id="
	+ jtf3.getText().toLowerCase().trim() + "or engName="
	+ jtf4.getText().toLowerCase().trim() + "or UNIT="
	+ jtf5.getText().toLowerCase().trim() + "or TEAM="
	+ jtf6.getText().toLowerCase().trim() + "or Phone="
	+ jtf7.getText().toLowerCase().trim() + "or region="
	+ jtf8.getText().toLowerCase().trim() + "or busStation="
	+ jtf9.getText().toLowerCase().trim();
	stmt.executeQuery(sql);
	rs = stmt.getResultSet();
	ResultSetMetaData meta = rs.getMetaData();
	int cols = meta.getColumnCount();
	while (rs.next()) {
	for (int i = 1; i <= cols; i++) {
	sb.append(" " + meta.getColumnName(i) + " =");
	sb.append(rs.getString(i));
	}
	sb.append("\n");
	jta10.setText(sb.toString());
	}
	} catch (SQLException e11) {
	e11.printStackTrace();
	}
	}

	public void addEmp() {
	try {
	stmt = con.createStatement();
	sql = "update Mstar values(" + jtf2.getText() 
	+ jtf4.getText()  + ")";
	int i = stmt.getUpdateCount();
	if ((jtf2.getText() != null) && (jtf4.getText() != null)) {
	stmt.executeUpdate(sql);
	jta10.setText("添加记录成功" + i + "条");
	} else {
	jta10.setText("带*号项为添加记录时不能为空");
	}
	} catch (SQLException e1) {
	e1.printStackTrace();
	}
	}

	public void deleteEmp() {
	searchEmp();
	try {
	stmt = con.createStatement();
	sql = "delete from Mstar where chineseName="
	+ jtf2.getText().toLowerCase().trim() + "or id="
	+ jtf3.getText().toLowerCase().trim() + "or engName="
	+ jtf4.getText().toLowerCase().trim() + "or UNIT="
	+ jtf5.getText().toLowerCase().trim() + "or TEAM="
	+ jtf6.getText().toLowerCase().trim() + "or Phone="
	+ jtf7.getText().toLowerCase().trim() + "or region="
	+ jtf8.getText().toLowerCase().trim() + "or busStation="
	+ jtf9.getText().toLowerCase().trim();
	stmt.executeUpdate(sql);
	int i = stmt.getUpdateCount();
	jta10.setText("撤除操作成功" + i + "条");
	} catch (SQLException e) {
	e.printStackTrace();
	}

	}

	public void alterEmp() {
	searchEmp();
	sql = "update Mstar set chineseName="
	+ jtf2.getText().toLowerCase().trim() + "and id="
	+ jtf3.getText().toLowerCase().trim() + "and engName="
	+ jtf4.getText().toLowerCase().trim() + "and UNIT="
	+ jtf5.getText().toLowerCase().trim() + "and TEAM="
	+ jtf6.getText().toLowerCase().trim() + "and Phone="
	+ jtf7.getText().toLowerCase().trim() + "and region="
	+ jtf8.getText().toLowerCase().trim() + "and busStation="
	+ jtf9.getText().toLowerCase().trim();

	int i = 0;
	try {
	stmt.executeUpdate(sql);
	i = stmt.getUpdateCount();
	} catch (SQLException e) {
	e.printStackTrace();
	}
	jta10.setText("修改操作成功" + i + "条");
	}

	public void createGUI() {
	JFrame jf = new JFrame("员工信息管理系统");
	jf.setLayout(new GridLayout(2, 1));
	// jf.setLayout(new GridLayout(10,2));
	JPanel jp00 = new JPanel(new GridLayout(5, 4));

	JPanel jp1 = new JPanel();
	JButton jb11 = new JButton("查询");
	jb11.addActionListener(this);
	JButton jb12 = new JButton("增加");
	jb12.addActionListener(this);
	jp1.add(jb11);
	jp1.add(jb12);
	jp00.add(jp1);
	JPanel jp11 = new JPanel();
	JButton jb111 = new JButton("修改");
	jb111.addActionListener(this);
	JButton jb112 = new JButton("撤除");
	jb112.addActionListener(this);
	jp11.add(jb111);
	jp11.add(jb112);
	jp00.add(jp11);
	JPanel jp2 = new JPanel();
	JLabel jl2 = new JLabel("姓名 * ");
	jp2.add(jl2);
	jp2.add(jtf2);
	jp00.add(jp2);
	JPanel jp3 = new JPanel();
	JLabel jl3 = new JLabel("密码");
	jp3.add(jl3);
	jp3.add(jtf3);
	jp00.add(jp3);
	JPanel jp4 = new JPanel();
	JLabel jl4 = new JLabel("密码 *");
	jp4.add(jl4);
	jp4.add(jtf4);
	jp00.add(jp4);
	JPanel jp5 = new JPanel();
	JLabel jl5 = new JLabel("UNIT ");
	jp5.add(jl5);
	jp5.add(jtf5);
	jp00.add(jp5);
	JPanel jp6 = new JPanel();
	JLabel jl6 = new JLabel("确认密码* ");
	jp6.add(jl6);
	jp6.add(jtf6);
	jp00.add(jp6);
	JPanel jp7 = new JPanel();
	JLabel jl7 = new JLabel("手机号 * ");
	jp7.add(jl7);
	jp7.add(jtf7);
	jp00.add(jp7);
	JPanel jp8 = new JPanel();
	JLabel jl8 = new JLabel("区域 ");
	jp8.add(jl8);
	jp8.add(jtf8);
	jp00.add(jp8);
	JPanel jp9 = new JPanel();
	JLabel jl9 = new JLabel("公交站 ");
	jp9.add(jl9);
	jp9.add(jtf9);
	jp00.add(jp9);
	jf.add(jp00);
	JPanel jp01 = new JPanel();
	jta10.setText("                                                        这是修改员工信息  ！");
	jp01.add(jta10);
	jf.add(jp01);
	jf.setSize(700, 500);
	jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	jf.setVisible(true);

	}

	public static void main(String[] args) {
	new Genggai();
	}
	}