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

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 search() {
ArrayList g = new ArrayList();
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 = “UPDATEguanggao SET 点击率 = 点击率 + 1”;
pst = c.prepareStatement(sql); // 3.创建语句对象
int rs = pst.executeUpdate();

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

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

}

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 g = new ArrayList();
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 list = new ArrayList();

ArrayList 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 list = new ArrayList();
guanggao_Dao ga = new guanggao_Dao();
ArrayList 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 list = new ArrayList();

ga1.Insert(gao);
ArrayList 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 list = new ArrayList();

ga1.Updata(gao);

ArrayList 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 list = new ArrayList();

try {
ga1.Delete(gao);
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
ArrayList 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 list = new ArrayList();
guanggao_Dao ga = new guanggao_Dao();

ga.re(null);
ArrayList 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);

// 把表格添加到窗口中
add(new JScrollPane(table), BorderLayout.SOUTH);// 窗口的默认布局是边界布局

}

public static void main(String[] args) {
Mywindow6 m6 = new Mywindow6();
}

}

实现截图：