java与数据库的操作（增删改查）

这就是鱼头

已于 2024-01-25 11:12:18 修改

阅读量1.7k

点赞数 30

文章标签： java 数据库开发语言

于 2024-01-21 16:10:28 首次发布

本文链接：https://blog.csdn.net/NLxxxxX/article/details/135730416

版权

Java编写的程序不依赖于具体的数据库，通过JDBC访问数据库。JDBC（Java Data Base Connectivity）是Java程序访问数据库的标准接口，由一组类和接口组成。使用JDBC访问数据库的步骤：

(1)加载驱动程序

(2)建立连接对象

(3)创建语句对象

(4)执行SQL语句，获得结果

(5)关闭建立的对象，释放资源

1.测试数据库连接

import java.sql.*;

public class Dao { // 该类中包含了数据库连接相关的属性和方法。
   String dbDriver = "com.mysql.jdbc.Driver"; // dbDriver 存储了数据库驱动程序的类名。
   String uri = "jdbc:mysql://localhost:3306/z?characterEncoding=utf-8"; // 3306:mysql端口号。 z:数据库名字。
   String user = "root"; // user 字段存储了数据库的用户名。
   String password = ""; // password 字段存储了数据库的密码。
   Connection c = null;

   public Connection getConnection() throws ClassNotFoundException, SQLException {
       Class.forName(dbDriver); // 1.加载驱动程序
       c = DriverManager.getConnection(uri, user, password); // 2.建立连接对象
       return c;
   }
   // 连接提醒
   public static void main(String args[]) {
       try {
           Class.forName("com.mysql.jdbc.Driver"); // 加载驱动程序
           System.out.println("成功加载Mysql驱动程序!");
       } catch (Exception e) {
           System.out.print("加载Mysql驱动程序时出错!");
           e.printStackTrace();
       }
       try {
           Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/z?characterEncoding=utf-8",
                   "root", "");
           System.out.println("成功连接Mysql服务器!");
           Statement stmt = connect.createStatement();
           ResultSet rs = stmt.executeQuery("select * from guanggao");
           while (rs.next()) {
               System.out.println(rs.getString("序号"));
           }
           connect.close();
       } catch (Exception e) {
           System.out.print("获取数据错误!");
           e.printStackTrace();
       }
   }

}

2.以下以广告表为例，创建广告表类：

public class guanggao {
String id;
String name;
String content;
String check;
String time;
   String point;
public guanggao(String s1, String name, String content, String check, String s2, String s3) {
   super();
   this.id = s1;
   this.name = name;
   this.content = content;
   this.check = check;
   this.time = s2;
   this.point = s3;
}

public guanggao(String id) {
   super();
   this.id = id;

}

public guanggao(String name, String check) {
   super();
   this.name = name;
   this.check = check;
}

public String getId() {
   return id;
}
public void setId(String id) {
   this.id = id;
}
public String getName() {
   return name;
}
public void setName(String name) {
   this.name = name;
}
public String getContent() {
   return content;
}
public void setContent(String content) {
   this.content = content;
}
public String getCheck() {
   return check;
}
public void setCheck(String check) {
   this.check = check;
}
public String getTime() {
   return time;
}
public void setTime(String time) {
   this.time = time;
}
public String getPoint() {
   return point;
}
public void setPoint(String point) {
   this.point = point;
}
@Override
public String toString() {
   return "guanggao [id=" + id + ", name=" + name + ", content=" + content + ", check=" + check + ", time=" + time
           + ", point=" + point + "]";
}
}

3.创建增删改方法

import java.sql.*;
import java.util.*;

import javax.swing.JOptionPane;

public class guanggao_Dao extends Dao {

