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();
}
}
