관리 메뉴

moozi

9/10 haksa 본문

TIS_2018/응용sw2018_2기

9/10 haksa

moozi 2018. 9. 10. 17:45

import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swing.JTextField;

public class Haksa extends JFrame{
 JTextField idTxt=null;//학번
 JTextField nameTxt=null;//이름
 JTextField departmentTxt=null;//학과
 JTextField addressTxt=null;//주소
 JTextArea listTA=null;//목록
 
 JButton selectBtn=null;//목록버튼
 JButton insertBtn=null;//등록버튼
 JButton updateBtn=null;//수정버튼
 JButton deleteBtn=null;//삭제버튼

 public Haksa() {
  this.setTitle("학사관리시스템");
  this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  
  Container c=this.getContentPane();
  c.setLayout(new FlowLayout());
  
  c.add(new JLabel("학번"));
  idTxt=new JTextField(20);
  c.add(idTxt);
  
  c.add(new JLabel("이름"));
  nameTxt=new JTextField(20);
  c.add(nameTxt);
  
  c.add(new JLabel("학과"));
  departmentTxt=new JTextField(20);
  c.add(departmentTxt);
  
  c.add(new JLabel("주소"));
  addressTxt=new JTextField(20);
  c.add(addressTxt);
  
  listTA=new JTextArea(15,23);
  c.add(new JScrollPane(listTA));
  
  selectBtn=new JButton("목록");
  selectBtn.addActionListener(new ActionListener() {

   @Override
   public void actionPerformed(ActionEvent arg0) {
    try {
     Class.forName("com.mysql.jdbc.Driver");
     Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/sampledb?useSSL=false", "root", "1234");
     Statement stmt=conn.createStatement();
     ResultSet rs=stmt.executeQuery("select * from student");
     
     //목록초기화
     listTA.setText("");
     
     listTA.append("학번\t");
     listTA.append("이름\t");
     listTA.append("학과\n");
     listTA.append("===================================\n");
     while(rs.next()) {
      //System.out.print(rs.getString("id")+"\t");
      //System.out.print(rs.getString("name")+"\t");
      //System.out.print(rs.getString("dept")+"\n");
      
      listTA.append(rs.getString("id")+"\t");
      listTA.append(rs.getString("name")+"\t");
      listTA.append(rs.getString("dept")+"\n");
     }
     rs.close();
     conn.close();
    }catch(Exception e) {
     e.printStackTrace();
    }
    
   }});
  c.add(selectBtn);
  insertBtn=new JButton("등록");
  c.add(insertBtn);
  updateBtn=new JButton("수정");
  c.add(updateBtn);
  deleteBtn=new JButton("삭제");
  c.add(deleteBtn);
  
  this.setSize(300, 500);
  this.setVisible(true);
 }
 
 public static void main(String[] args) {
  new Haksa();

 }

}

'TIS_2018 > 응용sw2018_2기' 카테고리의 다른 글

자바연습문제18  (0) 2018.09.11
9/11 haksa  (0) 2018.09.11
9/10 mysql  (0) 2018.09.10
자바연습문제17  (0) 2018.09.10
my.ini  (0) 2018.09.10
Comments