时间:2021-07-01 10:21:17 帮助过:29人阅读
- package demo;
- import java.awt.BorderLayout;
- import java.awt.Container;
- import java.awt.event.MouseAdapter;
- import java.awt.event.MouseEvent;
- import java.awt.event.MouseListener;
- import java.sql.ResultSet;
- import java.sql.ResultSetMetaData;
- import java.sql.SQLException;
- import java.util.Vector;
- import javax.swing.JButton;
- import javax.swing.JFrame;
- import javax.swing.JLabel;
- import javax.swing.JPanel;
- import javax.swing.JScrollPane;
- import javax.swing.JTable;
- public class DeMO {
- public DeMO(){
- JFrame frame=new JFrame("暮雪超霸");
- Container contentPane = frame.getContentPane();
- JPanel panel=new JPanel();
- JPanel panel1=new JPanel();
- JPanel panel2=new JPanel();
- JLabel jLabel=new JLabel("超霸");
- JButton button=new JButton("开始");
- JButton button2=new JButton("暂停");
- JButton button3=new JButton("下一首");
- contentPane.setLayout(new BorderLayout());
- panel.add(jLabel);
- panel.add(button);
- panel.add(button2);
- panel.add(button3);
- contentPane.add(panel,BorderLayout.NORTH);
- JButton button4=new JButton("退出");
- Conn con=new Conn();
- ResultSet select = con.getSelect("select *from chaoba");
- Vector col = getCol(select);
- Vector data = getData(select);
- JTable jTable=new JTable(data,col);
- JScrollPane jScrollPane=new JScrollPane();
- jScrollPane.getViewport().add(jTable);
- panel1.add(button4);
- panel2.add(jScrollPane);
- contentPane.add(panel1,BorderLayout.SOUTH);
- contentPane.add(panel2,BorderLayout.CENTER);
- frame.setSize(600, 400);
- frame.setVisible(true);
- button.addMouseListener(new MouseAdapter() {
- @Override
- public void mouseClicked(MouseEvent arg0) {
- System.out.println("开始");
- }
- });
- button2.addMouseListener(new MouseAdapter() {
- @Override
- public void mouseClicked(MouseEvent arg0) {
- System.out.println("暂停");
- }
- });
- }
- public static void main(String[] args) {
- new DeMO();
- }
- public Vector getCol(ResultSet rs){
- Vector col=new Vector();
- try {
- ResultSetMetaData metaData = rs.getMetaData();
- int columnCount = metaData.getColumnCount();
- for (int i = 1; i <= columnCount; i++) {
- col.add(metaData.getColumnName(i));
- }
- } catch (Exception e) {
- // TODO 自动生成的 catch 块
- e.printStackTrace();
- }
- return col;
- }
- public Vector getData(ResultSet rs){
- Vector data=new Vector();
- try {
- ResultSetMetaData metaData = rs.getMetaData();
- int columnCount = metaData.getColumnCount();
- while (rs.next()) {
- Vector v=new Vector();
- for(int i=1;i<=columnCount;i++)
- {
- v.addElement(rs.getString(i));
- }
- data.addElement(v);
- }
- } catch (SQLException e) {
- // TODO 自动生成的 catch 块
- e.printStackTrace();
- }
- return data;
- }
- }
- package demo;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.ResultSetMetaData;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.util.Vector;
- public class Conn {
- Connection con;
- public Conn(){
- try {
- Class.forName("com.mysql.jdbc.Driver");
- String url="jdbc:mysql://localhost:3306/chaoba?user=root&password=root&useUnicode=true&characterEncoding=UTF8";
- con=DriverManager.getConnection(url);
- } catch (Exception e) {
- // TODO 自动生成的 catch 块
- e.printStackTrace();
- }
- }
- public ResultSet getSelect(String sql){
- Vector col=new Vector();
- Vector data=new Vector();
- ResultSet rs=null;
- Statement statement;
- try {
- statement = con.createStatement();
- rs = statement.executeQuery(sql);
- } catch (SQLException e) {
- // TODO 自动生成的 catch 块
- e.printStackTrace();
- }
- return rs;
- }
- }
java图像开发学习——JTable之导入数据库
标签:ram char url ane resultset listener package tab string