   public ArrayList<guanggao> search() {
       ArrayList<guanggao> g = new ArrayList<guanggao>();
       Connection c = null;
       PreparedStatement pst;
       ResultSet rs = null;
       try {
           c = getConnection(); // 2.建立连接对象
           String sql = "select * from guanggao ";
           pst = c.prepareStatement(sql); // 3.创建语句对象
           rs = pst.executeQuery();
           while (rs.next()) {
               String id = rs.getString("序号");
               String name = rs.getString("广告名");
               String content = rs.getString("广告内容");
               String check = rs.getString("审核状态");
               String time = rs.getString("时间");
               String point = rs.getString("点击率");
               guanggao gua = new guanggao(id, name, content, check, time, point);
               g.add(gua); // 将对象添加到数组
           }
       } catch (ClassNotFoundException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       } catch (SQLException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }
       return g;
   }

public void Insert(guanggao gao) {

       Connection c = null;
       PreparedStatement pst;
//       ResultSet rs=null;

       try {
           c = getConnection(); // 2.建立连接对象
           String sql1 = "insert into guanggao values(?,?,?,?,?,?)";
           pst = c.prepareStatement(sql1); // 3.创建语句对象
           pst.setString(1, gao.getId()); // 指定第一个？的数值，
           pst.setString(2, gao.getName()); // 指定第二个？的数值
           pst.setString(3, gao.getContent()); // 指定第三个？的数值
           pst.setString(4, gao.getCheck()); // 指定第四个？的数值
           pst.setString(5, gao.getTime());
           pst.setString(6, gao.getPoint());
           int re = pst.executeUpdate();
           System.out.println(re);

           pst.close();
           c.close();
           loadData();
       } catch (ClassNotFoundException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       } catch (SQLException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }
   }

   public void Delete(guanggao gao) throws SQLException {
       Connection c = null;
       PreparedStatement pst;

       try {
           c = getConnection();
           String sql1 = "delete from guanggao where 序号= ?";
           pst = c.prepareStatement(sql1);
           pst.setString(1, gao.getId());

           int a = pst.executeUpdate();
           System.out.println(a);
           if (a == 1) {
               JOptionPane.showMessageDialog(null, "成功");
           }
           pst.close();
           c.close();

       } catch (ClassNotFoundException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       } catch (SQLException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       } // 2.建立连接对象

}

public void loadData() {

Connection c = null;
PreparedStatement pst;

       try {
           c = getConnection(); // 2.建立连接对象
           String sql = "UPDATE guanggao SET 点击率 = 点击率 + 1";
           pst = c.prepareStatement(sql); // 3.创建语句对象
           int rs = pst.executeUpdate();

           System.out.println(rs);
           if (rs == 1) {
               JOptionPane.showMessageDialog(null, "成功");
           }

}

   public void Updata(guanggao gao) {
       try {
           Connection c = null;
           PreparedStatement pst;
           c = getConnection(); // 2.建立连接对象
           String sql1 = "update guanggao set 审核状态=? where 广告名=?";
           pst = c.prepareStatement(sql1); // 3.创建语句对象
//

pst.setString(1, gao.getCheck()); // 指定第一个？的数值，
pst.setString(2, gao.getName()); // 指定第二个？的数值

           int a = pst.executeUpdate();
           System.out.println(a);
           if (a == 1) {
               JOptionPane.showMessageDialog(null, "成功");
           }
           pst.close();
           c.close();
           loadData();
       } catch (ClassNotFoundException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       } catch (SQLException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }
   }
   public void re(guanggao gao) {
       ArrayList<guanggao> g = new ArrayList<guanggao>();
       Connection c = null;
       PreparedStatement pst;
       ResultSet rs = null;
       try {
           c = getConnection(); // 2.建立连接对象
           String sql = "select * from guanggao ";
           pst = c.prepareStatement(sql); // 3.创建语句对象
           rs = pst.executeQuery();
           while (rs.next()) {
               String id = rs.getString("序号");
               String name = rs.getString("广告名");
               String content = rs.getString("广告内容");
               String check = rs.getString("审核状态");
               String time = rs.getString("时间");
               String point = rs.getString("点击率");
               guanggao gua = new guanggao(id, name, content, check, time, point);
               g.add(gua); // 将对象添加到数组
           }
       } catch (ClassNotFoundException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       } catch (SQLException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }

   }

}

4.创建一个简单的登陆按钮，在该类中创建主窗口并对其做出一些美化

import java.awt.BorderLayout;
import java.awt.Button;
import java.awt.Color;
import java.awt.Composite;
import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.Font;
import java.awt.Graphics;
import java.awt.GridLayout;
import java.awt.TextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.InputEvent;
import java.awt.event.KeyEvent;
import java.sql.SQLException;
//import java.sql.Connection;
//import java.sql.PreparedStatement;
//import java.sql.ResultSet;
//import java.sql.SQLException;
import java.util.ArrayList;

import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFileChooser;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
//import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.KeyStroke;
import javax.swing.SwingUtilities;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.JTableHeader;
import extra.zy_Dao.Mywindow5;
import extra.zy_Dao.guanggao_Dao;
import extra.zy_Dao.Mywindow4;
import extra.zy_Dao.Mywindow3;

public class MyWindow2 extends JFrame implements ActionListener {

private JButton bt;

