public void testCardLayout() throws Exception { JComponent rootComponent = getInstrumentedRootComponent("TestCardLayout.form", "BindingTest"); assertTrue(rootComponent.getLayout() instanceof CardLayout); CardLayout cardLayout = (CardLayout) rootComponent.getLayout(); assertEquals(10, cardLayout.getHgap()); assertEquals(20, cardLayout.getVgap()); }
public void setVisible(boolean bShow, String title) { if (bShow) { String strDir = ""; String strFreq = ""; String strTraynum = ""; m_strHelpFile = getHelpFile(title); String strSampleName = getSampleName(title); String frameBounds = getFrameBounds(title); StringTokenizer tok = new QuotedStringTokenizer(title); if (tok.hasMoreTokens()) strDir = tok.nextToken(); if (tok.hasMoreTokens()) strFreq = tok.nextToken(); if (tok.hasMoreTokens()) strTraynum = tok.nextToken(); else { try { Integer.parseInt(strDir); // if strdir is number, then strdir is empty, and the // strfreq is the number strTraynum = strFreq; strFreq = strDir; strDir = ""; } catch (Exception e) { } } try { setTitle(gettitle(strFreq)); m_lblSampleName.setText("3"); boolean bVast = isVast(strTraynum); CardLayout layout = (CardLayout) m_pnlSampleName.getLayout(); if (!bVast) { if (strSampleName == null) { strSampleName = getSampleName(strDir, strTraynum); } m_lblSampleName.setText(strSampleName); layout.show(m_pnlSampleName, OTHER); } else { m_strDir = strDir; setTrays(); layout.show(m_pnlSampleName, VAST); m_trayTimer.start(); } boolean bSample = bVast || !strSampleName.trim().equals(""); m_pnlSampleName.setVisible(bSample); m_lblLogin.setForeground(getBackground()); m_lblLogin.setVisible(false); m_passwordField.setText(""); m_passwordField.setCaretPosition(0); } catch (Exception e) { Messages.writeStackTrace(e); } setBounds(frameBounds); ExpPanel exp = Util.getActiveView(); if (exp != null) exp.waitLogin(true); } writePersistence(); setVisible(bShow); }
/* * Button or JTextField clicked */ public void switchCards(String s) { System.out.println("Switching to " + s); CardLayout cl = (CardLayout) (mainPanels.getLayout()); cl.show(mainPanels, s); mainPanels.revalidate(); CardLayout cl2 = (CardLayout) (sidePanels.getLayout()); cl2.show(sidePanels, s); sidePanels.revalidate(); }
/** Connect the vector of QV's into the main View */ public void installQVs() { Exam thisExam = theTD.curX; Vector qv = thisExam.getListData(); for (int i = 0; i < qv.size(); i++) { // Use question number (1-origin) as string name. // System.out.println("Add question " +i +" to " + questionsPanel); questionsPanel.add(Integer.toString(i + 1), new QView((Q) qv.elementAt(i))); } myCardLayout.first(questionsPanel); }
/** Change the view to display a given question number (1-origin) */ protected void setQNumber(int nn) { String userShowNumber = Integer.toString(nn); System.out.println("setQNumber(" + userShowNumber + ");"); // notify the model // TODO -- if necessary! // update the view numTF.setText(userShowNumber); numSlider.setValue(nn); // show the right question myCardLayout.show(questionsPanel, userShowNumber); }
public void actionPerformed(ActionEvent e) { if (e.getSource() == ld.st) // 0.로딩화면에서 Enter버튼 클릭 { System.out.println("할리갈리 온라인 안쪽으로 접근중..."); card.show(getContentPane(), "LOG"); } else if (e.getSource() == login.bt1) // 1.팝업창으로 회원가입창 띄우기 { mID.setBounds(470, 310, 340, 420); mID.setVisible(true); } else if (e.getSource() == login.bt2) // 2.로그인버튼 누르기 { ld.clip.stop(); wr.clip.play(); id = login.tf.getText().trim(); // ID입력안했을때 if (id.length() < 1) { JOptionPane.showMessageDialog(this, "ID를 입력하세요"); login.tf.requestFocus(); return; } String pass = new String(login.pf.getPassword()); // PWD입력안했을때 if (pass.length() < 1) { JOptionPane.showMessageDialog(this, "Password를 입력하세요"); login.pf.requestFocus(); return; } connection(); // 모두 정확히 처리했으면, connection()메소드로 이동!! try { out.write( (Function.LOGIN + "|" + id + "|" // 로그인버튼 눌러서 server에게 요청 + pass + "\n") .getBytes()); } catch (Exception ex) { } } else if (e.getSource() == wr.tf || e.getSource() == wr.b1) // 3.waitroom에서 채팅입력할 때 { String data = wr.tf.getText(); // 입력한 값 가져오기 if (data.length() < 1) return; try { out.write((Function.WAITCHAT1 + "|" + data + "\n").getBytes()); // 채팅전송을 server에게 요청 } catch (Exception ex) { } wr.tf.setText(""); } else if (e.getSource() == gw.tf || e.getSource() == gw.b1) // 4.gameWindow에서 채팅입력할 때 { String data = gw.tf.getText(); // 입력한 값 가져오기 if (data.length() < 1) return; try { out.write((Function.ROOMCHAT + "|" + data + "\n").getBytes()); // 채팅전송을 server에게 } catch (Exception ex) { } gw.tf.setText(""); } else if (e.getSource() == wr.b2) // 5.방만들기창 { mr.tf.setText(""); // 방만들기 초기화 mr.pf.setText(""); mr.rb1.setSelected(true); mr.setBounds(500, 300, 260, 290); mr.setVisible(true); } else if (e.getSource() == wr.b3) // 6.방들어가기 버튼처리 ///////////////////////////////// { wr.clip.stop(); gw.clip.play(); System.out.println("방유저리스트수: " + gw.model1.getRowCount()); for (int i = 0; i < gw.model1.getRowCount(); i++) { System.out.println("방유저리스트삭제"); gw.model1.removeRow(i); // 추가 } // gw.model1.removeRow(0); //추가 if (rowNum >= 0) { try { gw.ta.setText(""); out.write((Function.JOINROOM + "|" + rowNum + "\n").getBytes()); } catch (Exception e2) { } } } else if (e.getSource() == mr.b1) // 6.방만들기창에서 확인 눌렀을때////////////////////////////// { wr.clip.stop(); gw.clip.play(); gw.clip.loop(); String subject = mr.tf.getText().trim(); // 방이름 입력 안했을때 if (subject.length() < 1) { JOptionPane.showMessageDialog(this, "방이름을 입력하세요"); mr.tf.requestFocus(); return; } if (mr.rb2.isSelected()) { // 비공개 버튼 눌렀을 때 String pw = new String(mr.pf.getPassword()); if (pw.length() < 1) { JOptionPane.showMessageDialog(this, "비밀번호를 입력하세요"); mr.pf.requestFocus(); return; } } mr.dispose(); /*System.out.println("방유저리스트수: "+gw.model1.getRowCount()); for(int i=0;i<gw.model1.getRowCount();i++) { System.out.println("방유저리스트삭제"); gw.model1.removeRow(i); //추가 }*/ try { String roomType = ""; // 1.공개or비공개 저장 if (mr.rb1.isSelected()) { roomType = mr.rb1.getText(); } // 공개 else if (mr.rb2.isSelected()) { roomType = mr.rb2.getText(); } // 비공개 String roomName = mr.tf.getText(); // 2.방이름 String capaNum = mr.box.getSelectedItem().toString(); // 3.최대인원수 out.write( (Function.MAKEROOM + "|" + roomType + "|" + roomName + "|" + capaNum + "\n") .getBytes()); // 공개여부,방이름,최대인원 넘겨줌 } catch (Exception ex) { } } else if (e.getSource() == wr.b8) // 도움말 버튼처리 { help.setVisible(true); repaint(); } else if (e.getSource() == wr.b9) // 게임종료 버튼처리 { /*서버로 종료 메시지 전송후 프로그램 종료*/ try { out.write((Function.CLIENTEXIT + "|\n").getBytes()); } catch (Exception e2) { } try { s.close(); // 소켓해제 } catch (IOException e1) { e1.printStackTrace(); } System.exit(0); } else if (e.getSource() == mID.b1) // 가입완료버튼 { String name = mID.tf1.getText().trim(); String id = mID.tf2.getText().trim(); String pass1 = new String(mID.pf1.getPassword()); String pass2 = new String(mID.pf2.getPassword()); if (name.length() < 1) { JOptionPane.showMessageDialog(this, "이름을 입력하세요"); mID.tf1.requestFocus(); return; } else if (id.length() < 1) { JOptionPane.showMessageDialog(this, "ID를 입력하세요"); mID.tf2.requestFocus(); return; } else if (mID.ck == false) { JOptionPane.showMessageDialog(this, "ID 중복체크 하시오"); mID.tf2.requestFocus(); return; } else if (pass1.length() < 1) { JOptionPane.showMessageDialog(this, "비밀번호를 입력하세요"); mID.pf1.requestFocus(); return; } else if (pass2.length() < 1) { JOptionPane.showMessageDialog(this, "비밀번호 확인을 입력하세요"); mID.pf2.requestFocus(); return; } else if (!(pass1.equals(pass2))) { JOptionPane.showMessageDialog(this, "비밀번호가 동일하지 않습니다"); mID.pf1.requestFocus(); return; } try { out.write((Function.SUCCESSJOIN + "|" + name + "|" + id + "|" + pass1 + "\n").getBytes()); } catch (IOException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } JOptionPane.showMessageDialog(this, "회원가입완료"); mID.dispose(); } else if (e.getSource() == mID.b2) { mID.tf1.setText(""); mID.tf2.setText(""); mID.pf1.setText(""); mID.pf2.setText(""); mID.dispose(); } else if (e.getSource() == mID.b3) // ID중복체크 { String id = mID.tf2.getText().trim(); if (id.length() < 1) { JOptionPane.showMessageDialog(this, "ID를 입력하세요"); mID.tf2.requestFocus(); return; } if (mID.num == 0) // 한번도 소켓을 연결하지 않았다면 { System.out.println("연결시도"); connection(); mID.num++; } System.out.println("ID중복체크"); try { System.out.println(id); out.write((Function.IDCHECK + "|" + id + "\n").getBytes()); // ID중복체크를 server에게 요청 } catch (Exception ex) { } } else if (e.getSource() == gw.b4) { // GameWindow에서 준비버튼 눌렀을 때 gw.clip.stop(); gw.clip3.play(); try { out.write((Function.ROOMREADY + "|" + "\n").getBytes()); } catch (IOException e1) { e1.printStackTrace(); } } else if (e.getSource() == gw.b5) { // GameWindow에서 시작버튼 눌렀을 때 try { out.write((Function.ROOMSTART + "|" + "\n").getBytes()); gw.b5.setEnabled(false); } catch (IOException e1) { e1.printStackTrace(); } } else if (e.getSource() == gw.b6) // GameWindow에서 나가기 눌렀을 때 { gw.clip.stop(); gw.clip2.play(); wr.clip.play(); System.out.println("방나가기 버튼 Click"); System.out.println("방유저리스트수: " + gw.model1.getRowCount()); // int tmp=gw.model1.getRowCount(); /*for(int i=0;i<gw.model1.getRowCount();i++) { gw.model1.removeRow(i); //추가 }*/ // gw.model1. wr.ta.setText(""); // 수정 gw.b4.setEnabled(true); try { out.write((Function.EXITROOM + "|" + "\n").getBytes()); } catch (Exception ex) { } } else if (e.getSource() == gw.cardOpen) // 카드뒤집기 눌렀을 때!!! { gw.clip4.play(); // 카드 넘기는 소리 gw.cardOpen.setBorderPainted(false); gw.cardOpen.setContentAreaFilled(false); gw.cardOpen.setEnabled(false); try { out.write((Function.CARDOPEN + "|" + id + "\n").getBytes()); } catch (IOException e1) { e1.printStackTrace(); } } else if (e.getSource() == gw.bell) // 종치기 버튼 { gw.clip1.play(); // 종치는소리 try { out.write((Function.BELL + "|" + id + "\n").getBytes()); } catch (IOException e1) { e1.printStackTrace(); } } }
@Override public void run() { // client와 server간의 통신 while (true) { try { String msg = in.readLine(); System.out.println("Server=>" + msg); StringTokenizer st = new StringTokenizer(msg, "|"); int protocol = Integer.parseInt(st.nextToken()); switch (protocol) { case Function.YOURTURN: // 0.자기차례일 때 카드뒤집기 버튼활성화 { gw.cardOpen.setBorderPainted(false); gw.cardOpen.setContentAreaFilled(false); gw.cardOpen.setEnabled(true); } break; case Function.DELROW: // 1.게임종료한 client 정보 접속자 List 에서 삭제 { int rowIndex = (Integer.parseInt(st.nextToken())); // rowIndex=delIndex System.out.println("삭제 줄: " + rowIndex); wr.model2.removeRow(rowIndex); // 접속자리스트에서 삭제 } break; case Function.CLIENTEXIT: // 2.waitRoom 채팅방에 00님이 나가셨습니다 전송 { wr.ta.append(st.nextToken() + "\n"); wr.bar.setValue(wr.bar.getMaximum()); } break; case Function.MYLOG: // 1.window타이틀에 사용자이름 업데이트 { String id = st.nextToken(); setTitle(id); card.show(getContentPane(), "WR"); // waitingroom으로 창 전환 } break; case Function.LOGIN: // 2.접속자테이블에 사용자 업데이트 { String[] data = {st.nextToken(), st.nextToken()}; wr.model2.addRow(data); } break; case Function.ROOMUSER: // 2.게임룸 유저테이블에 유저업데이트 { System.out.println("In-ROOMUSER"); String[] data = {st.nextToken()}; gw.model1.addRow(data); } break; case Function.OUTUSER: { int rowIndex = (Integer.parseInt(st.nextToken())); // rowIndex=delIndex System.out.println("삭제 줄: " + rowIndex); gw.model1.removeRow(rowIndex); } case Function.WAITCHAT1: // 3.채팅할 때(waitroom) { wr.ta.append(st.nextToken() + "\n"); wr.bar.setValue(wr.bar.getMaximum()); } break; case Function.ROOMCHAT: // 3.채팅할 때(gameWindow) { gw.ta.append(st.nextToken() + "\n"); gw.bar.setValue(gw.bar.getMaximum()); validate(); } break; case Function.NOTOVERLAP: // 4.ID가 중복되지 않을 때 { JOptionPane.showMessageDialog(this, "ID가 중복되지 않습니다"); mID.ck = true; mID.pf1.requestFocus(); } break; case Function.OVERLAP: // 4.ID가 중복될 때 { JOptionPane.showMessageDialog(this, "ID가 중복됩니다. 다시 입력하세요."); mID.ck = false; mID.pf1.requestFocus(); } break; case Function.MAKEROOM: // 5.client가 방만들기 확인 버튼을 눌렀을 때(게임창 전환) { String roomId = st.nextToken(); // 게임룸 만든 사람 id String roomName = st.nextToken(); // 새로 만든 게임룸의 이름 String humanNum = st.nextToken(); // 현재인원수 //아직 안쓰임 String capaNum = st.nextToken(); // 최대인원수 //아직 안쓰임 setTitle("방장_" + roomId + " " + "방제_" + roomName); gw.b5.setEnabled(false); // 시작버튼 비활성화 gw.ta.setText(""); card.show(getContentPane(), "GW"); // 게임창으로 전환 } break; case Function.ROOMINFORM: // 5.client가 방만들기 확인 버튼을 눌렀을 때(waitRoom의 리스트에 방 추가) { String roomType = st.nextToken(); // 공개비공개 String roomName = st.nextToken(); // 게임룸의 이름 String nnum = st.nextToken(); // 현재인원 String num = st.nextToken(); // 최대인원 String pos = st.nextToken(); // 방상태(게임대기중) String[] data = {roomType, roomName, nnum, num, pos}; wr.model1.addRow(data); // waitRoom의 리스트에 방 추가 wr.repaint(); } break; case Function.JOINROOM: // 6.방에 들어가기 했을 때(인원 수에따라 입장 가능 여부) { String result = st.nextToken(); if (result.equals("TRUE")) { String roomMaker = st.nextToken(); String roomName = st.nextToken(); setTitle("방장_" + roomMaker + " " + "방제_" + roomName); gw.b5.setEnabled(false); // 시작버튼 비활성화 gw.tf.setText(""); card.show(getContentPane(), "GW"); // 준비버튼 활성화 gw.b4.setEnabled(true); validate(); } else { JOptionPane.showMessageDialog(this, "방이 꽉찼습니다."); } } break; case Function.ROOMREADY: // 6.준비버튼 눌렀을 때 버튼 비활성화 { System.out.println("최종적으로 준비전달받음"); gw.b4.setEnabled(false); // 준비버튼비활성화 } break; case Function.ROOMREADYBUTTON: // 7.모두준비했을 때 방장만 시작 활성화 { System.out.println("방장의 권한으로 시작버튼 활성화"); gw.b5.setEnabled(true); // 준비버튼비활성화 } break; // case Function.GAMESTART: //7.모두준비했을 때 방장만 시작 활성화 // { // System.out.println("방장의 권한으로 시작버튼 활성화"); // gw.cardOpen.setBorderPainted(false); // gw.cardOpen.setContentAreaFilled(false); // gw.cardOpen.setEnabled(false); // // } // break; /*[방인원변경 ] ->*/ case Function.CHGROOMUSER: { // 대기실 방 List table 의 특정 Row 의 방인원이 변경됨 int row = Integer.parseInt(st.nextToken()); String userNum = st.nextToken(); wr.model1.setValueAt(userNum, row, 2); wr.repaint(); } break; /*[유저상태변경] ->*/ case Function.CHGUSERPOS: { int row = Integer.parseInt(st.nextToken()); // 방번호 System.out.println("\\\\\\--->" + row); String pos = st.nextToken(); // 현재인원수 wr.model2.setValueAt(pos, row, 1); wr.repaint(); } break; /*[방상태변경 ] ->*/ case Function.CHGROOMSTATE: { // 대기실 방 List table 의 특정 Row 의 방인원이 변경됨 int row = Integer.parseInt(st.nextToken()); // 방번호 String roomState = st.nextToken(); // 방상태 wr.model1.setValueAt(roomState, row, 4); wr.repaint(); } break; /*[방나가기] ->*/ case Function.DELROOM: // 방에 사용자가 없에 방삭제 메시지 받음 { gw.tf.setText(""); int roomRow = Integer.parseInt(st.nextToken()); System.out.println(roomRow + "방 삭제"); wr.model1.removeRow(roomRow); wr.repaint(); } break; case Function.REPAINT: { String tmpName = st.nextToken(); int b = Integer.parseInt(st.nextToken()); System.out.println("InREPAIT-ID:" + tmpName + "Number:" + b); gw.UpdateDraw(tmpName, b); } break; case Function.CARDNUM: { String tmpName = st.nextToken(); // id int b = Integer.parseInt(st.nextToken()); // 카드수 System.out.println("InCARDNUM-ID:" + tmpName + "Number:" + b); gw.UpdateCardNum(tmpName, b); } break; case Function.DEAD: { gw.ta.append("당신은 죽었습니다.\n"); gw.bell.setEnabled(false); gw.cardOpen.setEnabled(false); } break; case Function.UPDATEDEAD: { String tmpName = st.nextToken(); gw.ta.append(tmpName + " 님이 죽었습니다.\n"); gw.UpdateDead(tmpName); validate(); } break; case Function.BELLSUCCESS: { String tmpName = st.nextToken(); gw.ta.append(tmpName + " 님이 종치기 성공했습니다.\n"); gw.bell.setEnabled(true); gw.CardInit(); } break; case Function.BELLFAIL: { String tmpName = st.nextToken(); gw.ta.append(tmpName + "님이 종치기 실패하였습니다.\n"); gw.bell.setEnabled(true); validate(); } break; case Function.BELL: { gw.bell.setEnabled(false); } break; case Function.TURNINFO: { gw.userName[0] = st.nextToken(); gw.userName[1] = st.nextToken(); gw.userName[2] = st.nextToken(); gw.userName[3] = st.nextToken(); } break; case Function.EXITFALSE: // 게임시작시 나가기비활성화 { gw.b6.setEnabled(false); } break; case Function.IDLABEL: // 게임시작시 id라벨 입력 { String ID = st.nextToken(); // id for (int i = 0; i < 4; i++) { if (ID.equals(gw.userName[i])) { gw.laPlayer[i].setText("Player" + (i + 1) + ": " + ID); } } } break; case Function.GAMEEXIT: { System.out.println("zzzzz"); String tmpId = st.nextToken(); String tmpMsg = st.nextToken(); gw.ta.append("게임종료=====>" + tmpId + tmpMsg); gw.b4.setEnabled(true); gw.b6.setEnabled(true); gw.CardInit(); } break; } } catch (Exception ex) { validate(); } validate(); } }
public Editor(JFrame parent, Evaluator evaluator) { super(parent, "Structure"); setModal(true); this.evaluator = evaluator; getContentPane().setLayout(new BorderLayout()); // name and type JPanel pNameType = new JPanel(new GridLayout(2, 1)); JPanel pName = new JPanel(new BorderLayout()); pName.add(new JLabel("Name: "), BorderLayout.WEST); tfName = new JTextField(evaluator.getName()); pName.add(tfName, BorderLayout.CENTER); pNameType.add(pName); JPanel pType = new JPanel(new BorderLayout()); pType.add(new JLabel("Type: "), BorderLayout.WEST); cbType = new JComboBox(types); cbType.setEditable(false); cbType.setSelectedIndex(evaluator.type); cbType.addItemListener(this); pType.add(cbType, BorderLayout.CENTER); pNameType.add(pType); getContentPane().add(pNameType, BorderLayout.NORTH); // options panel this.clOptions = new CardLayout(); this.pOptions = new JPanel(clOptions); JPanel pConstraintRoot = new JPanel(new BorderLayout()); Box pConstraintOpts = new Box(BoxLayout.Y_AXIS); JPanel pDiagonals = new JPanel(new BorderLayout()); cbDiagonals = new JCheckBox("Ignore Diagonals", evaluator.ignoreDiagonals); pDiagonals.add(cbDiagonals, BorderLayout.CENTER); pConstraintOpts.add(pDiagonals); JPanel pInvestment = new JPanel(new BorderLayout()); pInvestment.add(new Label("Investments "), BorderLayout.WEST); cbInvestment = new JComboBox(investments); cbInvestment.setEditable(false); cbInvestment.setSelectedIndex(evaluator.investments); pInvestment.add(cbInvestment, BorderLayout.CENTER); pConstraintOpts.add(pInvestment); JPanel pOrganization = new JPanel(new GridLayout(2, 1)); lOrgFileName = new JLabel("File: <none selected>"); pOrganization.add(lOrgFileName); JPanel pFileChoose = new JPanel(new FlowLayout(FlowLayout.CENTER)); JButton bFileChoose = new JButton("Choose File..."); bFileChoose.addActionListener(this); bFileChoose.setActionCommand(CMD_CHOOSE_FILE); pFileChoose.add(bFileChoose); pOrganization.add(pFileChoose); pConstraintOpts.add(pOrganization); pConstraintRoot.add(pConstraintOpts, BorderLayout.NORTH); pOptions.add(pConstraintRoot, types[CONSTRAINT]); JPanel pSizeRoot = new JPanel(new BorderLayout()); pOptions.add(pSizeRoot, types[EFFECTIVE_SIZE]); clOptions.first(pOptions); getContentPane().add(BorderLayout.CENTER, pOptions); // ok/cancel panel JOkCancelPanel okCancelPanel = new JOkCancelPanel(); okCancelPanel.addActionListener(this); getContentPane().add(BorderLayout.SOUTH, okCancelPanel); pack(); }
public void itemStateChanged(ItemEvent evt) { // only on 'selection' event if (evt.getStateChange() == ItemEvent.SELECTED) { clOptions.show(pOptions, types[cbType.getSelectedIndex()]); } }
public void actionPerformed(ActionEvent e) { String a, b, c, f, g, h, j, k, l, m, n, o, p, tol = ""; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:db2"); stm = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); } catch (Exception error) { System.out.println(error); } if (e.getSource() == student) { name = "Student"; cl.show(pnc, "cstu"); try { rs = stm.executeQuery("Select * from Student"); rs.next(); t1.setText(rs.getString(1)); t2.setText(rs.getString(2)); t3.setText(rs.getString(3)); t4.setText(rs.getString(4)); t5.setText(rs.getString(5)); t6.setText(rs.getString(6)); } catch (Exception error) { System.out.println(error); } } if (e.getSource() == teacher) { name = "Teacher"; cl.show(pnc, "ctea"); try { rs = stm.executeQuery("Select * from Teacher"); rs.next(); t11.setText(rs.getString(1)); t12.setText(rs.getString(2)); t13.setText(rs.getString(3)); t14.setText(rs.getString(4)); } catch (Exception error) { System.out.println(error); } } if (e.getSource() == course) { name = "Course"; cl.show(pnc, "ccou"); try { rs = stm.executeQuery("Select * from Course"); rs.next(); t7.setText(rs.getString(1)); t8.setText(rs.getString(2)); t9.setText(rs.getString(3)); t0.setText(rs.getString(4)); } catch (Exception error) { System.out.println(error); } } if (e.getSource() == result) { name = "Result"; cl.show(pnc, "cres"); try { rs = stm.executeQuery("Select * from Result"); rs.next(); t15.setText(rs.getString(1)); t16.setText(rs.getString(2)); t17.setText(rs.getString(3)); t18.setText(rs.getString(4)); t19.setText(rs.getString(5)); t20.setText(rs.getString(6)); t21.setText(rs.getString(7)); t22.setText(rs.getString(8)); t23.setText(rs.getString(9)); t24.setText(rs.getString(10)); t25.setText(rs.getString(11)); t26.setText(rs.getString(12)); t27.setText(rs.getString(13)); } catch (Exception error) { System.out.println(error); } } if (e.getSource() == b6) { Vector cols = new Vector(); Vector rows = new Vector(); if (z == 1) { String sql = "Select * from " + co; try { rs = stm.executeQuery(sql); meta = rs.getMetaData(); for (int i = 1; i <= meta.getColumnCount(); i++) cols.addElement(meta.getColumnName(i)); while (rs.next()) { Vector currow = new Vector(); for (int i = 1; i <= meta.getColumnCount(); i++) currow.addElement(rs.getString(i)); rows.addElement(currow); } } catch (Exception ex) { System.out.print(ex); } tb = new JTable(rows, cols); js = new JScrollPane(tb); pne2.remove(js); pne2.add(blk, "bb"); cl2.show(pne2, "bb"); pne2.add(js, "jjs"); cl2.show(pne2, "jjs"); pne2.remove(blk); z = 0; } } if (e.getSource() == b1) // **** ADD BUTTON ****// { if (name == "Student") { a = t1.getText(); b = t2.getText(); c = t3.getText(); f = t4.getText(); g = t5.getText(); h = t6.getText(); tol = "Insert into Student values ('" + a + "','" + b + "','" + c + "','" + f + "','" + g + "','" + h + "')"; } if (name == "Teacher") { a = t11.getText(); b = t12.getText(); c = t13.getText(); f = t14.getText(); tol = "Insert into Teacher values ('" + a + "','" + b + "','" + c + "','" + f + "')"; } if (name == "Course") { a = t7.getText(); b = t8.getText(); c = t9.getText(); f = t0.getText(); tol = "Insert into Course values ('" + a + "','" + b + "','" + c + "','" + f + "')"; } if (name == "Result") { a = t15.getText(); b = t16.getText(); c = t17.getText(); f = t18.getText(); g = t19.getText(); h = t20.getText(); j = t21.getText(); k = t22.getText(); l = t23.getText(); m = t24.getText(); n = t25.getText(); o = t26.getText(); p = t27.getText(); tol = "Insert into Result values ('" + a + "','" + b + "','" + c + "','" + f + "','" + g + "','" + h + "','" + j + "','" + k + "','" + l + "','" + m + "','" + n + "','" + o + "','" + p + "')"; } try { stm.executeUpdate(tol); } catch (Exception error) { System.out.println(error); } } if (e.getSource() == b2) // **** DELETE BUTTON ****// { if (name == "Student") { b = t2.getText(); tol = "Delete from Student where Id = '" + b + "'"; } if (name == "Teacher") { b = t12.getText(); tol = "Delete from Teacher where Id = '" + b + "'"; } if (name == "Course") { b = t8.getText(); tol = "Delete from Course where Id = '" + b + "'"; } if (name == "Result") { b = t16.getText(); tol = "Delete from Result where Code = '" + b + "'"; } try { stm.executeUpdate(tol); } catch (Exception error) { System.out.println(error); } } if (e.getSource() == b3) // **** UPDATE BUTTON ****// { if (name == "Student") { a = t1.getText(); b = t2.getText(); c = t3.getText(); f = t4.getText(); g = t5.getText(); h = t6.getText(); tol = "Update Student set Name = '" + a + "', ID = '" + b + "', Dept = '" + c + "', CGPA = '" + f + "', Address = '" + g + "', Cell = '" + h + "' where ID = '" + b + "'"; } if (name == "Teacher") { a = t11.getText(); b = t12.getText(); c = t13.getText(); f = t14.getText(); tol = "Update Teacher set Name = '" + a + "', ID = '" + b + "', Dept = '" + c + "', Course = '" + f + "' where ID = '" + b + "'"; } if (name == "Course") { a = t7.getText(); b = t8.getText(); c = t9.getText(); f = t0.getText(); tol = "Update Course set Name = '" + a + "', Code = '" + b + "', Credit = '" + c + "', Prerecusite = '" + f + "' where Code = '" + b + "'"; } if (name == "Result") { a = t15.getText(); b = t16.getText(); c = t17.getText(); f = t18.getText(); g = t19.getText(); h = t20.getText(); j = t21.getText(); k = t22.getText(); l = t23.getText(); m = t24.getText(); n = t25.getText(); o = t26.getText(); p = t27.getText(); tol = "Update Result set Course = '" + a + "', Code = '" + b + "', Credit = '" + c + "', A = '" + f + "', B+ = '" + g + "', B = '" + h + "', C+ = '" + j + "', C = '" + k + "', D+ = '" + l + "', D = '" + m + "', F = '" + n + "', I = '" + o + "', W = '" + p + "' where Code = '" + b + "'"; // JOptionPane.showMessageDialog(null,tol,null,JOptionPane.PLAIN_MESSAGE); // tol = "Update Result set Course = '"+a+"', Code = '"+b+"', Credit = '"+c+"' where Code = // '"+b+"'"; } try { stm.executeUpdate(tol); } catch (Exception error) { System.out.println(error); } } if (e.getSource() == b4) // **** NEXT BUTTON ****// { if (name == "Student") { try { if (rs.next()) { t1.setText(rs.getString(1)); t2.setText(rs.getString(2)); t3.setText(rs.getString(3)); t4.setText(rs.getString(4)); t5.setText(rs.getString(5)); t6.setText(rs.getString(6)); } } catch (Exception error) { System.out.println(error); } } if (name == "Teacher") { try { if (rs.next()) { t11.setText(rs.getString(1)); t12.setText(rs.getString(2)); t13.setText(rs.getString(3)); t14.setText(rs.getString(4)); } } catch (Exception error) { System.out.println(error); } } if (name == "Course") { try { if (rs.next()) { t7.setText(rs.getString(1)); t8.setText(rs.getString(2)); t9.setText(rs.getString(3)); t0.setText(rs.getString(4)); } } catch (Exception error) { System.out.println(error); } } if (name == "Result") { try { if (rs.next()) { t15.setText(rs.getString(1)); t16.setText(rs.getString(2)); t17.setText(rs.getString(3)); t18.setText(rs.getString(4)); t19.setText(rs.getString(5)); t20.setText(rs.getString(6)); t21.setText(rs.getString(7)); t22.setText(rs.getString(8)); t23.setText(rs.getString(9)); t24.setText(rs.getString(10)); t25.setText(rs.getString(11)); t26.setText(rs.getString(12)); t27.setText(rs.getString(13)); } } catch (Exception error) { System.out.println(error); } } } if (e.getSource() == b5) // **** PREVIOUS BUTTON ****// { if (name == "Student") { try { if (rs.previous()) { t1.setText(rs.getString(1)); t2.setText(rs.getString(2)); t3.setText(rs.getString(3)); t4.setText(rs.getString(4)); t5.setText(rs.getString(5)); t6.setText(rs.getString(6)); } } catch (Exception error) { System.out.println(error); } } if (name == "Teacher") { try { if (rs.previous()) { t11.setText(rs.getString(1)); t12.setText(rs.getString(2)); t13.setText(rs.getString(3)); t14.setText(rs.getString(4)); } } catch (Exception error) { System.out.println(error); } } if (name == "Course") { try { if (rs.previous()) { t7.setText(rs.getString(1)); t8.setText(rs.getString(2)); t9.setText(rs.getString(3)); t0.setText(rs.getString(4)); } } catch (Exception error) { System.out.println(error); } } if (name == "Result") { try { if (rs.previous()) { t15.setText(rs.getString(1)); t16.setText(rs.getString(2)); t17.setText(rs.getString(3)); t18.setText(rs.getString(4)); t19.setText(rs.getString(5)); t20.setText(rs.getString(6)); t21.setText(rs.getString(7)); t22.setText(rs.getString(8)); t23.setText(rs.getString(9)); t24.setText(rs.getString(10)); t25.setText(rs.getString(11)); t26.setText(rs.getString(12)); t27.setText(rs.getString(13)); } } catch (Exception error) { System.out.println(error); } } } }