FilesExpand file tree

 main

/

QueriesJDBC.java

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

87 lines (40 loc) · 1.5 KB

 main

/

QueriesJDBC.java

Copy path

Top

File metadata and controls

• Code
• Blame

87 lines (40 loc) · 1.5 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

package com.howtodoinjava.jdbc.demo;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class SelectDataDemo {

public static void main(String[] args) {

Connection connection = null;

Statement insertStmt = null;

Statement selectStmt = null;

try

{

Class.forName("com.mysql.jdbc.Driver");

connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/JDBCDemo", "root", "password");

/*insertStmt = connection.createStatement();

insertStmt.execute("INSERT INTO EMPLOYEE (ID,FIRST_NAME,LAST_NAME,STAT_CD) VALUES (1,'Lokesh','Gupta',5)");

insertStmt.execute("INSERT INTO EMPLOYEE (ID,FIRST_NAME,LAST_NAME,STAT_CD) VALUES (2,'howtodoinjava','com',5)");*/

selectStmt = connection.createStatement();

ResultSet rs = selectStmt.executeQuery("SELECT ID,FIRST_NAME,LAST_NAME,STAT_CD FROM EMPLOYEE WHERE ID <= 10");

while(rs.next())

{

System.out.println(rs.getString(1)); //First Column

System.out.println(rs.getString(2)); //Second Column

System.out.println(rs.getString(3)); //Third Column

System.out.println(rs.getString(4)); //Fourth Column

}

}

catch (Exception e) {

e.printStackTrace();

}finally {

try {

selectStmt.close();

insertStmt.close();

connection.close();

} catch (Exception e) {

e.printStackTrace();

}

}

}

}