纯Java增删改查
//自己写的一个完整的带增删改查提交重置功能的表单代码。
package com.l16.test5;
import java.awt.Color;
import java.awt.Container;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.Font;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.ButtonGroup;
import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JRadioButton;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swing.JTextField;
public class MyFrame extends JFrame implements ActionListener {
private JPanel panel = null;
private JPanel sePanel = null;
private JPanel hoPanel = null;
private JPanel buPanel = null;
private JPanel buPanel2 = null;
private JPanel buPanel3 = null;
//姓名
private JLabel tilabel = null;
private JLabel naLabel = null;
private JTextField naTextField = null;
//密码
private JLabel paLabel = null;
private JPasswordField passwordField = null;
private JLabel paLabel2 = null;
private JPasswordField passwordField2 = null;
//性别 控制单选用ButtonGroup
private JLabel seLabel = null;
private JRadioButton maRadioButton = null;
private JRadioButton feRadioButton = null;
private ButtonGroup buttonGroup = null;
//爱好
private JLabel hoLabel = null;
private JCheckBox eaCheckBox = null;
private JCheckBox spCheckBox = null;
private JCheckBox slCheckBox = null;
//籍贯 下拉功能用Combobox
private JLabel adLabel = null;
private JComboBox comboBox = null;
//自我介绍
private JLabel shLabel = null;
private JTextArea textArea = null;
private JScrollPane scrollPane = null;
//增删改查 提交 重置
private JButton adButton = null;
private JButton deButton = null;
private JButton alButton = null;
private JButton quButton = null;
private JButton suButton = null;
private JButton reButton = null;
private void init() {
this.setTitle("注册页面");
this.setDefaultCloseOperation(this.EXIT_ON_CLOSE);
Container content = this.getContentPane();
this.panel = new JPanel(new GridBagLayout());
content.add(panel);
GridBagConstraints gbc = new GridBagConstraints();
//标头
this.tilabel = new JLabel("金智用户注册");
this.tilabel.setFont(new Font("宋体", Font.BOLD, 26));
gbc.gridx = 1;
gbc.gridy = 0;
this.panel.add(this.tilabel, gbc);
//位置居右
gbc.anchor = GridBagConstraints.EAST;
//用户名
this.naLabel = new JLabel("用户名：");
this.naLabel.setFont(new Font("宋体", Font.BOLD, 20));
gbc.gridx = 0;
gbc.gridy = 1;
this.panel.add(this.naLabel, gbc);
this.naTextField = new JTextField(16);
gbc.gridx = 1;
gbc.gridy = 1;
this.panel.add(this.naTextField, gbc);
//密码1次
this.paLabel = new JLabel("密 码：");
this.paLabel.setFont(new Font("宋体", Font.BOLD, 20));
gbc.gridx = 0;
gbc.gridy = 2;
this.panel.add(this.paLabel, gbc);
this.passwordField = new JPasswordField(16);
gbc.gridx = 1;
gbc.gridy = 2;
this.panel.add(this.passwordField, gbc);
//密码2次
this.paLabel2 = new JLabel("密 码2：");
this.paLabel2.setFont(new Font("宋体", Font.BOLD, 20));
gbc.gridx = 0;
gbc.gridy = 3;
this.panel.add(this.paLabel2, gbc);
this.passwordField2 = new JPasswordField(16);
gbc.gridx = 1;
gbc.gridy = 3;
this.panel.add(this.passwordField2, gbc);
//性别
this.seLabel = new JLabel("性 别：");
this.seLabel.setFont(new Font("宋体", Font.BOLD, 20));
gbc.gridx = 0;
gbc.gridy = 4;
this.panel.add(this.seLabel, gbc);
this.maRadioButton = new JRadioButton("男", true);
this.maRadioButton.setFont(new Font("宋体", Font.BOLD, 20));
this.feRadioButton = new JRadioButton("女");
this.feRadioButton.setFont(new Font("宋体", Font.BOLD, 20));
this.sePanel = new JPanel(new FlowLayout(FlowLayout.CENTER, 28, 0));
this.sePanel.add(maRadioButton);
this.sePanel.add(feRadioButton);
this.buttonGroup = new ButtonGroup();
this.buttonGroup.add(maRadioButton);
this.buttonGroup.add(feRadioButton);
gbc.gridx = 1;
gbc.gridy = 4;
this.panel.add(this.sePanel, gbc);
//爱好
this.hoLabel = new JLabel("爱 好：");
this.hoLabel.setFont(new Font("宋体", Font.BOLD, 20));
gbc.gridx = 0;
gbc.gridy = 5;
this.panel.add(this.hoLabel, gbc);
this.hoPanel = new JPanel(new FlowLayout(FlowLayout.CENTER, 0, 0));
this.eaCheckBox = new JCheckBox("吃饭");
this.eaCheckBox.setFont(new Font("宋体", Font.BOLD, 16));
this.spCheckBox = new JCheckBox("运动");
this.spCheckBox.setFont(new Font("宋体", Font.BOLD, 16));
this.slCheckBox = new JCheckBox("睡觉");
this.slCheckBox.setFont(new Font("宋体", Font.BOLD, 16));
this.hoPanel.add(eaCheckBox);
this.hoPanel.add(spCheckBox);
this.hoPanel.add(slCheckBox);
gbc.gridx = 1;
gbc.gridy = 5;
this.panel.add(this.hoPanel, gbc);
//籍贯
this.adLabel = new JLabel("籍 贯：");
this.adLabel.setFont(new Font("宋体", Font.BOLD, 20));
gbc.gridx = 0;
gbc.gridy = 6;
this.panel.add(this.adLabel, gbc);
String[] add = {"西安", "北京", "上海", "广州"};
this.comboBox = new JComboBox(add);
this.comboBox.setFont(new Font("宋体", Font.BOLD, 20));
this.comboBox.setPreferredSize(new Dimension(176, 22));
gbc.gridx = 1;
gbc.gridy = 6;
this.panel.add(this.comboBox, gbc);
//自我介绍
this.shLabel = new JLabel("介 绍：");
this.shLabel.setFont(new Font("宋体", Font.BOLD, 20));
gbc.gridx = 0;
gbc.gridy = 7;
this.panel.add(this.shLabel, gbc);
this.textArea = new JTextArea("请在这里写你的自我介绍", 10, 22);
this.textArea.setFont(new Font("宋体", Font.BOLD, 14));
this.scrollPane = new JScrollPane(textArea);
gbc.gridx = 1;
gbc.gridy = 7;
this.panel.add(this.scrollPane, gbc);
//增删改查
this.buPanel = new JPanel(new FlowLayout(FlowLayout.RIGHT, 0, 0));
this.adButton = new JButton("增");
this.adButton.addActionListener(this);
this.buPanel.add(this.adButton);
gbc.gridx = 0;
gbc.gridy = 8;
this.panel.add(this.buPanel, gbc);
this.buPanel2 = new JPanel(new FlowLayout(FlowLayout.LEFT, 10, 0));
this.deButton = new JButton("删");
this.deButton.addActionListener(this);
this.alButton = new JButton("改");
this.alButton.addActionListener(this);
this.quButton = new JButton("查");
this.quButton.addActionListener(this);
this.buPanel2.add(this.deButton);
this.buPanel2.add(this.alButton);
this.buPanel2.add(this.quButton);
gbc.gridx = 1;
gbc.gridy = 8;
this.panel.add(this.buPanel2, gbc);
//提交和重置
this.buPanel3 = new JPanel(new FlowLayout(FlowLayout.CENTER, 16 , 0));
this.suButton = new JButton("提交");
this.suButton.addActionListener(this);
this.reButton = new JButton("重置");
this.reButton.addActionListener(this);
this.buPanel3.add(suButton);
this.buPanel3.add(reButton);
gbc.gridx = 1;
gbc.gridy = 9;
this.panel.add(this.buPanel3, gbc);
}
public MyFrame() {
this.init();
}
public static void main(String[] args) {
MyFrame frame = new MyFrame();
frame.setBounds(100, 20, 400, 600);
frame.setVisible(true);
}
@Override
public void actionPerformed(ActionEvent e) {
//声明数据库的三个对象，
Connection conn = null;//连接对象
Statement sta = null;//执行对象
ResultSet rs = null;//结果集对象
//增加一条记录开始***********************************************
//首先必须查数据库看有没有主键相同的，有的话提醒用户，不能插入同名的两条记录。
if(e.getSource() == this.adButton) {
//获取姓名
String username = this.naTextField.getText();
//校验姓名
if(username != null && username.length() <= 0) {
JOptionPane.showMessageDialog(this, "用户名不能为空！", "提示框", JOptionPane.WARNING_MESSAGE);
return;
}
//获取一次密码
String password1 = String.valueOf(this.passwordField.getPassword());
//获取二次密码
String password2 = String.valueOf(this.passwordField2.getPassword());
//校验密码
if(password1 != null && password1.length() <= 0 ) {
JOptionPane.showMessageDialog(this, "密码不能为空");
return;
}
if(password2 != null && password2.length() <= 0) {
JOptionPane.showMessageDialog(this, "密码不能为空");
return;
}
if(!(password1.equals(password2))) {
JOptionPane.showMessageDialog(this, "两次密码不一致，请重新输入二次密码");
return;
}
//获取性别
String sex = null;
if(this.maRadioButton.isSelected()) {
sex = "男";
} else {
sex = "女";
}
//获取爱好
String eat = null;
if(this.eaCheckBox.isSelected()) {
eat = "吃饭";
}
String sport = null;
if(this.spCheckBox.isSelected()) {
sport = "运动";
}
String sleep = null;
if(this.slCheckBox.isSelected()) {
sleep = "睡觉";
}
//获取户籍地
String address = this.comboBox.getSelectedItem().toString();
//获取自我介绍
String showMe = this.textArea.getText();
//拼接增加记录的Sql
String addSql = "insert into userTable values('"+username+"', '"+password1+"', '"+sex+"',"
+ " '"+eat+"', '"+sport+"', '"+sleep+"',"
+ " '"+address+"', '"+showMe+"')";
String queSql = "select * from userTable where nameuser = '"+username+"'";
//连接数据库
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=student", "sa", "sa");
sta = conn.createStatement();
rs = sta.executeQuery(queSql);
if(rs.next() == true) {
JOptionPane.showMessageDialog(this, "数据库中已存在此人，不能重复插入");
return;
}
int a = sta.executeUpdate(addSql);
if(a > 0) {
JOptionPane.showMessageDialog(this, "恭喜您，插入记录成功！");
}
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} finally {
try {
if(rs != null) {
rs.close();
rs = null;
}
if(sta != null) {
sta.close();
sta = null;
}
if(conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
//清空表单内的数据
this.naTextField.setText("");
this.passwordField.setText("");
this.passwordField2.setText("");
//默认选择男生
this.maRadioButton.setSelected(true);
this.eaCheckBox.setSelected(false);
this.spCheckBox.setSelected(false);
this.slCheckBox.setSelected(false);
this.comboBox.setSelectedItem("西安");
this.textArea.setText("请在这里写你的自我介绍");
//删除一条记录开始**********************************************
} else if(e.getSource() == this.deButton) {
//根据姓名来删除记录，没有就提示数据库没有
String username = JOptionPane.showInputDialog("请输入您要删除的名字");
//查询数据库
String queSql = "select * from userTable where nameuser = '"+username+"'";
String delSql = "delete from userTable where nameuser = '"+username+"'";
//连接数据库
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=student", "sa", "sa");
sta = conn.createStatement();
rs = sta.executeQuery(queSql);
//校验看数据库是否有此人
if(rs.next() == false) {
JOptionPane.showMessageDialog(this, "查无此人，请您核对后再输入");
} else {
int d = sta.executeUpdate(delSql);
if(d > 0) {
JOptionPane.showMessageDialog(this, "删除记录成功");
}
}
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} finally {
try {
if(rs != null) {
rs.close();
rs = null;
}
if(sta != null) {
sta.close();
sta = null;
}
if(conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
//修改一条记录开始***************************************************
} else if(e.getSource() == this.alButton) {
//根据姓名来删除记录，没有就提示数据库没有
String username = JOptionPane.showInputDialog("请输入您要修改的名字");
//查询数据库
String queSql = "select * from userTable where nameuser = '"+username+"'";
//连接数据库
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=student", "sa", "sa");
sta = conn.createStatement();
//可以两次的执行同一个SQL语句
rs = sta.executeQuery(queSql);
//校验，如果数据库里没有此人，则弹框说明
if(rs.next() == false) {
JOptionPane.showMessageDialog(this, "查无此人，请核对后再次输入");
}
//从数据库取出数据放在表单上
rs = sta.executeQuery(queSql);
while(rs.next()) {
this.naTextField.setText(rs.getString("nameuser"));
this.passwordField.setText(rs.getString("userPassword"));
this.passwordField2.setText(rs.getString("userPassword"));
//性别
if(rs.getString("userSex").equals("男")) {
this.maRadioButton.setSelected(true);
} else {
this.feRadioButton.setSelected(true);
}
//爱好
if(rs.getString("userEat").equals("吃饭")) {
this.eaCheckBox.setSelected(true);
}
if(rs.getString("userSport").equals("运动")) {
this.spCheckBox.setSelected(true);
}
if(rs.getString("userSleep").equals("睡觉")) {
this.slCheckBox.setSelected(true);
}
//籍贯
if(rs.getString("userAdress").equals("西安")) {
this.comboBox.setSelectedItem("西安");
} else if(rs.getString("userAdress").equals("北京")) {
this.comboBox.setSelectedItem("北京");
} else if(rs.getString("userAdress").equals("上海")) {
this.comboBox.setSelectedItem("上海");
} else if(rs.getString("userAdress").equals("广州")) {
this.comboBox.setSelectedItem("广州");
}
//自我介绍
this.textArea.setText(rs.getString("userShow"));
JOptionPane.showMessageDialog(this, "每次修改完记录请提交表单");
}
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} finally {
try {
if(rs != null) {
rs.close();
rs = null;
}
if(sta != null) {
sta.close();
sta = null;
}
if(conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
//查询一条记录开始***************************************************
} else if(e.getSource() == this.quButton) {
//根据姓名来删除记录，
String username = JOptionPane.showInputDialog("请输入您要查询的名字");
//查询数据库
String queSql = "select * from userTable where nameuser = '"+username+"'";
//连接数据库
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=student", "sa", "sa");
sta = conn.createStatement();
rs = sta.executeQuery(queSql);
if(rs.next() == false) {
JOptionPane.showMessageDialog(this, "查无此人，请核对后再次输入");
}
rs = sta.executeQuery(queSql);
//从数据库中查出数据放在页面上
while(rs.next()) {
this.naTextField.setText(rs.getString("nameuser"));
this.passwordField.setText(rs.getString("userPassword"));
this.passwordField2.setText(rs.getString("userPassword"));
//性别
if(rs.getString("userSex").equals("男")) {
this.maRadioButton.setSelected(true);
} else {
this.feRadioButton.setSelected(true);
}
//爱好
if(rs.getString("userEat").equals("吃饭")) {
this.eaCheckBox.setSelected(true);
}
if(rs.getString("userSport").equals("运动")) {
this.spCheckBox.setSelected(true);
}
if(rs.getString("userSleep").equals("睡觉")) {
this.slCheckBox.setSelected(true);
}
//籍贯
if(rs.getString("userAdress").equals("西安")) {
this.comboBox.setSelectedItem("西安");
} else if(rs.getString("userAdress").equals("北京")) {
this.comboBox.setSelectedItem("北京");
} else if(rs.getString("userAdress").equals("上海")) {
this.comboBox.setSelectedItem("上海");
} else if(rs.getString("userAdress").equals("广州")) {
this.comboBox.setSelectedItem("广州");
}
//自我介绍
this.textArea.setText(rs.getString("userShow"));
JOptionPane.showMessageDialog(this, "每次查询完记录请重置表单");
}
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} finally {
try {
if(rs != null) {
rs.close();
rs = null;
}
if(sta != null) {
sta.close();
sta = null;
}
if(conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
//提交表单记录*******************************************************
//思想先查数据库如果没有主键重复，直接新增一条，如果有先把主键相同的删除，然后把
//修改后的一条记录插入到数据库里
} else if(e.getSource() == this.suButton) {
//获取姓名
String username = this.naTextField.getText();
//校验姓名
if(username != null && username.length() <= 0) {
JOptionPane.showMessageDialog(this, "用户名不能为空！", "提示框", JOptionPane.WARNING_MESSAGE);
return;
}
//获取一次密码
String password1 = String.valueOf(this.passwordField.getPassword());
//获取二次密码
String password2 = String.valueOf(this.passwordField2.getPassword());
//校验密码
if(password1 != null && password1.length() <= 0 ) {
JOptionPane.showMessageDialog(this, "密码不能为空");
return;
}
if(password2 != null && password2.length() <= 0) {
JOptionPane.showMessageDialog(this, "密码不能为空");
return;
}
if(!(password1.equals(password2))) {
JOptionPane.showMessageDialog(this, "两次密码不一致，请重新输入二次密码");
return;
}
//获取性别
String sex = null;
if(this.maRadioButton.isSelected()) {
sex = "男";
} else {
sex = "女";
}
//获取爱好
String eat = null;
if(this.eaCheckBox.isSelected()) {
eat = "吃饭";
}
String sport = null;
if(this.spCheckBox.isSelected()) {
sport = "运动";
}
String sleep = null;
if(this.slCheckBox.isSelected()) {
sleep = "睡觉";
}
//获取户籍地
String address = this.comboBox.getSelectedItem().toString();
//获取自我介绍
String showMe = this.textArea.getText();
//拼接增加记录的Sql
String addSql = "insert into userTable values('"+username+"', '"+password1+"', '"+sex+"',"
+ " '"+eat+"', '"+sport+"', '"+sleep+"',"
+ " '"+address+"', '"+showMe+"')";
//检验数据库中是否已存在的主键相同的记录，如果有则不能插入
String queSql = "select * from userTable where nameuser = '"+username+"'";
//连接数据库
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=student", "sa", "sa");
sta = conn.createStatement();
//校验
rs = sta.executeQuery(queSql);
if(rs.next() == true) {
JOptionPane.showMessageDialog(this, "数据库中已存在此人，不能重复插入");
return;
}
int a = sta.executeUpdate(addSql);
if(a > 0) {
JOptionPane.showMessageDialog(this, "恭喜您，提交成功！");
}
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} finally {
try {
if(rs != null) {
rs.close();
rs = null;
}
if(sta != null) {
sta.close();
sta = null;
}
if(conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
//清空表单内的数据
this.naTextField.setText("");
this.passwordField.setText("");
this.passwordField2.setText("");
//默认选择男生
this.maRadioButton.setSelected(true);
this.eaCheckBox.setSelected(false);
this.spCheckBox.setSelected(false);
this.slCheckBox.setSelected(false);
this.comboBox.setSelectedItem("西安");
this.textArea.setText("请在这里写你的自我介绍");
//重置表单内容*******************************************************
} else if(e.getSource() == this.reButton) {
//清空表单内的数据
this.naTextField.setText("");
this.passwordField.setText("");
this.passwordField2.setText("");
//默认选择男生
this.maRadioButton.setSelected(true);
this.eaCheckBox.setSelected(false);
this.spCheckBox.setSelected(false);
this.slCheckBox.setSelected(false);
this.comboBox.setSelectedItem("西安");
this.textArea.setText("请在这里写你的自我介绍");
}
}
}
