자바 – 페이지 3 – Lecture Note

스윙 콤포넌트 추가 방법 2 : JTable

참조 : 스윙 콤포넌트 추가 방법 1(기본 콤포넌트 추가 과정 설명) JFrame을 상속받아 MainUI 클래스 만들기

public class MainUI extends JFrame{
	public MainUI(){
		this.setTitle("201712345 홍길동");
		this.setSize(800, 600);
		this.setLayout(null);
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		// 콤포넌트 추가는 이곳에

		this.setVisible(true);
	}

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

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

public class MainUI extends JFrame{

public MainUI(){

this.setTitle("201712345 홍길동");

this.setSize(800, 600);

this.setLayout(null);

this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

// 콤포넌트 추가는 이곳에

this.setVisible(true);

}

public static void main(String[] args) {

new MainUI();

}

콤보넌트 예제 : 그림의 오른쪽 부분은 위 참조 사이트에 설명되어 있음 JTable 콤포넌트 추가

public class MainUI extends JFrame{
	JTable table;
	DefaultTableModel model;
	public MainUI(){
		this.setTitle("201712345 홍길동");
		this.setSize(800, 600);
		this.setLayout(null);
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		Vector<Object> vecs = null;
		Vector<Object> cols = null;
		model = new DefaultTableModel(vecs, cols); // model.setDataVector(vecs, cols);
		table = new JTable(model);

		JScrollPane scroll = new JScrollPane(table);
		scroll.setBounds(10, 10, 300, 480);
		table.setBackground(Color.green);
		//table.addMouseListener(this); // 리스너 등록
		this.add(scroll);

		this.setVisible(true);
	}

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

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

public class MainUI extends JFrame{

JTable table;

DefaultTableModel model;

public MainUI(){

this.setTitle("201712345 홍길동");

this.setSize(800, 600);

this.setLayout(null);

this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

Vector<Object> vecs = null;

Vector<Object> cols = null;

model = new DefaultTableModel(vecs, cols); // model.setDataVector(vecs, cols);

table = new JTable(model);

JScrollPane scroll = new JScrollPane(table);

scroll.setBounds(10, 10, 300, 480);

table.setBackground(Color.green);

//table.addMouseListener(this); // 리스너 등록

this.add(scroll);

this.setVisible(true);

}

public static void main(String[] args) {

new MainUI();

}

getTableHeader() 멤버 메서드 생성

public Vector<Object> getTableHeader() {
	Vector<Object> col = new Vector<Object>();
	col.add("아이디");
	col.add("이름");
	col.add("전화");
	col.add("학과");
	col.add("성별");
	col.add("이메일");

	return col;
}

1

2

3

4

5

6

7

8

9

10

11

public Vector<Object> getTableHeader() {

Vector<Object> col = new Vector<Object>();

col.add("아이디");

col.add("이름");

col.add("전화");

col.add("학과");

col.add("성별");

col.add("이메일");

return col;

}

getListVector() 멤버 메서드 생성

public Vector<Object> getListVector() {
	Vector<Object> data = new Vector<Object>();

	for(int i=0; i<3; i++) {
		Vector<String> row = new Vector<String>();

		row.add("아이디" + i);
		row.add("이름" + i);
		row.add("전화" + i);
		row.add("학과" + i);
		row.add("성별" + i);
		row.add("이메일" + i);

		data.add(row);
	}
	return data;
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

public Vector<Object> getListVector() {

Vector<Object> data = new Vector<Object>();

for(int i=0; i<3; i++) {

Vector<String> row = new Vector<String>();

row.add("아이디" + i);

row.add("이름" + i);

row.add("전화" + i);

row.add("학과" + i);

row.add("성별" + i);

row.add("이메일" + i);

data.add(row);

}

return data;

}

소스 수정

Vector<Object> vecs = getListVector();
Vector<Object> cols = getTableHeader();

1 2	Vector<Object> vecs = getListVector(); Vector<Object> cols = getTableHeader();

getListVector() 멤버 메서드 수정(DAO 클래스로… Continue Reading 스윙 콤포넌트 추가 방법 2 : JTable

급여계산 ReportB

프로젝트, 패키지, 클래스 생성

package kr.ac.jj.report;

import java.util.Scanner;

public class ReportB201812345 {

	public static void main(String[] args) {
		// TODO Auto-generated method stub

		OfficerB201812345 p = new OfficerB201812345();
		...

		OfficerB201812345 q = new OfficerB201812345("10002", "길동이", "대리", 7);

		OfficerB201812345.PrintHead();
		p.Print();
		q.Print();
	}
}

class OfficerB201812345{
	public void Calc() {
	}

	public void Print() {
	}

	public static void PrintHead() {
	}

}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

package kr.ac.jj.report;

import java.util.Scanner;

public class ReportB201812345 {

public static void main(String[] args) {

// TODO Auto-generated method stub

OfficerB201812345 p = new OfficerB201812345();

...

OfficerB201812345 q = new OfficerB201812345("10002", "길동이", "대리", 7);

OfficerB201812345.PrintHead();

p.Print();

q.Print();

}

class OfficerB201812345{

public void Calc() {

}

public void Print() {

}

public static void PrintHead() {

}

프로젝트 이름 : Report – 틀리면 5점 감점 패키지 이름 : kr.ac.jj.report – 틀리면 5점 감점 클래스 이름 ReportB201812345 (본인학번) – 틀리면 5점 감점 OfficerB201812345 (본인학번) – 틀리면 5점 감점 입력 : 위 소스 코드의 … 부분에 입력 코드 추가(아래 그림을 참조) 번호, 이름, 직위(부장,과장,대리,사원),… Continue Reading 급여계산 ReportB

자바 ComboBox 리스너(Listener) 사용

ComboBox는 ItemListener 사용하면 됨

public class S199_PhoneUI extends JFrame{
	JTextField tfName;
	JComboBox<String> cmbPhone;
	JTextField tfPhone2;
	JTextField tfPhone3;
	JTextField tfPhone;

	public S199_PhoneUI() {
		this.setSize(600, 400);
		this.setLayout(null);

		JLabel lblName = new JLabel("이름");
		lblName.setBounds(10, 10, 100, 25);
		this.add(lblName);

		tfName = new JTextField();
		tfName.setBounds(120, 10, 100, 25);
		this.add(tfName);

		JLabel lblPhone = new JLabel("전화");
		lblPhone.setBounds(10, 40, 100, 25);
		this.add(lblPhone);

		String[] hp = new String[] { "010", "011", "016", "017", "018", "019" };
		cmbPhone = new JComboBox<String>(hp);
		cmbPhone.setBounds(120, 40, 50, 25);
		cmbPhone.addItemListener(new ItemListener() {

			@Override
			public void itemStateChanged(ItemEvent e) {
				// TODO Auto-generated method stub
				if(e.getStateChange() == ItemEvent.SELECTED) {
					tfPhone.setText(cmbPhone.getSelectedItem().toString()
							+ "-" + tfPhone2.getText()
							+ "-" + tfPhone2.getText()
							);

				}

			}
		});
		this.add(cmbPhone);

		tfPhone2 = new JTextField();
		tfPhone2.setBounds(180, 40, 50, 25);
		this.add(tfPhone2);

		tfPhone3 = new JTextField();
		tfPhone3.setBounds(240, 40, 50, 25);
		this.add(tfPhone3);

		tfPhone = new JTextField();
		tfPhone.setBounds(300, 40, 100, 25);
		this.add(tfPhone);

		JButton btnSave = new JButton("저장");
		btnSave.setBounds(10, 300, 100, 25);
		this.add(btnSave);


		this.setVisible(true);
	}

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		new S199_PhoneUI();
	}
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

public class S199_PhoneUI extends JFrame{

JTextField tfName;

JComboBox<String> cmbPhone;

JTextField tfPhone2;

JTextField tfPhone3;

JTextField tfPhone;

public S199_PhoneUI() {

this.setSize(600, 400);

this.setLayout(null);

JLabel lblName = new JLabel("이름");

lblName.setBounds(10, 10, 100, 25);

this.add(lblName);

tfName = new JTextField();

tfName.setBounds(120, 10, 100, 25);

this.add(tfName);

JLabel lblPhone = new JLabel("전화");

lblPhone.setBounds(10, 40, 100, 25);

this.add(lblPhone);

String[] hp = new String[] { "010", "011", "016", "017", "018", "019" };

cmbPhone = new JComboBox<String>(hp);

cmbPhone.setBounds(120, 40, 50, 25);

cmbPhone.addItemListener(new ItemListener() {

@Override

public void itemStateChanged(ItemEvent e) {

// TODO Auto-generated method stub

if(e.getStateChange() == ItemEvent.SELECTED) {

tfPhone.setText(cmbPhone.getSelectedItem().toString()

+ "-" + tfPhone2.getText()

);

}

});

this.add(cmbPhone);

tfPhone2 = new JTextField();

tfPhone2.setBounds(180, 40, 50, 25);

this.add(tfPhone2);

tfPhone3 = new JTextField();

tfPhone3.setBounds(240, 40, 50, 25);

this.add(tfPhone3);

tfPhone = new JTextField();

tfPhone.setBounds(300, 40, 100, 25);

this.add(tfPhone);

JButton btnSave = new JButton("저장");

btnSave.setBounds(10, 300, 100, 25);

this.add(btnSave);

this.setVisible(true);

}

public static void main(String[] args) {

// TODO Auto-generated method stub

new S199_PhoneUI();

}

11번째 프로그램(성적처리) — DB 사용하기

DB Browser for Sqlite를 이용하여 D:\sungjuk.db 파일생성 highstudent 테이블 생성 S011_Sungjuk_Insert.java : Sqlite DB에 성적 저장

package kr.ac.jj.java201812345;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Scanner;

public class S011_Sungjuk_Insert {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		Scanner scan = new Scanner(System.in);

		String name = scan.nextLine();
		int kor = scan.nextInt();
		int eng = scan.nextInt();
		int mat = scan.nextInt();

		String DBFileName = "D:\\hongildong.db";

		String sql = "INSERT INTO highstudent(name, kor, eng, mat) ";
		sql += " VALUES(?, ?, ?, ?)";

		Connection conn = null;

		try {
			Class.forName("org.sqlite.JDBC");
			conn = DriverManager.getConnection("jdbc:sqlite:" + DBFileName);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		PreparedStatement ps = null;
		try {
			ps = conn.prepareStatement(sql);
			ps.setString(1, name);
			ps.setInt(2, kor);
			ps.setInt(3, eng);
			ps.setInt(4, mat);
			int r = ps.executeUpdate();

			if(r > 0) System.out.println("성공");
			else System.out.println("실패");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

package kr.ac.jj.java201812345;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import java.util.Scanner;

public class S011_Sungjuk_Insert {

public static void main(String[] args) {

// TODO Auto-generated method stub

Scanner scan = new Scanner(System.in);

String name = scan.nextLine();

int kor = scan.nextInt();

int eng = scan.nextInt();

int mat = scan.nextInt();

String DBFileName = "D:\\hongildong.db";

String sql = "INSERT INTO highstudent(name, kor, eng, mat) ";

sql += " VALUES(?, ?, ?, ?)";

Connection conn = null;

try {

Class.forName("org.sqlite.JDBC");

conn = DriverManager.getConnection("jdbc:sqlite:" + DBFileName);

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

PreparedStatement ps = null;

try {

ps = conn.prepareStatement(sql);

ps.setString(1, name);

ps.setInt(2, kor);

ps.setInt(3, eng);

ps.setInt(4, mat);

int r = ps.executeUpdate();

if(r > 0) System.out.println("성공");

else System.out.println("실패");

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

S011_Sungjuk_Select.java : Sqlite DB에 저장된 성적을 읽어와 출력

package kr.ac.jj.java201812345;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;

public class S011_Sungjuk_Select {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		String DBFileName = "D:\\hongildong.db";

		String sql = "SELECT * FROM highstudent ";

		Connection conn = null;

		try {
			Class.forName("org.sqlite.JDBC");
			conn = DriverManager.getConnection("jdbc:sqlite:" + DBFileName);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();

			HighStudent.PrintHead();
			while(rs.next()) {
				String name = rs.getString("name");
				int kor = rs.getInt("kor");
				int eng = rs.getInt("eng");
				int mat = rs.getInt("mat");
				HighStudent hs = new HighStudent(name, kor, eng, mat);
				hs.PrintNew();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

package kr.ac.jj.java201812345;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Scanner;

public class S011_Sungjuk_Select {

public static void main(String[] args) {

// TODO Auto-generated method stub

String DBFileName = "D:\\hongildong.db";

String sql = "SELECT * FROM highstudent ";

Connection conn = null;

try {

Class.forName("org.sqlite.JDBC");

conn = DriverManager.getConnection("jdbc:sqlite:" + DBFileName);

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

PreparedStatement ps = null;

ResultSet rs = null;

try {

ps = conn.prepareStatement(sql);

rs = ps.executeQuery();

HighStudent.PrintHead();

while(rs.next()) {

String name = rs.getString("name");

int kor = rs.getInt("kor");

int eng = rs.getInt("eng");

int mat = rs.getInt("mat");

HighStudent hs = new HighStudent(name, kor, eng, mat);

hs.PrintNew();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

10번째 프로그램(성적처리) – 상속

HighStudentChild.java : HighStudent 클래스를 상속받아 사용 (실행 오류 있음, 찾아서 고쳐보세요)

package kr.ac.jj.java201812345;

import java.util.Scanner;

public class HighStudentChild extends HighStudent{
	public int sci;

	public HighStudentChild() {

	}

	public HighStudentChild(int kor, int eng, int mat, int sci) {
		super(kor, eng, mat);
		this.sci = sci;
	}

	public HighStudentChild(String name, int kor, int eng, int mat, int sci) {
		super(name, kor, eng, mat);
		this.sci = sci;
	}

	public void Calc() {
		this.tot = kor + eng + mat + sci;
		this.ave = this.tot / 4.0;

		if(this.ave >= 90) {
			this.grade = "수";
		}
		else if(this.ave >= 80) {
			this.grade = "우";
		}
		else if(this.ave >= 70) {
			this.grade = "미";
		}
		else if(this.ave >= 60) {
			this.grade = "양";
		}
		else{
			this.grade = "가";
		}
	}

	public void Input() {
		Scanner scan = new Scanner(System.in);

		System.out.print("이름 : ");
		this.name = scan.nextLine();
		System.out.print("국어 : ");
		this.kor = scan.nextInt();
		System.out.print("영어 : ");
		this.eng = scan.nextInt();
		System.out.print("수학 : ");
		this.mat = scan.nextInt();
		System.out.print("과학 : ");
		this.sci = scan.nextInt();

		this.Calc();
	}

	public void Print() {
		System.out.println(
				"이름 : " + this.name
				+ "\t국어 : " + this.kor
				+ "\t영어 : " + this.eng
				+ "\t수학 : " + this.mat
				+ "\t과학 : " + this.sci
				+ "\t총점 : " + this.tot
				//+ "\t평균 : " + this.ave
				+ "\t평균 : " + String.format("%6.2f", this.ave)
				+ "\t등급 : " + this.grade
				);
	}
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

package kr.ac.jj.java201812345;

import java.util.Scanner;

public class HighStudentChild extends HighStudent{

public int sci;

public HighStudentChild() {

}

public HighStudentChild(int kor, int eng, int mat, int sci) {

super(kor, eng, mat);

this.sci = sci;

}

public HighStudentChild(String name, int kor, int eng, int mat, int sci) {

super(name, kor, eng, mat);

this.sci = sci;

}

public void Calc() {

this.tot = kor + eng + mat + sci;

this.ave = this.tot / 4.0;

if(this.ave >= 90) {

this.grade = "수";

}

else if(this.ave >= 80) {

this.grade = "우";

}

else if(this.ave >= 70) {

this.grade = "미";

}

else if(this.ave >= 60) {

this.grade = "양";

}

else{

this.grade = "가";

}

public void Input() {

Scanner scan = new Scanner(System.in);

System.out.print("이름 : ");

this.name = scan.nextLine();

System.out.print("국어 : ");

this.kor = scan.nextInt();

System.out.print("영어 : ");

this.eng = scan.nextInt();

System.out.print("수학 : ");

this.mat = scan.nextInt();

System.out.print("과학 : ");

this.sci = scan.nextInt();

this.Calc();

}

public void Print() {

System.out.println(

"이름 : " + this.name

+ "\t국어 : " + this.kor

+ "\t영어 : " + this.eng

+ "\t수학 : " + this.mat

+ "\t과학 : " + this.sci

+ "\t총점 : " + this.tot

//+ "\t평균 : " + this.ave

+ "\t평균 : " + String.format("%6.2f", this.ave)

+ "\t등급 : " + this.grade

);

}

S010_Sungjuk.java : HighStudentChild 클래스를 사용하여 성적처리

package kr.ac.jj.java201812345;

public class S010_Sungjuk {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		HighStudentChild hs = new HighStudentChild(90, 80, 75, 100);
		hs.Print();
	}
}

1

2

3

4

5

6

7

8

9

10

package kr.ac.jj.java201812345;

public class S010_Sungjuk {

public static void main(String[] args) {

// TODO Auto-generated method stub

HighStudentChild hs = new HighStudentChild(90, 80, 75, 100);

hs.Print();

}

09번째 프로그램(성적처리) – 예외처리, 파일 읽기/쓰기

HighStudent.java : HighStudent 클래스를 사용하여 성적처리

package kr.ac.jj.java201812345;

import java.io.BufferedWriter;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.Scanner;

public class HighStudent{
	String name = "No Name";
	int kor;
	int eng;
	int mat;
	int tot;
	double ave;
	String grade;

	public HighStudent() {

	}

	public HighStudent(int kor, int eng, int mat) {
		this.kor = kor;
		this.eng = eng;
		this.mat = mat;

		this.Calc();
	}

	public HighStudent(String name, int kor, int eng, int mat) {
		this(kor, eng, mat);
		this.name = name;
	}

	public void Calc() {
		this.tot = kor + eng + mat;
		this.ave = this.tot / 3.0;

		if(this.ave >= 90) {
			this.grade = "수";
		}
		else if(this.ave >= 80) {
			this.grade = "우";
		}
		else if(this.ave >= 70) {
			this.grade = "미";
		}
		else if(this.ave >= 60) {
			this.grade = "양";
		}
		else{
			this.grade = "가";
		}
	}

	public void Input() {
		Scanner scan = new Scanner(System.in);

		System.out.print("이름 : ");
		this.name = scan.nextLine();
		System.out.print("국어 : ");
		this.kor = scan.nextInt();
		System.out.print("영어 : ");
		this.eng = scan.nextInt();
		System.out.print("수학 : ");
		this.mat = scan.nextInt();

		this.Calc();
	}

	public void Print() {
		System.out.println(
				"이름 : " + this.name
				+ "\t국어 : " + this.kor
				+ "\t영어 : " + this.eng
				+ "\t수학 : " + this.mat
				+ "\t총점 : " + this.tot
				//+ "\t평균 : " + this.ave
				+ "\t평균 : " + String.format("%6.2f", this.ave)
				+ "\t등급 : " + this.grade
				);
	}

	public void PrintNew() {
		System.out.println(
				this.name
				+ "\t" + this.kor
				+ "\t" + this.eng
				+ "\t" + String.format("%3d", this.mat)
				+ "\t" + this.tot
				+ "\t" + String.format("%6.2f", this.ave)
				+ "\t" + this.grade
				);
	}

	public static void PrintHead() {
		System.out.println("이름\t국어\t영어\t수학\t총점\t평균\t등급");
	}

	public static void FilePrintHead() {
		PrintWriter out = null;

		try {
			out = new PrintWriter(new BufferedWriter(new FileWriter("D:\\out.txt", false)));
			out.println("이름\t국어\t영어\t수학\t총점\t평균\t등급");
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally {
			if(out != null) {
				out.close();
			}
		}
	}

	public void FilePrint() {
		PrintWriter out = null;

		try {
			out = new PrintWriter(new BufferedWriter(new FileWriter("D:\\out.txt", true)));
			out.println(
					this.name
					+ "\t" + this.kor
					+ "\t" + this.eng
					+ "\t" + this.mat
					+ "\t" + this.tot
					+ "\t" + String.format("%6.2f", this.ave)
					+ "\t" + this.grade
					);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally {
			if(out != null) {
				out.close();
			}
		}
	}

}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

package kr.ac.jj.java201812345;

import java.io.BufferedWriter;

import java.io.FileWriter;

import java.io.IOException;

import java.io.PrintWriter;

import java.util.Scanner;

public class HighStudent{

String name = "No Name";

int kor;

int eng;

int mat;

int tot;

double ave;

String grade;

public HighStudent() {

}

public HighStudent(int kor, int eng, int mat) {

this.kor = kor;

this.eng = eng;

this.mat = mat;

this.Calc();

}

public HighStudent(String name, int kor, int eng, int mat) {

this(kor, eng, mat);

this.name = name;

}

public void Calc() {

this.tot = kor + eng + mat;

this.ave = this.tot / 3.0;

if(this.ave >= 90) {

this.grade = "수";

}

else if(this.ave >= 80) {

this.grade = "우";

}

else if(this.ave >= 70) {

this.grade = "미";

}

else if(this.ave >= 60) {

this.grade = "양";

}

else{

this.grade = "가";

}

public void Input() {

Scanner scan = new Scanner(System.in);

System.out.print("이름 : ");

this.name = scan.nextLine();

System.out.print("국어 : ");

this.kor = scan.nextInt();

System.out.print("영어 : ");

this.eng = scan.nextInt();

System.out.print("수학 : ");

this.mat = scan.nextInt();

this.Calc();

}

public void Print() {

System.out.println(

"이름 : " + this.name

+ "\t국어 : " + this.kor

+ "\t영어 : " + this.eng

+ "\t수학 : " + this.mat

+ "\t총점 : " + this.tot

//+ "\t평균 : " + this.ave

+ "\t평균 : " + String.format("%6.2f", this.ave)

+ "\t등급 : " + this.grade

);

}

public void PrintNew() {

System.out.println(

this.name

+ "\t" + this.kor

+ "\t" + this.eng

+ "\t" + String.format("%3d", this.mat)

+ "\t" + this.tot

+ "\t" + String.format("%6.2f", this.ave)

+ "\t" + this.grade

);

}

public static void PrintHead() {

System.out.println("이름\t국어\t영어\t수학\t총점\t평균\t등급");

}

public static void FilePrintHead() {

PrintWriter out = null;

try {

out = new PrintWriter(new BufferedWriter(new FileWriter("D:\\out.txt", false)));

out.println("이름\t국어\t영어\t수학\t총점\t평균\t등급");

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

finally {

if(out != null) {

out.close();

}

public void FilePrint() {

PrintWriter out = null;

try {

out = new PrintWriter(new BufferedWriter(new FileWriter("D:\\out.txt", true)));

out.println(

this.name

+ "\t" + this.kor

+ "\t" + this.eng

+ "\t" + this.mat

+ "\t" + this.tot

+ "\t" + String.format("%6.2f", this.ave)

+ "\t" + this.grade

);

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

finally {

if(out != null) {

out.close();

}

S009_Sungjuk.java : HighStudent 클래스를 사용하여 성적처리

package kr.ac.jj.java201812345;

import java.io.BufferedReader;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.util.Scanner;

public class S009_Sungjuk {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		HighStudent[] st = new HighStudent[5];

		Scanner scan = null;
		try {
			scan = new Scanner(new BufferedReader(new FileReader("D:\\in.txt")));

			for(int i=0; i<st.length; i++) {
				String name = scan.next();
				int kor = scan.nextInt();
				int eng = scan.nextInt();
				int mat = scan.nextInt();
				st[i] = new HighStudent(name, kor, eng, mat);
			}

		} catch (FileNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally {
			if(scan != null) {
				scan.close();
			}
		}

		HighStudent.FilePrintHead();
		for(int i=0; i<st.length; i++) {
			//st[i].Print();
			st[i].FilePrint();
		}
	}
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

package kr.ac.jj.java201812345;

import java.io.BufferedReader;

import java.io.FileNotFoundException;

import java.io.FileReader;

import java.util.Scanner;

public class S009_Sungjuk {

public static void main(String[] args) {

// TODO Auto-generated method stub

HighStudent[] st = new HighStudent[5];

Scanner scan = null;

try {

scan = new Scanner(new BufferedReader(new FileReader("D:\\in.txt")));

for(int i=0; i<st.length; i++) {

String name = scan.next();

int kor = scan.nextInt();

int eng = scan.nextInt();

int mat = scan.nextInt();

st[i] = new HighStudent(name, kor, eng, mat);

}

} catch (FileNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

finally {

if(scan != null) {

scan.close();

}

HighStudent.FilePrintHead();

for(int i=0; i<st.length; i++) {

//st[i].Print();

st[i].FilePrint();

}

D:\in.txt 생성

홍길동 95 90 100
길동이 85 88 98
길동삼 100 89 99
길동사 99 98 97
길동오 87 100 84

1

2

3

4

5

홍길동 95 90 100

길동이 85 88 98

길동삼 100 89 99

길동사 99 98 97

길동오 87 100 84

실행 후 생성되는 D:\out.txt

이름	국어	영어	수학	총점	평균	등급
홍길동	95	90	100	285	 95.00	수
길동이	85	88	98	271	 90.33	수
길동삼	100	89	99	288	 96.00	수
길동사	99	98	97	294	 98.00	수
길동오	87	100	84	271	 90.33	수

1

2

3

4

5

6

이름 국어 영어 수학 총점 평균 등급

홍길동 95 90 100 285 95.00 수

길동이 85 88 98 271 90.33 수

길동삼 100 89 99 288 96.00 수

길동사 99 98 97 294 98.00 수

길동오 87 100 84 271 90.33 수

08번째 프로그램(성적처리) – 배열, static

HighStudent.java : HighStudent 클래스를 사용하여 성적처리

package kr.ac.jj.java201812345;

import java.io.BufferedWriter;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.Scanner;

public class HighStudent{
	String name = "No Name";
	int kor;
	int eng;
	int mat;
	int tot;
	double ave;
	String grade;

	public HighStudent() {

	}

	public HighStudent(int kor, int eng, int mat) {
		this.kor = kor;
		this.eng = eng;
		this.mat = mat;

		this.Calc();
	}

	public HighStudent(String name, int kor, int eng, int mat) {
		this(kor, eng, mat);
		this.name = name;
	}

	public void Calc() {
		this.tot = kor + eng + mat;
		this.ave = this.tot / 3.0;

		if(this.ave >= 90) {
			this.grade = "수";
		}
		else if(this.ave >= 80) {
			this.grade = "우";
		}
		else if(this.ave >= 70) {
			this.grade = "미";
		}
		else if(this.ave >= 60) {
			this.grade = "양";
		}
		else{
			this.grade = "가";
		}
	}

	public void Input() {
		Scanner scan = new Scanner(System.in);

		System.out.print("이름 : ");
		this.name = scan.nextLine();
		System.out.print("국어 : ");
		this.kor = scan.nextInt();
		System.out.print("영어 : ");
		this.eng = scan.nextInt();
		System.out.print("수학 : ");
		this.mat = scan.nextInt();

		this.Calc();
	}

	public void Print() {
		System.out.println(
				"이름 : " + this.name
				+ "\t국어 : " + this.kor
				+ "\t영어 : " + this.eng
				+ "\t수학 : " + this.mat
				+ "\t총점 : " + this.tot
				//+ "\t평균 : " + this.ave
				+ "\t평균 : " + String.format("%6.2f", this.ave)
				+ "\t등급 : " + this.grade
				);
	}

	public void PrintNew() {
		System.out.println(
				this.name
				+ "\t" + this.kor
				+ "\t" + this.eng
				+ "\t" + String.format("%3d", this.mat)
				+ "\t" + this.tot
				+ "\t" + String.format("%6.2f", this.ave)
				+ "\t" + this.grade
				);
	}

	public static void PrintHead() {
		System.out.println("이름\t국어\t영어\t수학\t총점\t평균\t등급");
	}
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

package kr.ac.jj.java201812345;

import java.io.BufferedWriter;

import java.io.FileWriter;

import java.io.IOException;

import java.io.PrintWriter;

import java.util.Scanner;

public class HighStudent{

String name = "No Name";

int kor;

int eng;

int mat;

int tot;

double ave;

String grade;

public HighStudent() {

}

public HighStudent(int kor, int eng, int mat) {

this.kor = kor;

this.eng = eng;

this.mat = mat;

this.Calc();

}

public HighStudent(String name, int kor, int eng, int mat) {

this(kor, eng, mat);

this.name = name;

}

public void Calc() {

this.tot = kor + eng + mat;

this.ave = this.tot / 3.0;

if(this.ave >= 90) {

this.grade = "수";

}

else if(this.ave >= 80) {

this.grade = "우";

}

else if(this.ave >= 70) {

this.grade = "미";

}

else if(this.ave >= 60) {

this.grade = "양";

}

else{

this.grade = "가";

}

public void Input() {

Scanner scan = new Scanner(System.in);

System.out.print("이름 : ");

this.name = scan.nextLine();

System.out.print("국어 : ");

this.kor = scan.nextInt();

System.out.print("영어 : ");

this.eng = scan.nextInt();

System.out.print("수학 : ");

this.mat = scan.nextInt();

this.Calc();

}

public void Print() {

System.out.println(

"이름 : " + this.name

+ "\t국어 : " + this.kor

+ "\t영어 : " + this.eng

+ "\t수학 : " + this.mat

+ "\t총점 : " + this.tot

//+ "\t평균 : " + this.ave

+ "\t평균 : " + String.format("%6.2f", this.ave)

+ "\t등급 : " + this.grade

);

}

public void PrintNew() {

System.out.println(

this.name

+ "\t" + this.kor

+ "\t" + this.eng

+ "\t" + String.format("%3d", this.mat)

+ "\t" + this.tot

+ "\t" + String.format("%6.2f", this.ave)

+ "\t" + this.grade

);

}

public static void PrintHead() {

System.out.println("이름\t국어\t영어\t수학\t총점\t평균\t등급");

}

S008_Sungjuk.java : HighStudent 클래스를 사용하여 성적처리

package kr.ac.jj.java201812345;

public class S008_Sungjuk {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		String[] name = new String[] {"홍길동", "길동이", "길동삼", "길동사", "길동오"};
		int[] kor = new int[] {95, 85, 100, 99, 87};
		int[] eng = new int[] {90, 88, 89, 98, 100};
		int[] mat = new int[] {100, 98, 99, 97, 84};

		HighStudent[] st = new HighStudent[5];

		for(int i=0; i<st.length; i++) {
			st[i] = new HighStudent(name[i], kor[i], eng[i], mat[i]);
		}

		HighStudent.PrintHead();
		for(int i=0; i<st.length; i++) {
			st[i].PrintNew();
		}
	}
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

package kr.ac.jj.java201812345;

public class S008_Sungjuk {

public static void main(String[] args) {

// TODO Auto-generated method stub

String[] name = new String[] {"홍길동", "길동이", "길동삼", "길동사", "길동오"};

int[] kor = new int[] {95, 85, 100, 99, 87};

int[] eng = new int[] {90, 88, 89, 98, 100};

int[] mat = new int[] {100, 98, 99, 97, 84};

HighStudent[] st = new HighStudent[5];

for(int i=0; i<st.length; i++) {

st[i] = new HighStudent(name[i], kor[i], eng[i], mat[i]);

}

HighStudent.PrintHead();

for(int i=0; i<st.length; i++) {

st[i].PrintNew();

}

..

07번째 프로그램(성적처리) – 클래스 개념

HighStudent.java : HighStudent 클래스를 사용하여 성적처리

package kr.ac.jj.java201812345;

import java.util.Scanner;

public class HighStudent{
	String name = "No Name";
	int kor;
	int eng;
	int mat;
	int tot;
	double ave;
	String grade;

	public HighStudent() {

	}

	public HighStudent(int kor, int eng, int mat) {
		this.kor = kor;
		this.eng = eng;
		this.mat = mat;

		this.Calc();
	}

	public HighStudent(String name, int kor, int eng, int mat) {
		this(kor, eng, mat);
		this.name = name;
	}

	public void Calc() {
		this.tot = kor + eng + mat;
		this.ave = this.tot / 3.0;

		if(this.ave >= 90) {
			this.grade = "수";
		}
		else if(this.ave >= 80) {
			this.grade = "우";
		}
		else if(this.ave >= 70) {
			this.grade = "미";
		}
		else if(this.ave >= 60) {
			this.grade = "양";
		}
		else{
			this.grade = "가";
		}
	}

	public void Input() {
		Scanner scan = new Scanner(System.in);

		System.out.print("이름 : ");
		this.name = scan.nextLine();
		System.out.print("국어 : ");
		this.kor = scan.nextInt();
		System.out.print("영어 : ");
		this.eng = scan.nextInt();
		System.out.print("수학 : ");
		this.mat = scan.nextInt();

		this.Calc();
	}

	public void Print() {
		System.out.println(
				"이름 : " + this.name
				+ "\t국어 : " + this.kor
				+ "\t영어 : " + this.eng
				+ "\t수학 : " + this.mat
				+ "\t총점 : " + this.tot
				//+ "\t평균 : " + this.ave
				+ "\t평균 : " + String.format("%6.2f", this.ave)
				+ "\t등급 : " + this.grade
				);
	}

}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

package kr.ac.jj.java201812345;

import java.util.Scanner;

public class HighStudent{

String name = "No Name";

int kor;

int eng;

int mat;

int tot;

double ave;

String grade;

public HighStudent() {

}

public HighStudent(int kor, int eng, int mat) {

this.kor = kor;

this.eng = eng;

this.mat = mat;

this.Calc();

}

public HighStudent(String name, int kor, int eng, int mat) {

this(kor, eng, mat);

this.name = name;

}

public void Calc() {

this.tot = kor + eng + mat;

this.ave = this.tot / 3.0;

if(this.ave >= 90) {

this.grade = "수";

}

else if(this.ave >= 80) {

this.grade = "우";

}

else if(this.ave >= 70) {

this.grade = "미";

}

else if(this.ave >= 60) {

this.grade = "양";

}

else{

this.grade = "가";

}

public void Input() {

Scanner scan = new Scanner(System.in);

System.out.print("이름 : ");

this.name = scan.nextLine();

System.out.print("국어 : ");

this.kor = scan.nextInt();

System.out.print("영어 : ");

this.eng = scan.nextInt();

System.out.print("수학 : ");

this.mat = scan.nextInt();

this.Calc();

}

public void Print() {

System.out.println(

"이름 : " + this.name

+ "\t국어 : " + this.kor

+ "\t영어 : " + this.eng

+ "\t수학 : " + this.mat

+ "\t총점 : " + this.tot

//+ "\t평균 : " + this.ave

+ "\t평균 : " + String.format("%6.2f", this.ave)

+ "\t등급 : " + this.grade

);

}

S007_Sungjuk.java : HighStudent 클래스를 사용하여 성적처리

package kr.ac.jj.java201812345;

import java.util.Scanner;

public class S007_Sungjuk {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		HighStudent hs = new HighStudent(90, 80, 75);
		hs.Print();
	}

}

1

2

3

4

5

6

7

8

9

10

11

12

13

package kr.ac.jj.java201812345;

import java.util.Scanner;

public class S007_Sungjuk {

public static void main(String[] args) {

// TODO Auto-generated method stub

HighStudent hs = new HighStudent(90, 80, 75);

hs.Print();

}

위 소스에서 HighStudent 클래스를 참조하여 UnivStudent 클래스를 생성

class UnivStudent{
	//stud_id //학번
	//name    //이름
	//course  //과목
	//pres    //출석
	//rep     //과제
	//mid     //중간
	//final   //기말
	//score   //점수
	//grade   //학점
}

1

2

3

4

5

6

7

8

9

10

11

class UnivStudent{

//stud_id //학번

//name //이름

//course //과목

//pres //출석

//rep //과제

//mid //중간

//final //기말

//score //점수

//grade //학점

}

자바로 SQLite에서 SQL 사용하기

동영상 강의 Sqlite DB에 값을 저장(INSERT)하는 자바 코딩 Sqlite DB에 값을 수정(UPDATE)하는 자바 코딩 AddrDAO 클래스 코딩 contacts 테이블에 Insert/Update/Delete 하기 1

package kr.ac.jj.japanteam;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class J002_SqliteInsertUpdateDelte1st {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		String DBFileName = "d:\\addr.db";

		Connection conn = null;
		PreparedStatement ps = null;

		try {
			Class.forName("org.sqlite.JDBC");
			conn = DriverManager.getConnection("jdbc:sqlite:" + DBFileName);
		} catch (Exception e) {
			e.printStackTrace();
		}

		String sql = "INSERT INTO contact(name, phone, addr, post) VALUES('홍길동', '010-1111-1111', '전라북도 전주시', '51111');";
//		String sql = "UPDATE contact SET phone='010-5555-5555' WHERE name='길동이';";
//		String sql = "DELETE FROM contact WHERE name='홍길동';";
		try {
			ps = conn.prepareStatement(sql);
			int r = ps.executeUpdate();
			if(r > 0) {
				System.out.println("저장/수정/삭제 성공");
			}
			else {
				System.out.println("저장/수정/삭제 실패");
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

package kr.ac.jj.japanteam;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class J002_SqliteInsertUpdateDelte1st {

public static void main(String[] args) {

// TODO Auto-generated method stub

String DBFileName = "d:\\addr.db";

Connection conn = null;

PreparedStatement ps = null;

try {

Class.forName("org.sqlite.JDBC");

conn = DriverManager.getConnection("jdbc:sqlite:" + DBFileName);

} catch (Exception e) {

e.printStackTrace();

}

String sql = "INSERT INTO contact(name, phone, addr, post) VALUES('홍길동', '010-1111-1111', '전라북도 전주시', '51111');";

// String sql = "UPDATE contact SET phone='010-5555-5555' WHERE name='길동이';";

// String sql = "DELETE FROM contact WHERE name='홍길동';";

try {

ps = conn.prepareStatement(sql);

int r = ps.executeUpdate();

if(r > 0) {

System.out.println("저장/수정/삭제 성공");

}

else {

System.out.println("저장/수정/삭제 실패");

}

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

contacts 테이블에 Select 하기 1

package kr.ac.jj.japanteam;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class J002_SqliteSelect1st {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		String DBFileName = "d:\\addr.db";

		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;

		try {
			Class.forName("org.sqlite.JDBC");
			conn = DriverManager.getConnection("jdbc:sqlite:" + DBFileName);
		} catch (Exception e) {
			e.printStackTrace();
		}

		String sql = "SELECT * FROM contact;";
		try {
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();

			while(rs.next()) {
				String name = rs.getString("name");
				String phone = rs.getString("phone");
				String addr = rs.getString("addr");
				String post = rs.getString("post");
				//int speed = rs.getInt("speed");
				System.out.println(name + "\t" + phone + "\t" + addr + "\t" + post);
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

package kr.ac.jj.japanteam;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class J002_SqliteSelect1st {

public static void main(String[] args) {

// TODO Auto-generated method stub

String DBFileName = "d:\\addr.db";

Connection conn = null;

PreparedStatement ps = null;

ResultSet rs = null;

try {

Class.forName("org.sqlite.JDBC");

conn = DriverManager.getConnection("jdbc:sqlite:" + DBFileName);

} catch (Exception e) {

e.printStackTrace();

}

String sql = "SELECT * FROM contact;";

try {

ps = conn.prepareStatement(sql);

rs = ps.executeQuery();

while(rs.next()) {

String name = rs.getString("name");

String phone = rs.getString("phone");

String addr = rs.getString("addr");

String post = rs.getString("post");

//int speed = rs.getInt("speed");

System.out.println(name + "\t" + phone + "\t" + addr + "\t" + post);

}

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

contacts 테이블에 Insert/Update/Delete 하기 2

package kr.ac.jj.japanteam;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class J002_SqliteInsertUpdateDelte2nd {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		String DBFileName = "d:\\addr.db";

		Connection conn = null;
		PreparedStatement ps = null;

		try {
			Class.forName("org.sqlite.JDBC");
			conn = DriverManager.getConnection("jdbc:sqlite:" + DBFileName);
		} catch (Exception e) {
			e.printStackTrace();
		}

		String sql = "INSERT INTO contact(name, phone, addr, post) VALUES(?,?,?,?);";
//		String sql = "UPDATE contact SET phone=? WHERE name=?;";
//		String sql = "DELETE FROM contact WHERE name=?;";
		try {
			ps = conn.prepareStatement(sql);
			//Insert 경우
			ps.setString(1, "홍길동");
			ps.setString(2, "010-1111-1111");
			ps.setString(3, "전라북도 전주시");
			ps.setString(4, "51111");
			//ps.setInt(5,  3); //정수값을 넣을때는 setInt() 사용

			//Update 경우
			//ps.setString(1, "010-5555-5555");
			//ps.setString(2, "홍길동");

			//Delete 경우
			//ps.setString(1, "홍길동");

			int r = ps.executeUpdate();
			if(r > 0) {
				System.out.println("저장/수정/삭제 성공");
			}
			else {
				System.out.println("저장/수정/삭제 실패");
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

package kr.ac.jj.japanteam;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class J002_SqliteInsertUpdateDelte2nd {

public static void main(String[] args) {

// TODO Auto-generated method stub

String DBFileName = "d:\\addr.db";

Connection conn = null;

PreparedStatement ps = null;

try {

Class.forName("org.sqlite.JDBC");

conn = DriverManager.getConnection("jdbc:sqlite:" + DBFileName);

} catch (Exception e) {

e.printStackTrace();

}

String sql = "INSERT INTO contact(name, phone, addr, post) VALUES(?,?,?,?);";

// String sql = "UPDATE contact SET phone=? WHERE name=?;";

// String sql = "DELETE FROM contact WHERE name=?;";

try {

ps = conn.prepareStatement(sql);

//Insert 경우

ps.setString(1, "홍길동");

ps.setString(2, "010-1111-1111");

ps.setString(3, "전라북도 전주시");

ps.setString(4, "51111");

//ps.setInt(5, 3); //정수값을 넣을때는 setInt() 사용

//Update 경우

//ps.setString(1, "010-5555-5555");

//ps.setString(2, "홍길동");

//Delete 경우

//ps.setString(1, "홍길동");

int r = ps.executeUpdate();

if(r > 0) {

System.out.println("저장/수정/삭제 성공");

}

else {

System.out.println("저장/수정/삭제 실패");

}

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

contacts 테이블에 Select 하기 2

package kr.ac.jj.japanteam;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class J002_SqliteSelect2nd {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		String DBFileName = "d:\\addr.db";

		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;

		try {
			Class.forName("org.sqlite.JDBC");
			conn = DriverManager.getConnection("jdbc:sqlite:" + DBFileName);
		} catch (Exception e) {
			e.printStackTrace();
		}

		String sql = "SELECT * FROM contact WHERE post like ?;";
		try {
			ps = conn.prepareStatement(sql);
			ps.setString(1, "52222");
			//ps.setInt(2, 10);//?에 정수값이 들어갈때 사용
			rs = ps.executeQuery();

			while(rs.next()) {
				String name = rs.getString("name");
				String phone = rs.getString("phone");
				String addr = rs.getString("addr");
				String post = rs.getString("post");
				//int speed = rs.getInt("speed");  //테이블의 필드가 integer 형 일때 사용
				System.out.println(name + "\t" + phone + "\t" + addr + "\t" + post);
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

package kr.ac.jj.japanteam;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class J002_SqliteSelect2nd {

public static void main(String[] args) {

// TODO Auto-generated method stub

String DBFileName = "d:\\addr.db";

Connection conn = null;

PreparedStatement ps = null;

ResultSet rs = null;

try {

Class.forName("org.sqlite.JDBC");

conn = DriverManager.getConnection("jdbc:sqlite:" + DBFileName);

} catch (Exception e) {

e.printStackTrace();

}

String sql = "SELECT * FROM contact WHERE post like ?;";

try {

ps = conn.prepareStatement(sql);

ps.setString(1, "52222");

//ps.setInt(2, 10);//?에 정수값이 들어갈때 사용

rs = ps.executeQuery();

while(rs.next()) {

String name = rs.getString("name");

String phone = rs.getString("phone");

String addr = rs.getString("addr");

String post = rs.getString("post");

//int speed = rs.getInt("speed"); //테이블의 필드가 integer 형 일때 사용

System.out.println(name + "\t" + phone + "\t" + addr + "\t" + post);

}

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

DataAccessObject 클래스로 재구성

package kr.ac.jj.japanteam;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class J002_SqliteTotal {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		DataAccessObject dao = new DataAccessObject();
		dao.select();
		dao.insert("홍길동", "010-1111-1111","전라북도 전주시", "51111");
		dao.select();
		dao.update("홍길동", "010-5555-5555");
		dao.select();
		dao.delete("길동이");
		dao.select_post("51111");

	}
}



class DataAccessObject {
	String DBFileName = "d:\\addr.db";

	public Connection getConn() {
		Connection conn = null;

		try {
			Class.forName("org.sqlite.JDBC");
			conn = DriverManager.getConnection("jdbc:sqlite:" + DBFileName);
		} catch (Exception e) {
			e.printStackTrace();
		}

		return conn;
	}

	public boolean insert(String name, String phone, String addr, String post) {
		String sql = "INSERT INTO contact(name, phone, addr, post) VALUES(?,?,?,?);";
		Connection conn = null;
		PreparedStatement ps = null;
		int r = 0;
		try {
			conn = getConn();
			ps = conn.prepareStatement(sql);
			ps.setString(1, name);
			ps.setString(2, phone);
			ps.setString(3, addr);
			ps.setString(4, post);
			//ps.setInt(5,  3); //?에 정수값을 넣을때는 setInt() 사용

			r = ps.executeUpdate();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		if(r > 0) return true;
		else return false;
	}

	public boolean update(String name, String phone) {
		String sql = "UPDATE contact SET phone=? WHERE name=?;";
		Connection conn = null;
		PreparedStatement ps = null;
		int r = 0;
		try {
			conn = getConn();
			ps = conn.prepareStatement(sql);
			ps.setString(1, phone);
			ps.setString(2, name);
			//ps.setInt(5,  3); //?에 정수값을 넣을때는 setInt() 사용

			r = ps.executeUpdate();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		if(r > 0) return true;
		else return false;
	}

	public boolean delete(String name) {
		String sql = "DELETE FROM contact WHERE name=?;";
		Connection conn = null;
		PreparedStatement ps = null;
		int r = 0;
		try {
			conn = getConn();
			ps = conn.prepareStatement(sql);
			ps.setString(1, name);
			//ps.setInt(5,  3); //?에 정수값을 넣을때는 setInt() 사용

			r = ps.executeUpdate();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		if(r > 0) return true;
		else return false;
	}

	public void select() {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;

		String sql = "SELECT * FROM contact;";
		try {
			conn = getConn();
			ps = conn.prepareStatement(sql);
			//ps.setInt(2, 10);//?에 정수값이 들어갈때 사용
			rs = ps.executeQuery();

			while(rs.next()) {
				String name = rs.getString("name");
				String phone = rs.getString("phone");
				String addr = rs.getString("addr");
				String post2 = rs.getString("post");
				//int speed = rs.getInt("speed");  //테이블의 필드가 integer 형 일때 사용
				System.out.println(name + "\t" + phone + "\t" + addr + "\t" + post2);
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void select_post(String post) {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;

		String sql = "SELECT * FROM contact WHERE post like ?;";
		try {
			conn = getConn();
			ps = conn.prepareStatement(sql);
			ps.setString(1, post);
			//ps.setInt(2, 10);//?에 정수값이 들어갈때 사용
			rs = ps.executeQuery();

			while(rs.next()) {
				String name = rs.getString("name");
				String phone = rs.getString("phone");
				String addr = rs.getString("addr");
				String post2 = rs.getString("post");
				//int speed = rs.getInt("speed");  //테이블의 필드가 integer 형 일때 사용
				System.out.println(name + "\t" + phone + "\t" + addr + "\t" + post2);
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

package kr.ac.jj.japanteam;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class J002_SqliteTotal {

public static void main(String[] args) {

// TODO Auto-generated method stub

DataAccessObject dao = new DataAccessObject();

dao.select();

dao.insert("홍길동", "010-1111-1111","전라북도 전주시", "51111");

dao.select();

dao.update("홍길동", "010-5555-5555");

dao.select();

dao.delete("길동이");

dao.select_post("51111");

}

class DataAccessObject {

String DBFileName = "d:\\addr.db";

public Connection getConn() {

Connection conn = null;

try {

Class.forName("org.sqlite.JDBC");

conn = DriverManager.getConnection("jdbc:sqlite:" + DBFileName);

} catch (Exception e) {

e.printStackTrace();

}

return conn;

}

public boolean insert(String name, String phone, String addr, String post) {

String sql = "INSERT INTO contact(name, phone, addr, post) VALUES(?,?,?,?);";

Connection conn = null;

PreparedStatement ps = null;

int r = 0;

try {

conn = getConn();

ps = conn.prepareStatement(sql);

ps.setString(1, name);

ps.setString(2, phone);

ps.setString(3, addr);

ps.setString(4, post);

//ps.setInt(5, 3); //?에 정수값을 넣을때는 setInt() 사용

r = ps.executeUpdate();

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

if(r > 0) return true;

else return false;

}

public boolean update(String name, String phone) {

String sql = "UPDATE contact SET phone=? WHERE name=?;";

Connection conn = null;

PreparedStatement ps = null;

int r = 0;

try {

conn = getConn();

ps = conn.prepareStatement(sql);

ps.setString(1, phone);

ps.setString(2, name);

//ps.setInt(5, 3); //?에 정수값을 넣을때는 setInt() 사용

r = ps.executeUpdate();

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

if(r > 0) return true;

else return false;

}

public boolean delete(String name) {

String sql = "DELETE FROM contact WHERE name=?;";

Connection conn = null;

PreparedStatement ps = null;

int r = 0;

try {

conn = getConn();

ps = conn.prepareStatement(sql);

ps.setString(1, name);

//ps.setInt(5, 3); //?에 정수값을 넣을때는 setInt() 사용

r = ps.executeUpdate();

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

if(r > 0) return true;

else return false;

}

public void select() {

Connection conn = null;

PreparedStatement ps = null;

ResultSet rs = null;

String sql = "SELECT * FROM contact;";

try {

conn = getConn();

ps = conn.prepareStatement(sql);

//ps.setInt(2, 10);//?에 정수값이 들어갈때 사용

rs = ps.executeQuery();

while(rs.next()) {

String name = rs.getString("name");

String phone = rs.getString("phone");

String addr = rs.getString("addr");

String post2 = rs.getString("post");

//int speed = rs.getInt("speed"); //테이블의 필드가 integer 형 일때 사용

System.out.println(name + "\t" + phone + "\t" + addr + "\t" + post2);

}

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

public void select_post(String post) {

Connection conn = null;

PreparedStatement ps = null;

ResultSet rs = null;

String sql = "SELECT * FROM contact WHERE post like ?;";

try {

conn = getConn();

ps = conn.prepareStatement(sql);

ps.setString(1, post);

//ps.setInt(2, 10);//?에 정수값이 들어갈때 사용

rs = ps.executeQuery();

while(rs.next()) {

String name = rs.getString("name");

String phone = rs.getString("phone");

String addr = rs.getString("addr");

String post2 = rs.getString("post");

//int speed = rs.getInt("speed"); //테이블의 필드가 integer 형 일때 사용

System.out.println(name + "\t" + phone + "\t" + addr + "\t" + post2);

}

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

과제 1 : 위 6번을 완성해서… Continue Reading 자바로 SQLite에서 SQL 사용하기

06번째 프로그램(상속 Inheritance)

S004_ContactsInheritance 소스 코드 : 상속 사용 예 추가

package kr.ac.jj.java201812345;

public class S006_ContactsInheritance {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		MyMember p = new MyMember();
		p.Input();

		MyMember q = new MyMember();
		q.Input();

		MyMember r = new MyMember("홍길동");
		MyMember s = new MyMember("길동이", "010-1111-1111");
		MyMember t = new MyMember("길동삼", "010-2222-2222", 5);
		MyMember u = new MyMember("길동사", "010-2222-2222", 5, "사오정");

		System.out.println("입력된 인원수 : " + Member.cnt);
		p.Print();
		q.Print();
		r.Print();
		s.Print();
		t.Print();
		u.Print();
	}

}

class MyMember extends Member{
	String nick;

	public MyMember() {							// 1
		//cnt++;
	}

	public MyMember(String name) { 				// 2
		super(name);
	}

	public MyMember(String name, String phone) {	// 3
		super(name, phone);
	}


	public MyMember(String name, String phone, int speed_dial) { // 4
		super(name, phone, speed_dial);
	}

	public MyMember(String name, String phone, int speed_dial, String nick) { // 5
		this(name, phone);
		this.speed_dial = speed_dial;
		this.nick = nick;
	}

	public void Print() {
		System.out.println(
				"학교 : " + this.univ
				+ " 이름 : " + this.name
				+ " 휴대폰 : " + this.phone
				+ " 닉네임 : " + this.nick
				);
	}
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

package kr.ac.jj.java201812345;

public class S006_ContactsInheritance {

public static void main(String[] args) {

// TODO Auto-generated method stub

MyMember p = new MyMember();

p.Input();

MyMember q = new MyMember();

q.Input();

MyMember r = new MyMember("홍길동");

MyMember s = new MyMember("길동이", "010-1111-1111");

MyMember t = new MyMember("길동삼", "010-2222-2222", 5);

MyMember u = new MyMember("길동사", "010-2222-2222", 5, "사오정");

System.out.println("입력된 인원수 : " + Member.cnt);

p.Print();

q.Print();

r.Print();

s.Print();

t.Print();

u.Print();

}

class MyMember extends Member{

String nick;

public MyMember() { // 1

//cnt++;

}

public MyMember(String name) { // 2

super(name);

}

public MyMember(String name, String phone) { // 3

super(name, phone);

}

public MyMember(String name, String phone, int speed_dial) { // 4

super(name, phone, speed_dial);

}

public MyMember(String name, String phone, int speed_dial, String nick) { // 5

this(name, phone);

this.speed_dial = speed_dial;

this.nick = nick;

}

public void Print() {

System.out.println(

"학교 : " + this.univ

+ " 이름 : " + this.name

+ " 휴대폰 : " + this.phone

+ " 닉네임 : " + this.nick

);

}