[JAVA JDBC, SWING, AWT]자바 AWT,스윙을 이용하여 오라클 EMP 테이블데이터 로딩 및 편집하기(JAVA
JDBC, AWT, SWING)
1. DBConnect.java
import java.sql.*;
public class DBConnect {
private Connection con;
private Statement stmt;
private String url = "jdbc:oracle:thin:@192.168.0.7:1521:onj";
private String ID = "scott";
private String PW = "tiger";
public DBConnect()
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver"); // JDBC Driver Loading
con = DriverManager.getConnection(url, ID, PW); // Connect 확득
stmt = con.createStatement(); //명령실행을 위한 Statement 획득
}
catch(Exception ex)
{
System.err.println(ex);
}
}
public Statement getStatement()
{
return stmt;
}
public Statement getStatement()
{
return stmt;
}
}
2. DBEdit.java
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import java.sql.*;
public class DBEdit extends JFrame {
private ResultSet rs=null;
private Statement stmt=null;
private ResultSet rs=null;
private Statement stmt=null;
private JButton[] btn = new JButton[5];
private JLabel[] label = new JLabel[8];
private JTextField[] text = new JTextField[8];
private JTable table;
private JScrollPane jp = new JScrollPane();
private JPanel p[] = new JPanel[4];
private JPanel p2 = new JPanel();
private String[][] data=new String[100][8];
private String[] col = {"empno ","ename ","job ","mgr ","hiredate",
"sal ","comm ","deptno "};
private String[] string = {"","","","","","","",""};
public DBEdit()
{
super("DBEdit");
/////////////
// DB에 연결
DBConnect connect = new DBConnect();
stmt = connect.getStatement();
// DB에 연결
DBConnect connect = new DBConnect();
stmt = connect.getStatement();
JPanel p1 = new JPanel();
p1.setLayout(new GridLayout(5,1));
JPanel p3 = new JPanel();
btn[0] = new JButton("선택");
btn[1] = new JButton("출력");
btn[2] = new JButton("입력");
btn[3] = new JButton("수정");
btn[4] = new JButton("삭제");
for( int i= 0 ; i < 5 ; i++)
{
btn[i].addActionListener(action);
p3.add(btn[i]);
}
for (int i = 0; i< 8; i++) {
label[i] = new JLabel(col[i]);
}
for (int i = 0; i< 8; i++) {
text[i] = new JTextField(15);
}
for ( int i = 0 ; i < 4 ; i++)
{
p[i] = new JPanel();
}
int j= -1;
for( int i = 0 ; i < 8 ; i++)
{
if( i%2==0)
{
j++;
}
p[j].add(label[i]);
p[j].add(text[i]);
}
p1.add(p3);
p1.add(p[0]);
p1.add(p[1]);
p1.add(p[2]);
p1.add(p[3]);
table = new JTable(data,col);
jp=new JScrollPane(table);
jp.addMouseListener(new MouseAdapter(){});
Container cp = this.getContentPane();
cp.setLayout(new GridLayout(2,1));
cp.add(p1);
cp.add(jp);
setDefaultCloseOperation(DISPOSE_ON_CLOSE);
setBounds(100,100,500,500);
setVisible(true);
showTable();
}
public void showTable()
{
table.removeAll();
try{
for(int i = 0 ; i <100 ; i++)
{
for(int j = 0 ; j < 8;j++)
{
data[i][j]="";
}
}
rs=stmt.executeQuery("select * from emp");
int i=0;
while(rs.next())
{
data[i][0]=rs.getString(1);
data[i][1]=rs.getString(2);
data[i][2]=rs.getString(3);
data[i][3]=rs.getString(4);
data[i][4]=rs.getString(5);
data[i][5]=rs.getString(6);
data[i][6]=rs.getString(7);
data[i++][7]=rs.getString(8);
}
table.repaint();
}
catch(Exception e)
{
System.err.println("보여 주기 에러");
}
}
ActionBtn action = new ActionBtn();
class ActionBtn extends Exception implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
if(e.getActionCommand().equals("출력"))
{
showTable();
}
else if(e.getActionCommand().equals("선택"))
{
int row=table.getSelectedRow();
/////////////////////
// 텍스트 필드에 받아온 데이터 보여주기
for( int i= 0 ; i < 8 ;i++)
{
text[i].setText(data[row][i]);
}
}
else if(e.getActionCommand().equals("입력"))
{
try{
for(int i = 0 ; i < 8; i++)
{
if( text[i].getText().equals(""))
{
if( i==0 || i==3||i==5||i==6||i==7)
string[i]="\'\'";
else
string[i]="";
}
else
string[i]=text[i].getText();
}
stmt.executeQuery(
"insert into emp values(" + string[0]+ ",'" +
string[1]+ "' ,'" +string[2]+ "'," +string[3]+ ",'" +
string[4]+ "'," +string[5]+ "," +string[6]+ "," +
string[7]+ ")");
stmt.executeQuery("commit");
}
catch(Exception ex)
{
System.err.println("입력 에러");
}
////////////////////
//화면에 출력하기
showTable();
for( int i = 0 ; i < 8 ; i++)
{
text[i].setText("");
}
}
else if(e.getActionCommand().equals("수정"))
{
try{
stmt.executeQuery(
"update emp set" + " empno = " +text[0].getText()+ " ,ename='" +
text[1].getText()+ "',job='" +text[2].getText()+ "',mgr=" +text[3].getText()+ ",hiredate='" +
text[4].getText()+ "',sal=" +text[5].getText()+ ",comm=" +text[6].getText()+ ",deptno =" +
text[7].getText()+"where empno = "+text[0].getText());
stmt.executeQuery("commit");
}
catch(Exception ex)
{
System.err.println("수정 에러");
}
////////////////////
//화면에 출력하기
showTable();
for( int i = 0 ; i < 8 ; i++)
{
text[i].setText("");
}
}
else if(e.getActionCommand().equals("삭제"))
{
try{
System.out.println (text[0].getText());
stmt.executeQuery("delete from emp where" + " empno = " +text[0].getText());
stmt.executeQuery("commit");
}
catch(Exception ex)
{
System.err.println("삭제 에러");
}
////////////////////
//화면에 출력하기
showTable();
for( int i = 0 ; i < 8 ; i++)
{
text[i].setText("");
}
}
}
}
public static void main(String[] args) {
DBEdit db = new DBEdit();
}
}
<결과그림 SWING,JDBC예제>
