質問編集履歴

PlanAndGameクラスの追加

2016/12/14 11:37

投稿

mercredi

スコア26

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -109,3 +109,477 @@
 Javaの列の型をStringにすると挿入できます。
 日付入力は'DD-MON-RR'フォーマット以外にもいろいろな型を試してみました。
+```PlayAndGameクラスのコード
+class PlayerAndGame extends JFrame {
+	private JPanel mainPanel = new JPanel();
+	private JPanel bottomLeft = new JPanel();
+	private JPanel topPanel = new JPanel();
+	private JPanel middlePanel = new JPanel();
+	private JPanel bottomRight = new JPanel();
+	private JLabel lLabel = new JLabel();
+	private JLabel rLabel = new JLabel();
+	private JLabel lblScore = new JLabel();
+	private JLabel lblDate = new JLabel();
+	private DefaultTableModel aModel = new DefaultTableModel();
+	private DefaultTableModel bModel=new DefaultTableModel();
+	private JTable lTable = new JTable(aModel);
+	private JTable rTable = new JTable(bModel);
+	private JTextField txtScore = new JTextField(15);
+	private JTextField txtDate = new JTextField(15);
+	private JScrollPane scroll1 = new JScrollPane(lTable);
+	private JScrollPane scroll2 = new JScrollPane(rTable);
+	DatabaseMainTest db = new DatabaseMainTest();
+	private Vector rows = new Vector();
+	private Vector columns = new Vector();
+	private Vector p_rows = new Vector();
+	private Vector p_columns = new Vector();
+	String selectedData = null;
+	String selectedData2 = null;
+	private JButton btnInsert = new JButton();
+	private JButton playerButton = new JButton();
+	private JButton gameButton = new JButton();
+	public JTable getlTable() {
+		return lTable;
+	}
+	public JTable getrTable() {
+		return rTable;
+	}
+	public JTextField getTxtScore() {
+		return txtScore;
+	}
+	public JTextField getTxtDate() {
+		return txtDate;
+	}
+	public String getSelectedData() {
+		return selectedData;
+	}
+	public String getSelectedData2() {
+		return selectedData;
+	}
+	public PlayerAndGame() throws SQLException {
+		this.setSize(700, 700);
+		this.setTitle("Game Information");
+		mainPanel.setLayout(new GridLayout(3, 2, 5, 5));
+		bottomLeft.setLayout(new GridLayout(3, 1, 2, 2));
+		bottomRight.setLayout(new GridLayout(2, 1, 2, 2));
+		topPanel.setLayout(new GridLayout(1, 2));
+		middlePanel.setLayout(new GridLayout(1, 2));
+		mainPanel.add(lLabel);
+		mainPanel.add(rLabel);
+		mainPanel.add(scroll1);
+		mainPanel.add(scroll2);
+		topPanel.add(lblScore);
+		topPanel.add(txtScore);
+		middlePanel.add(lblDate);
+		middlePanel.add(txtDate);
+		bottomLeft.add(topPanel);
+		bottomLeft.add(middlePanel);
+		bottomLeft.add(btnInsert);
+		bottomRight.add(playerButton);
+		mainPanel.add(bottomLeft);
+		bottomRight.add(gameButton);
+		mainPanel.add(bottomRight);
+		add(mainPanel);
+//		System.out.print(txtScore.getText().toString());
+//		System.out.print(txtDate.getText().toString());
+		ResultSet gameRS = db.getTableInfo("Game");
+		ResultSetMetaData gameMD = gameRS.getMetaData();
+		// create columns headers
+		for (int i = 1; i <= gameMD.getColumnCount(); i++) {
+			columns.addElement(gameMD.getColumnName(i));
+		}
+		//
+		int row = 0;
+		while (gameRS.next())// loop for rows
+		{
+			Vector vRow = new Vector(); // to store the current row
+			for (int i = 1; i <= gameMD.getColumnCount(); i++)// loop for columns
+			{
+				Object columnValue = gameRS.getObject(i);
+				vRow.addElement(columnValue.toString());
+			}
+			row += 1;
+			rows.addElement(vRow);// add individual row vectors to rows
+		}
+		aModel.setDataVector(rows, columns);
+		gameRS.close();//end of display the game table
+		///////////////////////////////////////////////////////////
+		ResultSet playerRS = db.getTableInfo("Player");
+		ResultSetMetaData playerMD = playerRS.getMetaData();
+		// create columns headers
+		for (int i = 1; i <= playerMD.getColumnCount(); i++) {
+			p_columns.addElement(playerMD.getColumnName(i));
+		}
+		//
+		int playerRow = 0;
+		while (playerRS.next())// loop for rows
+		{
+			Vector vRow = new Vector(); // to store the current row
+			for (int i = 1; i <= playerMD.getColumnCount(); i++)// loop for columns
+			{
+				Object columnValue = playerRS.getObject(i);
+				vRow.addElement(columnValue.toString());
+			}
+			row += 1;
+			p_rows.addElement(vRow);// add individual row vectors to rows
+		}
+		bModel.setDataVector(p_rows, p_columns);
+		playerRS.close();//end of display the player table
+		///////////////////////////////////////////
+		lTable.setCellSelectionEnabled(true);
+		ListSelectionModel cellSelectionModel = lTable.getSelectionModel();
+		cellSelectionModel.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
+		cellSelectionModel.addListSelectionListener(new ListSelectionListener() {
+			public void valueChanged(ListSelectionEvent e) {
+				int[] selectedRow = lTable.getSelectedRows();
+				int[] selectedColumns = lTable.getSelectedColumns();
+				for (int i = 0; i < selectedRow.length; i++) {
+					for (int j = 0; j < selectedColumns.length; j++) {
+						selectedData = (String) lTable.getValueAt(selectedRow[i], selectedColumns[j]);
+					}
+				}
+				System.out.println("Selected: " + selectedData);
+			}
+		});// end of selection lister argument for lTable
+		rTable.setCellSelectionEnabled(true);
+		cellSelectionModel = rTable.getSelectionModel();
+		cellSelectionModel.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
+		cellSelectionModel.addListSelectionListener(new ListSelectionListener() {
+			public void valueChanged(ListSelectionEvent e) {
+				int[] selectedRow = rTable.getSelectedRows();
+				int[] selectedColumns = rTable.getSelectedColumns();
+				for (int i = 0; i < selectedRow.length; i++) {
+					for (int j = 0; j < selectedColumns.length; j++) {
+						selectedData2 = (String) rTable.getValueAt(selectedRow[i], selectedColumns[j]);
+					}
+				}
+				System.out.println("Selected: " + selectedData2);
+			}
+		});// end of selection lister argument for rTable
+		btnInsert.addActionListener(new ActionListener() // anonymous inner class
+		{
+			@Override
+			public void actionPerformed(ActionEvent arg0) {
+//				PreparedStatement pst=db.insertTable();
+				lblScore.setText(txtScore.getText());
+				lblDate.setText(txtDate.getText());
+			try {
+				db.insertTable();
+			} catch (SQLException e) {
+				// TODO Auto-generated catch block
+				e.printStackTrace();
+			} catch (ParseException e) {
+				// TODO Auto-generated catch block
+				e.printStackTrace();
+			}
+			}
+		} // end of insert button event handler
+		);
+	}// end of constructor
+	public static void main(String[] args) throws SQLException {
+		DatabaseMainTest db = new DatabaseMainTest();
+//		System.out.println(db.getTableInfo());
+		PlayerAndGame pAndGame = new PlayerAndGame();
+		pAndGame.setFont(new Font("Arial", Font.BOLD, 24));
+		// Validate frames that have preset sizes
+		// Pack frames that have useful preferred size info, e.g. from their
+		// layout
+		// Center the window
+		Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
+		Dimension frameSize = pAndGame.getSize();
+		if (frameSize.height > screenSize.height) {
+			frameSize.height = screenSize.height;
+		}
+		if (frameSize.width > screenSize.width) {
+			frameSize.width = screenSize.width;
+		}
+		pAndGame.setLocation((screenSize.width - frameSize.width) / 2, (screenSize.height - frameSize.height) / 2);
+		pAndGame.setVisible(true);
+	}
+} // end of PlayerAndGame class
+```