* 간단한 성적 관리 : 이름, 국어, 영어, 수학을 입력받아서 총점과 평균을 같이 테이블에 저장, 수정, 삭제 가능한 관리프로그램
Grade.zip
- score.sql
create table score ( name varchar2(20) constraint score_name_pk PRIMARY KEY , kor number(3) constraint score_kor_nn not null, eng number(3) constraint score_eng_nn not null, mat number(3) constraint score_mat_nn not null, tot number(3) constraint score_to_nn not null, ave number(3) constraint score_ave_nn not null )
- Score.java
// Score.java
import java.awt.Dimension;
import java.awt.Font;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseListener;
import java.util.Vector;
import javax.swing.BorderFactory;
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.JTextField;
import javax.swing.ListSelectionModel;
import javax.swing.table.DefaultTableCellRenderer;
import javax.swing.table.DefaultTableModel;
class ScoreFrame extends JFrame implements ActionListener, MouseListener {
ScoreDAO scoreDAO;
ScoreDTO scoreDTO;
JLabel jlName, jlKor, jlEng, jlMat;
JTextField jtName, jtKor, jtEng, jtMat;
JButton jbAdd, jbDel, jbChange;
JTable table;
Vector data, col;
ScoreFrame() {
setLayout(null);
scoreDAO = new ScoreDAO();
// 이름
add(jlName = new JLabel("이름", JLabel.CENTER));
jlName.setFont(new Font("맑은 고딕", Font.BOLD, 20));
jlName.setBorder(BorderFactory.createBevelBorder(0));
jlName.setBounds(10, 10, 120, 50);
add(jtName = new JTextField());
jtName.setFont(new Font("맑은 고딕", Font.BOLD, 20));
jtName.setHorizontalAlignment(JTextField.CENTER);
jtName.setBounds(140, 10, 120, 50);
// 국어
add(jlKor = new JLabel("국어 점수", JLabel.CENTER));
jlKor.setFont(new Font("맑은 고딕", Font.BOLD, 20));
jlKor.setBorder(BorderFactory.createBevelBorder(0));
jlKor.setBounds(10, 70, 120, 50);
add(jtKor = new JTextField());
jtKor.setFont(new Font("맑은 고딕", Font.BOLD, 20));
jtKor.setHorizontalAlignment(JTextField.CENTER);
jtKor.setBounds(140, 70, 120, 50);
// 영어
add(jlEng = new JLabel("영어 점수", JLabel.CENTER));
jlEng.setFont(new Font("맑은 고딕", Font.BOLD, 20));
jlEng.setBorder(BorderFactory.createBevelBorder(0));
jlEng.setBounds(10, 130, 120, 50);
add(jtEng = new JTextField());
jtEng.setFont(new Font("맑은 고딕", Font.BOLD, 20));
jtEng.setHorizontalAlignment(JTextField.CENTER);
jtEng.setBounds(140, 130, 120, 50);
// 수학
add(jlMat = new JLabel("수학 점수", JLabel.CENTER));
jlMat.setFont(new Font("맑은 고딕", Font.BOLD, 20));
jlMat.setBorder(BorderFactory.createBevelBorder(0));
jlMat.setBounds(10, 190, 120, 50);
add(jtMat = new JTextField());
jtMat.setFont(new Font("맑은 고딕", Font.BOLD, 20));
jtMat.setHorizontalAlignment(JTextField.CENTER);
jtMat.setBounds(140, 190, 120, 50);
// 버튼
add(jbAdd = new JButton("추가"));
jbAdd.setFont(new Font("맑은 고딕", Font.BOLD, 20));
jbAdd.setBounds(270, 10, 120, 50);
jbAdd.addActionListener(this);
add(jbDel = new JButton("제거"));
jbDel.setFont(new Font("맑은 고딕", Font.BOLD, 20));
jbDel.setBounds(270, 70, 120, 50);
jbDel.addActionListener(this);
add(jbChange = new JButton("수정"));
jbChange.setFont(new Font("맑은 고딕", Font.BOLD, 20));
jbChange.setBounds(270, 130, 120, 50);
jbChange.addActionListener(this);
// 컬럼 백터
col = new Vector();
col.add("이름");
col.add("국어 점수");
col.add("영어 점수");
col.add("수학 점수");
col.add("총점");
col.add("평균");
// 테이블 수정 못하게 DefaultTableModel 사용
DefaultTableModel model = new DefaultTableModel(scoreDAO.getScore(), col) {
public boolean isCellEditable(int row, int column) {
return false;
}
};
/* 디폴트테이블을 테이블에 더해서 스크롤패널에 더한다 */
table = new JTable(model);
table.addMouseListener(this);
JScrollPane scroll = new JScrollPane(table);
jTableSet();
add(scroll);
scroll.setBounds(415, 10, 770, 250);
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
setLocation((screenSize.width - 1200) / 2, (screenSize.height - 300) / 2);
setResizable(false);
setSize(1200, 300);
setTitle("성적 관리프로그램");
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setVisible(true);
} // ScoreFrame 생성자
@Override
public void actionPerformed(ActionEvent e) {
String ButtonFlag = e.getActionCommand();
if (ButtonFlag.equals("추가")) {
try {
contentSet();
int result = scoreDAO.insertScore(scoreDTO);
if (result == 1) {
JOptionPane.showMessageDialog(this, "추가 되었습니다.");
jTableRefresh();
contentClear();
} // inner if
} catch (Exception e2) {
JOptionPane.showMessageDialog(this, "이름을 입력하세요!");
e2.printStackTrace();
return;
} // try - catch
} else if (ButtonFlag.equals("제거")) {
try {
contentSet();
int result = scoreDAO.deleteScore(scoreDTO);
if (result == 1) {
JOptionPane.showMessageDialog(this, "제거 되었습니다.");
jTableRefresh();
contentClear();
} // inner if
} catch (Exception e2) {
JOptionPane.showMessageDialog(this, "이름을 입력하세요!");
e2.printStackTrace();
} // try - catch
} else if (ButtonFlag.equals("수정")) {
try {
contentSet();
int result = scoreDAO.updateScore(scoreDTO);
if (result == 1) {
JOptionPane.showMessageDialog(this, "수정 되었습니다.");
jTableRefresh();
contentClear();
jtName.setFocusable(true);
} // inner if
} catch (Exception e2) {
JOptionPane.showMessageDialog(this, "이름을 입력하세요!");
e2.printStackTrace();
} // try - catch
} // if
} // actionPerformed
@Override
public void mouseClicked(MouseEvent e) {
int rowIndex = table.getSelectedRow();
jtName.setText(table.getValueAt(rowIndex, 0) + "");
jtKor.setText(table.getValueAt(rowIndex, 1) + "");
jtEng.setText(table.getValueAt(rowIndex, 2) + "");
jtMat.setText(table.getValueAt(rowIndex, 3) + "");
} // mouseClicked
@Override
public void mousePressed(MouseEvent e) {
} // mousePressed
@Override
public void mouseReleased(MouseEvent e) {
} // mouseReleased
@Override
public void mouseEntered(MouseEvent e) {
} // mouseEntered
@Override
public void mouseExited(MouseEvent e) {
} // mouseExited
public void jTableRefresh() {
// 테이블 수정 못하게 DefaultTableModel 사용
DefaultTableModel model = new DefaultTableModel(scoreDAO.getScore(), col) {
public boolean isCellEditable(int row, int column) {
return false;
}
};
table.setModel(model);
jTableSet();
} // jTableRefresh : 테이블 내용을 갱신하는 메서드
public void jTableSet() {
// 이동과 길이조절 여러개 선택 되는 것을 방지한다
table.getTableHeader().setReorderingAllowed(false);
table.getTableHeader().setResizingAllowed(false);
table.setSelectionMode(ListSelectionModel.SINGLE_INTERVAL_SELECTION);
// 컬럼 정렬에 필요한 메서드
DefaultTableCellRenderer celAlignCenter = new DefaultTableCellRenderer();
celAlignCenter.setHorizontalAlignment(JLabel.CENTER);
DefaultTableCellRenderer celAlignRight = new DefaultTableCellRenderer();
celAlignRight.setHorizontalAlignment(JLabel.RIGHT);
DefaultTableCellRenderer celAlignLeft = new DefaultTableCellRenderer();
celAlignLeft.setHorizontalAlignment(JLabel.LEFT);
// 컬럼별 사이즈 조절 & 정렬
table.getColumnModel().getColumn(0).setPreferredWidth(10);
table.getColumnModel().getColumn(0).setCellRenderer(celAlignCenter);
table.getColumnModel().getColumn(1).setPreferredWidth(10);
table.getColumnModel().getColumn(1).setCellRenderer(celAlignCenter);
table.getColumnModel().getColumn(2).setPreferredWidth(10);
table.getColumnModel().getColumn(2).setCellRenderer(celAlignCenter);
table.getColumnModel().getColumn(3).setPreferredWidth(10);
table.getColumnModel().getColumn(3).setCellRenderer(celAlignCenter);
table.getColumnModel().getColumn(4).setPreferredWidth(20);
table.getColumnModel().getColumn(4).setCellRenderer(celAlignCenter);
table.getColumnModel().getColumn(5).setPreferredWidth(20);
table.getColumnModel().getColumn(5).setCellRenderer(celAlignCenter);
} // jTableRefresh : 테이블 옵션 설정하는 메서드
public void contentSet() {
scoreDTO = new ScoreDTO();
String name = jtName.getText();
if (name.equals("") || name.equals(null)) JOptionPane.showMessageDialog(this, "이름을 입력하세요!");
int kor, eng, mat, tot, ave;
if (jtKor.getText().equals("") || jtKor.getText().equals(null)) {
kor = 0;
} else {
kor = Integer.parseInt(jtKor.getText());
} // if
if (jtEng.getText().equals("") || jtEng.getText().equals(null)) {
eng = 0;
} else {
eng = Integer.parseInt(jtEng.getText());
} // if
if (jtMat.getText().equals("") || jtMat.getText().equals(null)) {
mat = 0;
} else {
mat = Integer.parseInt(jtMat.getText());
} // if
tot = kor + eng + mat;
ave = tot / 3;
scoreDTO.setName(name);
scoreDTO.setKor(kor);
scoreDTO.setEng(eng);
scoreDTO.setMat(mat);
scoreDTO.setTot(tot);
scoreDTO.setAve(ave);
} // content : 텍스트 필드에 입력된 내용을 셋하는 메서드
public void contentClear() {
jtName.setText("");
jtKor.setText("");
jtEng.setText("");
jtMat.setText("");
} // contentClear : 텍스트 필드에 입력된 내용을 지우는 메서드
} // ScoreFrame
public class Score {
public static void main(String[] args) {
new ScoreFrame();
} // main
} // Score
- ScoreDAO.java
// ScoreDAO.java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;
public class ScoreDAO {
private static final String DRIVER = "oracle.jdbc.driver.OracleDriver";
private static final String URL = "jdbc:oracle:thin:@203.236.209.170:1521:XE";
private static final String USER = "scott";
private static final String PASS = "tiger";
public Connection getConn() {
Connection con = null;
try {
Class.forName(DRIVER);
con = DriverManager.getConnection(URL, USER, PASS);
} catch (Exception e) {
e.printStackTrace();
} // try - catch
return con;
} // getConn : 연결 메소드 작성
public int insertScore(ScoreDTO dto) {
Connection con = null;
PreparedStatement ps = null;
int result = 0;
try {
con = getConn();
String sql = "insert into score values(?,?,?,?,?,?)";
ps = con.prepareStatement(sql);
ps.setString(1, dto.getName());
ps.setInt(2, dto.getKor());
ps.setInt(3, dto.getEng());
ps.setInt(4, dto.getMat());
ps.setInt(5, dto.getTot());
ps.setInt(6, dto.getAve());
result = ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
if (ps != null) { try { ps.close(); } catch (SQLException e2) { e2.printStackTrace(); } // ps try - catch
} // ps if
if (con != null) { try { con.close(); } catch (SQLException e2) { e2.printStackTrace(); } // con try - catch
} // con if
} // try - catch - finally
return result;
} // insertMember : 회원 정보를 저장하는 메소드, 성공 여부를 int형 result 를 반환한다.
public Vector getScore() {
Vector data = new Vector();
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
con = getConn();
String sql = "select * from score order by name asc";
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
while (rs.next()) {
String name = rs.getString("name");
int kor = rs.getInt("kor");
int eng = rs.getInt("eng");
int mat = rs.getInt("mat");
int tot = rs.getInt("tot");
int ave = rs.getInt("ave");
Vector row = new Vector();
row.add(name);
row.add(kor);
row.add(eng);
row.add(mat);
row.add(tot);
row.add(ave);
data.add(row);
} // while
} catch (Exception e) {
e.printStackTrace();
} finally {
if (rs != null) { try { rs.close(); } catch (SQLException e2) { e2.printStackTrace(); } // rs try - catch
} // rs if
if (stmt != null) { try { stmt.close(); } catch (SQLException e2) { e2.printStackTrace(); } // ps try - catch
} // stmt if
if (con != null) { try { con.close(); } catch (SQLException e2) { e2.printStackTrace(); } // con try - catch
} // con if
} // try - catch - finally
return data;
} // getScore : 리스트를 가져오는 메서드, 조회해온 데이터를 Vector형 data를 반환한다.
public int updateScore(ScoreDTO dto) {
Connection con = null;
PreparedStatement ps = null;
int result = 0;
try {
con = getConn();
String sql = "update score set kor=?, eng=?, mat=?, tot=?, ave=? where name=?";
ps = con.prepareStatement(sql);
ps.setInt(1, dto.getKor());
ps.setInt(2, dto.getEng());
ps.setInt(3, dto.getMat());
ps.setInt(4, dto.getTot());
ps.setInt(5, dto.getAve());
ps.setString(6, dto.getName());
result = ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
if (ps != null) { try { ps.close(); } catch (SQLException e2) { e2.printStackTrace(); } // ps try - catch
} // ps if
if (con != null) { try { con.close(); } catch (SQLException e2) { e2.printStackTrace(); } // con try - catch
} // con if
} // try - catch - finally
return result;
} // updateScore : 한 레코드를 수정하는 메서드, 성공 여부를 int형 result 를 반환한다.
public int deleteScore(ScoreDTO dto) {
Connection con = null;
PreparedStatement ps = null;
int result = 0;
try {
con = getConn();
String sql = "delete score where name=?";
ps = con.prepareStatement(sql);
ps.setString(1, dto.getName());
result = ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
if (ps != null) { try { ps.close(); } catch (SQLException e2) { e2.printStackTrace(); } // ps try - catch
} // ps if
if (con != null) { try { con.close(); } catch (SQLException e2) { e2.printStackTrace(); } // con try - catch
} // con if
} // try - catch - finally
return result;
} // deleteScore : 한 레코드를 삭제하는 메서드, 성공 여부를 int형 result 를 반환한다.
} // ScoreDAO : Databse 처리
- ScoreDTO.java
// ScoreDTO.java
public class ScoreDTO {
private String name;
private int kor, eng, mat, tot, ave;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getKor() {
return kor;
}
public void setKor(int kor) {
this.kor = kor;
}
public int getEng() {
return eng;
}
public void setEng(int eng) {
this.eng = eng;
}
public int getMat() {
return mat;
}
public void setMat(int mat) {
this.mat = mat;
}
public int getTot() {
return tot;
}
public void setTot(int tot) {
this.tot = tot;
}
public int getAve() {
return ave;
}
public void setAve(int ave) {
this.ave = ave;
}
@Override
public String toString() {
return "ScoreDTO [name=" + name + ", kor=" + kor + ", eng=" + eng
+ ", mat=" + mat + ", tot=" + tot + ", ave=" + ave + "]";
}
} // ScoreDTO : Getter Setter & toString
'Java > Java SE' 카테고리의 다른 글
| Java 네트워킹(Networking) (0) | 2013.08.30 |
|---|---|
| Java 쌍따움표 안에 쌍따움표 처리 (0) | 2013.08.29 |
| Java 이클립스(Eclipse) JDBC 오라클(ORACLE) 개발 환경 설정 (2) | 2013.08.23 |
| Java 입출력(I/O) (0) | 2013.08.20 |
| Java 쓰레드(Thread) (0) | 2013.08.19 |