当前位置:Gxlcms > 数据库问题 > java图像开发学习——JTable之导入数据库

java图像开发学习——JTable之导入数据库

时间:2021-07-01 10:21:17 帮助过:29人阅读

  1. package demo;
  2. import java.awt.BorderLayout;
  3. import java.awt.Container;
  4. import java.awt.event.MouseAdapter;
  5. import java.awt.event.MouseEvent;
  6. import java.awt.event.MouseListener;
  7. import java.sql.ResultSet;
  8. import java.sql.ResultSetMetaData;
  9. import java.sql.SQLException;
  10. import java.util.Vector;
  11. import javax.swing.JButton;
  12. import javax.swing.JFrame;
  13. import javax.swing.JLabel;
  14. import javax.swing.JPanel;
  15. import javax.swing.JScrollPane;
  16. import javax.swing.JTable;
  17. public class DeMO {
  18. public DeMO(){
  19. JFrame frame=new JFrame("暮雪超霸");
  20. Container contentPane = frame.getContentPane();
  21. JPanel panel=new JPanel();
  22. JPanel panel1=new JPanel();
  23. JPanel panel2=new JPanel();
  24. JLabel jLabel=new JLabel("超霸");
  25. JButton button=new JButton("开始");
  26. JButton button2=new JButton("暂停");
  27. JButton button3=new JButton("下一首");
  28. contentPane.setLayout(new BorderLayout());
  29. panel.add(jLabel);
  30. panel.add(button);
  31. panel.add(button2);
  32. panel.add(button3);
  33. contentPane.add(panel,BorderLayout.NORTH);
  34. JButton button4=new JButton("退出");
  35. Conn con=new Conn();
  36. ResultSet select = con.getSelect("select *from chaoba");
  37. Vector col = getCol(select);
  38. Vector data = getData(select);
  39. JTable jTable=new JTable(data,col);
  40. JScrollPane jScrollPane=new JScrollPane();
  41. jScrollPane.getViewport().add(jTable);
  42. panel1.add(button4);
  43. panel2.add(jScrollPane);
  44. contentPane.add(panel1,BorderLayout.SOUTH);
  45. contentPane.add(panel2,BorderLayout.CENTER);
  46. frame.setSize(600, 400);
  47. frame.setVisible(true);
  48. button.addMouseListener(new MouseAdapter() {
  49. @Override
  50. public void mouseClicked(MouseEvent arg0) {
  51. System.out.println("开始");
  52. }
  53. });
  54. button2.addMouseListener(new MouseAdapter() {
  55. @Override
  56. public void mouseClicked(MouseEvent arg0) {
  57. System.out.println("暂停");
  58. }
  59. });
  60. }
  61. public static void main(String[] args) {
  62. new DeMO();
  63. }
  64. public Vector getCol(ResultSet rs){
  65. Vector col=new Vector();
  66. try {
  67. ResultSetMetaData metaData = rs.getMetaData();
  68. int columnCount = metaData.getColumnCount();
  69. for (int i = 1; i <= columnCount; i++) {
  70. col.add(metaData.getColumnName(i));
  71. }
  72. } catch (Exception e) {
  73. // TODO 自动生成的 catch 块
  74. e.printStackTrace();
  75. }
  76. return col;
  77. }
  78. public Vector getData(ResultSet rs){
  79. Vector data=new Vector();
  80. try {
  81. ResultSetMetaData metaData = rs.getMetaData();
  82. int columnCount = metaData.getColumnCount();
  83. while (rs.next()) {
  84. Vector v=new Vector();
  85. for(int i=1;i<=columnCount;i++)
  86. {
  87. v.addElement(rs.getString(i));
  88. }
  89. data.addElement(v);
  90. }
  91. } catch (SQLException e) {
  92. // TODO 自动生成的 catch 块
  93. e.printStackTrace();
  94. }
  95. return data;
  96. }
  97. }

  

  1. package demo;
  2. import java.sql.Connection;
  3. import java.sql.DriverManager;
  4. import java.sql.ResultSet;
  5. import java.sql.ResultSetMetaData;
  6. import java.sql.SQLException;
  7. import java.sql.Statement;
  8. import java.util.Vector;
  9. public class Conn {
  10. Connection con;
  11. public Conn(){
  12. try {
  13. Class.forName("com.mysql.jdbc.Driver");
  14. String url="jdbc:mysql://localhost:3306/chaoba?user=root&password=root&useUnicode=true&characterEncoding=UTF8";
  15. con=DriverManager.getConnection(url);
  16. } catch (Exception e) {
  17. // TODO 自动生成的 catch 块
  18. e.printStackTrace();
  19. }
  20. }
  21. public ResultSet getSelect(String sql){
  22. Vector col=new Vector();
  23. Vector data=new Vector();
  24. ResultSet rs=null;
  25. Statement statement;
  26. try {
  27. statement = con.createStatement();
  28. rs = statement.executeQuery(sql);
  29. } catch (SQLException e) {
  30. // TODO 自动生成的 catch 块
  31. e.printStackTrace();
  32. }
  33. return rs;
  34. }
  35. }

  

java图像开发学习——JTable之导入数据库

标签:ram   char   url   ane   resultset   listener   package   tab   string   

人气教程排行