FilesExpand file tree

 master

/

dbconnectionex1.java

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

50 lines (44 loc) · 1.47 KB

 master

/

dbconnectionex1.java

Copy path

Top

File metadata and controls

• Code
• Blame

50 lines (44 loc) · 1.47 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

import java.sql.*;

/*

* dbconnectionex1.java

*

* Copyright 2016 Aditya Gholba <aditya@aditya-ubuntu>

*

* This program is free software; you can redistribute it and/or modify

* it under the terms of the GNU General Public License as published by

* the Free Software Foundation; either version 2 of the License, or

* (at your option) any later version.

*

* This program is distributed in the hope that it will be useful,

* but WITHOUT ANY WARRANTY; without even the implied warranty of

* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

* GNU General Public License for more details.

*

* You should have received a copy of the GNU General Public License

* along with this program; if not, write to the Free Software

* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

* MA 02110-1301, USA.

*

*

*/

public class dbconnectionex1

{

public static void main(String args[])

{

try

{

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

//DriverManager.registerDriver(new com.mysql.jdbc.Driver()); not working

Connection con=DriverManager.getConnection("jdbc:mysql://localhost/test","aditya","aditya123");

Statement stmt=con.createStatement();

ResultSet rs = stmt.executeQuery("select * from student");

while(rs.next())

{

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

System.out.println(prn);

}

con.close();

}

catch(Exception e){ System.out.println(e);}

}

}