   public MyWindow2() {
       init();
       setTitle("广告登录页面");
       setSize(350, 250);
       setVisible(true);
       setLocation(400, 320);
       setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
       }
   public void init() {
       bt = new JButton("登录");
       add(bt);
       bt.addActionListener(this);
       }
   @Override
   public void actionPerformed(ActionEvent e) {
       // TODO Auto-generated method stub
       MyWindow1 mywindow = new MyWindow1();}
   public static void main(String[] args) {
       SwingUtilities.invokeLater(new Runnable() {
           @Override
           public void run() {
               MyWindow2 mywindow1 = new MyWindow2();
   }
   });

}

class MyWindow1 extends JFrame implements ActionListener {

   private JScrollPane scpDemo;
   private JTableHeader jth;
   private JTable tabDemo;
   private JButton b, b2, b3, b4;
   private TextField text1, text2, text3;
   JMenuBar menubar;
   JMenuItem connectitem;
   JMenu databaseMenu;
   JMenu menu;
   JMenuItem eitem;

   public void createAndShowGUI() {
       // 创建窗口
       JFrame frame = new JFrame("FlowLayout Example");

// 设置窗口关闭操作
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

       // 创建父容器并设置为流式布局
       JPanel parentPanel = new JPanel();
       parentPanel.setLayout(new FlowLayout());
       parentPanel.add(b);
       parentPanel.add(b2);
       parentPanel.add(b3);
       parentPanel.add(b4);
       frame.add(parentPanel);

}

   public MyWindow1() {
       init();
       setTitle("广告信息");
       setSize(650, 550);
       setVisible(true);
       setLocation(400, 320);
       setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
   }

   public void init() {
       setLayout(new BorderLayout());
       setLayout(new FlowLayout());
       this.scpDemo = new JScrollPane();
       scpDemo.setSize(500, 600);
       text1 = new TextField();
       text2 = new TextField();
       text3 = new TextField();
       b = new JButton("刷新");
       b2 = new JButton("添加数据");
       b3 = new JButton("修改数据");
       b4 = new JButton("删除数据");
       b2.setBounds(165, 10, 125, 30);
       b3.setBounds(310, 10, 125, 30);
       b4.setSize(30, 50);
       this.b.setBounds(300, 400, 225, 300);
       menubar = new JMenuBar();
       menu = new JMenu("文件");
       eitem = new JMenuItem("退出",new ImageIcon("pic/10.jpg"));
       eitem.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_S,InputEvent.CTRL_MASK));
       eitem.addActionListener(new ActionListener() {
           public void actionPerformed(ActionEvent e) {
               System.exit(0);
           }
       });
       databaseMenu = new JMenu("数据库操作");
       connectitem = new JMenuItem("连接",new ImageIcon("pic/00.jpg"));
//       connectitem.setIcon(new ImageIcon("0.jpg"));
       connectitem.setAccelerator(KeyStroke.getKeyStroke("A"));
       connectitem.addActionListener(new ActionListener() {
           public void actionPerformed(ActionEvent e) {

guanggao_Dao ga1 = new guanggao_Dao();

ArrayList<guanggao> list = new ArrayList<guanggao>();

ArrayList<guanggao> g = ga1.search();
list.addAll(g);

           }
       });
       databaseMenu.add(connectitem);
       menu.add(menu);
       menu.add(eitem);
       menubar.add(databaseMenu);
       menubar.add(menu);
       setJMenuBar(menubar);
       add(b, BorderLayout.NORTH);
       add(b2, BorderLayout.NORTH);
       add(b3, BorderLayout.NORTH);
       add(b4, BorderLayout.NORTH);

       // 设置列数
       b.addActionListener(this);
       b2.addActionListener(this);
       b3.addActionListener(this);
       b4.addActionListener(this);

       ArrayList<guanggao> list = new ArrayList<guanggao>();
       guanggao_Dao ga = new guanggao_Dao();
       ArrayList<guanggao> g = ga.search();
       list.addAll(g);
       JTable table = new JTable();// 创建表格
       String[] title = { "序号", "广告名", "广告内容", "审核状态", "时间", "点击率" };// 表头信息
       // 创建表格模型
       DefaultTableModel tableModel = new DefaultTableModel(null, title);
       for (guanggao gao : list) {
           Object[] rowData = { gao.getId(), gao.getName(), gao.getContent(), gao.getCheck(), gao.getTime(),
                   gao.getPoint() };
           tableModel.addRow(rowData);// 把ArrayList中的数据放入表格模型
       }
       table.setModel(tableModel);
       // 表格间距
       // 美化

