관리 메뉴

moozi

4/13 haksa2 본문

TIS_2020/응용SW2020_1기

4/13 haksa2

moozi 2020. 4. 13. 14:02

import java.awt.Container;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;

public class Haksa extends JFrame{
static Connection  conn=null;
static Statement stmt=null;
static ResultSet rs=null;


JTextField tfId=null;
JTextField tfName=null;
JTextField tfDepartment=null;
JTextField tfAddress=null;
JTextArea taList=null;

JButton btnList=null;
JButton btnInsert=null;
JButton btnUpdate=null;
JButton btnDelete=null;

JButton btnSearch=null;

DefaultTableModel model;
JTable table;

public Haksa() {
this.setTitle("학사관리");
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);


//jdbc드라이버 로드
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:myoracle","ora_user","hong");// 연결

stmt=conn.createStatement();
} catch (Exception e2) {   
e2.printStackTrace();
}

//윈도우종료시 Connection Close
this.addWindowListener(new WindowAdapter() {
 public void windowClosing(WindowEvent e){
    try {
     if(conn!=null){
      conn.close();
     }
    } catch (SQLException e1) {      
     e1.printStackTrace();
    }
   }

});


Container c=this.getContentPane();
c.setLayout(new FlowLayout());

c.add(new JLabel("학번"));
this.tfId=new JTextField(14);
c.add(this.tfId);

this.btnSearch=new JButton("검색");
c.add(this.btnSearch);

c.add(new JLabel("이름"));
this.tfName=new JTextField(20);
c.add(this.tfName);

c.add(new JLabel("학과"));
this.tfDepartment=new JTextField(20);
c.add(this.tfDepartment);

c.add(new JLabel("주소"));
this.tfAddress=new JTextField(20);
c.add(this.tfAddress);


String colName[]={"학번","이름","학과"};
model=new DefaultTableModel(colName,0);
table = new JTable(model);
table.setPreferredScrollableViewportSize(new Dimension(250,200));
add(new JScrollPane(table));

//table에서 한행을 선택하면 편집할 수 있도록 TextField에 출력
table.addMouseListener(new MouseListener() {

@Override
public void mouseClicked(MouseEvent e) {
table=(JTable)e.getComponent();//클릭한 테이블 구하기
    model=(DefaultTableModel)table.getModel();//테이블의 모델 구하기
    String id=(String)model.getValueAt(table.getSelectedRow(), 0);
    tfId.setText(id);
    String name=(String)model.getValueAt(table.getSelectedRow(), 1);
    tfName.setText(name);
    String dept=(String)model.getValueAt(table.getSelectedRow(), 2);
    tfDepartment.setText(dept);
}

@Override
public void mouseEntered(MouseEvent e) {}

@Override
public void mouseExited(MouseEvent e) {}

@Override
public void mousePressed(MouseEvent e) {}

@Override
public void mouseReleased(MouseEvent e) {}
});



this.btnList=new JButton("목록");
this.btnInsert=new JButton("등록");
this.btnUpdate=new JButton("수정");
this.btnDelete=new JButton("삭제");


//학생검색
this.btnSearch.addActionListener(new ActionListener() {

@Override
public void actionPerformed(ActionEvent arg) {
try {

rs=stmt.executeQuery("select * from student where id='"+tfId.getText()+"'");

//JTable 초기화
model.setNumRows(0);

if(rs.next()) {

tfName.setText(rs.getString("name"));
tfDepartment.setText(rs.getString("dept"));

String[] row=new String[3];//컬럼의 갯수가 3
    row[0]=rs.getString("id");
    row[1]=rs.getString("name");
    row[2]=rs.getString("dept");
    model.addRow(row);
}

}catch(Exception e) {
e.printStackTrace();
}finally {
try {
if(rs!=null)
rs.close();

}catch(Exception e) {
e.printStackTrace();
}
}


}});

//학생목록
this.btnList.addActionListener(new ActionListener() {

@Override
public void actionPerformed(ActionEvent arg) {
list();
}});


//학생등록
this.btnInsert.addActionListener(new ActionListener() {

@Override
public void actionPerformed(ActionEvent arg) {
try {

stmt.executeUpdate("insert into student values('"+tfId.getText()+"','"+tfName.getText()+"','"+tfDepartment.getText()+"')");
System.out.println("insert into student values('"+tfId.getText()+"','"+tfName.getText()+"','"+tfDepartment.getText()+"')");

list();
//등록처리완료 메시지 출력
JOptionPane.showMessageDialog(null, "등록되었습니다");

}catch(Exception e) {
e.printStackTrace();
}

}});


//학생수정
this.btnUpdate.addActionListener(new ActionListener() {

@Override
public void actionPerformed(ActionEvent arg0) {
try {

stmt.executeUpdate("update student set name='"+tfName.getText()+"', dept='"+tfDepartment.getText()+"' where id='"+tfId.getText()+"'");
System.out.println("update student set name='"+tfName.getText()+"', dept='"+tfDepartment.getText()+"' where id='"+tfId.getText()+"'");

//목록출력. 메서드로 변환추천
rs=stmt.executeQuery("select * from student where id='"+tfId.getText()+"'");

//JTable 초기화
    model.setNumRows(0);     

while(rs.next()) {
String[] row=new String[3];//컬럼의 갯수가 3
    row[0]=rs.getString("id");
    row[1]=rs.getString("name");
    row[2]=rs.getString("dept");
    model.addRow(row);
}
rs.close();

//등록처리완료 메시지 출력
JOptionPane.showMessageDialog(null, "수정되었습니다");


}catch(Exception e) {
e.printStackTrace();
}

}});



this.btnDelete.addActionListener(new ActionListener() {

@Override
public void actionPerformed(ActionEvent arg) {
int result=JOptionPane.showConfirmDialog(null, "삭제하시겠습니까?", "삭제", JOptionPane.YES_NO_OPTION);
if(result==JOptionPane.YES_OPTION) {
//삭제처리. DB연동해서 삭제
try {
stmt.executeUpdate("delete from student where id='"+tfId.getText()+"'");
System.out.println("delete from student where id='"+tfId.getText()+"'");

list();

}catch(Exception e) {
e.printStackTrace();
}

//입력항목 초기화
tfId.setText("");
tfName.setText("");
tfDepartment.setText("");


//삭제처리완료 메시지 출력
JOptionPane.showMessageDialog(null, "삭제되었습니다");



}

}});


c.add(this.btnList);
c.add(this.btnInsert);
c.add(this.btnUpdate);
c.add(this.btnDelete);

this.setSize(295,500);
this.setResizable(false);
this.setVisible(true);
}



public void list(){
  try{
   System.out.println("연결되었습니다.....");
           
   // Select문 실행
   ResultSet rs=stmt.executeQuery("select * from student");
   
   //JTable 초기화
   model.setNumRows(0);
   
   while(rs.next()){
    String[] row=new String[3];//컬럼의 갯수가 3
    row[0]=rs.getString("id");
    row[1]=rs.getString("name");
    row[2]=rs.getString("dept");
    model.addRow(row);
   }
   rs.close();
   
  }catch(Exception e1){
   //e.getStackTrace();
   System.out.println(e1.getMessage());
 }
 }

public static void main(String[] args) {
new Haksa();

}

}

'TIS_2020 > 응용SW2020_1기' 카테고리의 다른 글

4/14 bookRent  (0) 2020.04.14
haksa table  (0) 2020.04.14
4/13 haksa2  (0) 2020.04.13
04/13 haksa  (0) 2020.04.13
java 그림판  (0) 2020.04.08
haksa  (0) 2020.03.30
0 Comments
댓글쓰기 폼