1. package hu.wowemuf.TestPrograms;
  3. /**
  4. *
  5. * @author Szilárd
  6. */
  7. import java.sql.*;
  8. import java.awt.*;
  9. import javax.swing.*;
  10. import javax.swing.table.DefaultTableModel;
  12. public class MultipleRowDisplayer {
  13. protected String connectionURL;
  14. protected Connection connection;
  15. protected Statement statement;
  16. protected ResultSet rs;
  18. protected String charName;
  19. protected String charRace;
  20. protected String charClass;
  22. @SuppressWarnings("CallToThreadDumpStack")
  23. public static void main(String[] args){
  24. try{
  25. new MultipleRowDisplayer().connectToServer();
  26. } catch(Exception ex){
  27. ex.printStackTrace();
  28. }
  29. }
  30. @SuppressWarnings("FinalizeDeclaration")
  31. protected void finalize() throws Throwable{
  32. if(rs != null){
  33. rs.close();
  34. if(statement != null){
  35. statement.close();
  36. if(connection != null){
  37. connection.close();
  38. }
  39. }
  40. }
  42. super.finalize();
  43. }
  44. /**
  45. * @param accID - Ez ugyis csak teszt szintjen megy egyelore, a beepitett rendszerbe mashogy ultetem at.
  46. * @throws Exception
  47. */
  48. private void userInterface(int accID) throws Exception{
  49. JFrame frame = new JFrame("JTableManager @ TESTPHASE");
  50. frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  51. frame.setSize(800,600);
  53. Object[] colNames = {"Név","Faj","Kaszt"};
  55. JPanel mainPanel = new JPanel();
  56. mainPanel.setLayout(new GridLayout(1,1));
  58. DefaultTableModel dtm = new DefaultTableModel(new Object[][]{},colNames);
  59. JTable mainTable = new JTable(dtm);
  60. mainTable.setOpaque(true);
  61. mainTable.setBackground(new Color(0,0,0,0));
  62. mainTable.getTableHeader().setEnabled(false);
  63. mainTable.setEnabled(false);
  65. String QueryThread = "SELECT `name`,`race`,`class` FROM `characters` WHERE `account`="+accID+"";
  66. rs = statement.executeQuery(QueryThread);
  68. while(rs.next()){
  69. charName = rs.getString("name");
  70. charRace = rs.getString("race");
  71. charClass = rs.getString("class");
  73. dtm.addRow(new Object[]{charName,charRace,charClass}); // Ez vegzi el a piszkos munkat.
  74. }
  76. JScrollPane tableScroller = new JScrollPane(mainTable);
  77. tableScroller.setHorizontalScrollBarPolicy(ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
  78. tableScroller.setVerticalScrollBarPolicy(ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED);
  80. mainTable.setFillsViewportHeight(true);
  82. mainPanel.add(tableScroller); // Kicsit becsomagolva kapjuk majd meg.
  84. frame.getContentPane().add(BorderLayout.CENTER,mainPanel);
  85. frame.setLocation(400,200);
  86. frame.setVisible(true);
  87. }
  88. private void connectToServer() throws Exception{
  89. connectionURL = "jdbc:mysql://localhost:3306/characters";
  90. connection = null;
  91. statement = null;
  92. rs = null;
  94. Class.forName("com.mysql.jdbc.Driver").newInstance();
  96. connection = DriverManager.getConnection(connectionURL,"root","root");
  98. statement = connection.createStatement();
  100. if(connection != null){
  101. System.out.println("Connection established.");
  102. this.userInterface(5); // Az UI felepitese a megfelelo modon, kicsit fapados megoldassal.
  103. } else{
  104. System.err.println("Error while connecting.");
  105. }
  106. }
  107. }