       JTableHeader header = table.getTableHeader();
       header.setBackground(Color.gray);
       header.setFont(new Font("宋体", Font.BOLD, 16));
//窗口上下栏间距
       table.setSize(630, 450);
       // 把表格添加到窗口中
       add(new JScrollPane(table), BorderLayout.CENTER);// 窗口的默认布局是边界布局

       ImageIcon icon=new ImageIcon("pic/15.jpg");//背景图。插入图片，可删除该行代码
   JLabel label = new JLabel(icon);//往一个标签中加入图片

   label.setBounds(0, 0, icon.getIconWidth(),icon.getIconHeight());//设置标签位置大小为图片大小
   this.getLayeredPane().add(label, Integer.valueOf(Integer.MIN_VALUE));//标签添加到第二层面板

   //获取顶层容器设为透明
   JPanel imPanel = (JPanel)getContentPane();
   imPanel.setOpaque(false);

   //建立透明文本显示区面板
   JPanel displayPanel=new JPanel();
   displayPanel.setOpaque(false);

}

@Override
public void actionPerformed(ActionEvent e) {

if (e.getSource() == b2) {
Mywindow3 m3 = new Mywindow3();

}

       else if (e.getSource() == b3) {
           Mywindow4 m4 = new Mywindow4();
       } else if (e.getSource() == b4) {
           Mywindow5 m5 = new Mywindow5();

} else if (e.getSource() == b) {

Mywindow6 m6 = new Mywindow6();

}

5.增加数据窗口

mport java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.Font;
import java.awt.GridLayout;
import java.awt.TextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.swing.*;

import extra.zy_Dao.guanggao_Dao;;

public class Mywindow3 extends JFrame implements ActionListener {
   JTextField text, text1, text2, text3, text4, text5;
   JLabel jl, jl1, jl2, jl3, jl4, jl5;
   JPanel jp, jp1;
   JButton b;

   public Mywindow3() {
       init();
       setTitle("增加数据页面");
       setSize(450, 350);
       setVisible(true);
       setLocation(400, 320);
       setFont(new Font("宋体", Font.PLAIN, 14));
   }

   public void init() {
       setLayout(new FlowLayout());
       jp = new JPanel();

       jl = new JLabel("序号:");
       jl.setFont(new Font("宋体", Font.PLAIN, 14));
       jl.setForeground(Color.CYAN);
       jp.add(jl);

       // 实例化JTextField标签对象化
       text = new JTextField();
       Dimension dim1 = new Dimension(300, 30);
       text.setPreferredSize(dim1);// 设置除顶级容器组件以外其他组件的大小
       jp.add(text);

       jl1 = new JLabel(" 广告名： ");
       jl1.setFont(new Font("宋体", Font.PLAIN, 14));
       jl1.setForeground(Color.CYAN);
       jp.add(jl1);

// 实例化
text1 = new JTextField();

       // 设置大小
       text1.setPreferredSize(dim1);
       // 添加到窗体
       jp.add(text1);

       jl2 = new JLabel("广告内容：");
       jl2.setFont(new Font("宋体", Font.PLAIN, 14));
       jl2.setForeground(Color.CYAN);
       jp.add(jl2);

text2 = new JTextField();

       // 设置大小
       text2.setPreferredSize(dim1);
       // 添加到窗体
       jp.add(text2);
       jl3 = new JLabel("审核状态：");
       jl3.setFont(new Font("宋体", Font.PLAIN, 14));
       jl3.setForeground(Color.CYAN);
       jp.add(jl3);

text3 = new JTextField();

//设置大小
       text3.setPreferredSize(dim1);
//添加到窗体
       jp.add(text3);
       jl4 = new JLabel(" 时间：");
       jl4.setFont(new Font("宋体", Font.PLAIN, 14));
       jl4.setForeground(Color.CYAN);
       jp.add(jl4);

text4 = new JTextField();

//设置大小
       text4.setPreferredSize(dim1);
//添加到窗体
       jp.add(text4);
       jl5 = new JLabel(" 点击率： ");
       jl5.setFont(new Font("宋体", Font.BOLD, 14));
       jl5.setForeground(Color.CYAN);
       jp.add(jl5);

text5 = new JTextField();

text5.setPreferredSize(dim1);
//添加到窗体
jp.add(text5);

       // 实例化JButton组件
       b = new JButton();
       // 设置按键的显示内容
       Dimension dim2 = new Dimension(100, 30);
       b.setText("确定");
       b.setFont(new Font("宋体", Font.PLAIN, 14));
       // 设置按键大小
       b.setSize(dim2);
       ImageIcon icon=new ImageIcon("pic/829.jpg");//背景图
   JLabel label = new JLabel(icon);//往一个标签中加入图片

   label.setBounds(0, 0, icon.getIconWidth(),icon.getIconHeight());//设置标签位置大小为图片大小
   this.getLayeredPane().add(label, Integer.valueOf(Integer.MIN_VALUE));//标签添加到第二层面板

   //获取顶层容器设为透明
   JPanel imPanel = (JPanel)getContentPane();
   imPanel.setOpaque(false);

   //建立透明文本显示区面板
   JPanel displayPanel=new JPanel();
   displayPanel.setOpaque(false);
       add(jp);
       add(jl);
       add(text);
       add(jl1);
       add(text1);
       add(jl2);
       add(text2);
       add(jl3);
       add(text3);
       add(jl4);
       add(text4);
       add(jl5);
       add(text5);
       add(b);
       b.addActionListener(this); // 注册事件

}

   public static void main(String[] args) {
       // TODO Auto-generated method stub
       MyWindow1 mywindow = new MyWindow1();

}

   @Override
   public void actionPerformed(ActionEvent e) {
       // TODO Auto-generated method stub

guanggao_Dao ga1 = new guanggao_Dao();

       guanggao gao = new guanggao(text.getText(), text1.getText(), text2.getText(), text3.getText(), text4.getText(),
               text5.getText());
       ArrayList<guanggao> list = new ArrayList<guanggao>();

       ga1.Insert(gao);
       ArrayList<guanggao> g = ga1.search();
       list.addAll(g);

}

6.修改数据窗口

import java.awt.Color;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;

import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextArea;
import javax.swing.JTextField;

public class Mywindow4 extends JFrame implements ActionListener {

   JTextField text, text1;
   JLabel jl, jl1;
   JPanel jp;
   JButton b;

   public Mywindow4() {
       init();
       setTitle("修改数据页面");
       setSize(450, 400);
       setVisible(true);
       setLocation(400, 320);
   }

public void init() {

setLayout(new FlowLayout());
jp = new JPanel();

       jl = new JLabel(" 请输入修改的广告名 :");
       jl.setFont(new Font("宋体", Font.PLAIN, 14));
       jl.setForeground(Color.green);

jp.add(jl);

       // 实例化JTextField标签对象化
       text = new JTextField(20);
       Dimension dim1 = new Dimension(300, 150);
       text.setPreferredSize(dim1);// 设置除顶级容器组件以外其他组件的大小

       jp.add(text);
       jl1 = new JLabel("请输入修改的审核状态:");
       jl1.setFont(new Font("宋体", Font.PLAIN, 15));
       jl1.setForeground(Color.green);

jp.add(jl1);

       // 实例化JTextField标签对象化
       text1 = new JTextField(20);
       Dimension dim2 = new Dimension(300, 30);
       text.setPreferredSize(dim2);// 设置除顶级容器组件以外其他组件的大小
       jp.add(text1);

       // 实例化JButton组件
       b = new JButton();
       // 设置按键的显示内容
       Dimension dim3 = new Dimension(300, 30);
       b.setText("确定");
       b.setFont(new Font("宋体", Font.PLAIN, 14));
       // 设置按键大小
       b.setSize(dim3);
       ImageIcon image=new ImageIcon("pic/OIP-C (1).jpg");
       JLabel label=new JLabel(image);
       jp.add(label);
       add(jp);
       add(jl);
       add(text);
       add(jl1);
       add(text1);
       add(b);

b.addActionListener(this); // 注册事件
}

   public static void main(String[] args) {
       // TODO Auto-generated method stub
       MyWindow1 mywindow = new MyWindow1();

}

   @Override
   public void actionPerformed(ActionEvent e) {
       // TODO Auto-generated method stub
       guanggao_Dao ga1 = new guanggao_Dao();

guanggao gao = new guanggao(text.getText(), text1.getText());

ArrayList<guanggao> list = new ArrayList<guanggao>();

       ga1.Updata(gao);

       ArrayList<guanggao> g = ga1.search();
       list.addAll(g);

}

7.删除数据窗口

import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.swing.JButton;
import javax.swing.*;
import javax.swing.JTextArea;

public class Mywindow5 extends JFrame implements ActionListener {
   JTextField text;
   JLabel jl;
   JPanel jp, jp1;
   JButton b;

public Mywindow5()

   {
       init();
       setTitle("删除数据页面");
       setSize(450, 350);
       setVisible(true);
       setLocation(400, 320);
       setFont(new Font("宋体", Font.PLAIN, 14));
   }

   public void init() {
       setLayout(new FlowLayout());
       jp = new JPanel();
       jp.setLayout(new FlowLayout());
       jp1 = new JPanel();
       jp1.setLayout(new BorderLayout());
       jl = new JLabel("请输入删除的序号:");
       jl.setForeground(Color.PINK);
       jl.setFont(new Font("宋体", Font.BOLD, 16));
       jp.add(jl);

       // 实例化JTextField标签对象化
       text = new JTextField(15);
       Dimension dim1 = new Dimension(300, 30);
       text.setPreferredSize(dim1);// 设置除顶级容器组件以外其他组件的大小
       jp.add(text);

// 实例化JButton组件
b = new JButton();

       b.setText("确定");
       b.setFont(new Font("宋体", Font.BOLD, 16));
       // 设置按键大小
       this.add(jp, BorderLayout.CENTER);
       jp1.add(b);
       this.add(b, BorderLayout.NORTH);
       ImageIcon image=new ImageIcon("pic/OIP-C.jpg");
       JLabel label=new JLabel(image);
       jp.add(label);
       add(jp);
       add(jl);
       add(text);

       add(b);
       b.addActionListener(this); // 注册事件
   }

   public static void main(String[] args) {
       // TODO Auto-generated method stub
       MyWindow1 mywindow = new MyWindow1();

}

   @Override
   public void actionPerformed(ActionEvent e) {
       // TODO Auto-generated method stub
       guanggao_Dao ga1 = new guanggao_Dao();

guanggao gao = new guanggao(text.getText());
ArrayList<guanggao> list = new ArrayList<guanggao>();

       try {
           ga1.Delete(gao);
       } catch (SQLException e1) {
           // TODO Auto-generated catch block
           e1.printStackTrace();
       }
       ArrayList<guanggao> g = ga1.search();
       list.addAll(g);

}
}

8.查看数据窗口

import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.FlowLayout;
import java.awt.Font;
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.SQLException;
import java.util.ArrayList;

import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.ScrollPaneConstants;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.JTableHeader;

import extra.zy_Dao.*;

public class Mywindow6 extends JFrame {
   private JScrollPane scpDemo;
   private JTableHeader jth;
   private JTable tabDemo;

   public Mywindow6() {
       init();
       setTitle("运行后的数据页面");
       setSize(600, 500);
       setVisible(true);
       setLocation(400, 320);
       setFont(new Font("宋体", Font.PLAIN, 14));
   }

   public void init() {
       setLayout(new BorderLayout());
       setLayout(new FlowLayout());
       this.scpDemo = new JScrollPane();
       scpDemo.setSize(500, 600);
       ArrayList<guanggao> list = new ArrayList<guanggao>();
       guanggao_Dao ga = new guanggao_Dao();

       ga.re(null);
       ArrayList<guanggao> g = ga.search();
           list.addAll(g);
       list.addAll(g);
       JTable table = new JTable();// 创建表格
       String[] title = { "序号", "广告名", "广告内容", "审核状态", "时间", "点击率" };// 表头信息
       // 创建表格模型
       DefaultTableModel tableModel = new DefaultTableModel(null, title);
       for (guanggao gao : list) {
           Object[] rowData = { gao.getId(), gao.getName(), gao.getContent(), gao.getCheck(), gao.getTime(),
                   gao.getPoint() };
           tableModel.addRow(rowData);// 把ArrayList中的数据放入表格模型
       }
       table.setModel(tableModel);
       // 表格间距
       // 美化
       JTableHeader header = table.getTableHeader();
       header.setBackground(Color.yellow);
       header.setFont(new Font("宋体", Font.BOLD, 16));
//窗口上下栏间距
       table.setSize(630, 450);