FilesExpand file tree

 master

/

database_connection.java

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

83 lines (68 loc) · 1.6 KB

 master

/

database_connection.java

Top

File metadata and controls

• Code
• Blame

83 lines (68 loc) · 1.6 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

package app.server;

import java.sql.*;

public class Connection {

private static final String dbClassName = "com.mysql.jdbc.Driver";

private static final String CONNECTION ="jdbc:mysql://localhost/esi";

private static java.sql.Connection connexion;

boolean connect() throws ClassNotFoundException,SQLException

{

try

{

Class.forName(dbClassName);

connexion=DriverManager.getConnection(CONNECTION,"root","root");

System.err.println("connexion réussie");

return true;

}

catch (Exception e)

{ e.printStackTrace();

System.err.println("ERROR :"+e.getMessage());

return false;

}

}

ResultSet dbquery(String query)

{

Statement stm = null;

try {

stm = connexion.createStatement();

} catch (SQLException e) {

System.out.println("ERROR :"+e.getMessage());

e.printStackTrace();

}

ResultSet res = null;

try {

res = stm.executeQuery(query);

} catch (SQLException e) {

System.out.println("ERROR :"+e.getMessage());

e.printStackTrace();

}

return res;

}

Boolean dbinsert(String query)

{

Statement stm = null;

try {

stm = connexion.createStatement();

} catch (SQLException e) {

System.out.println("ERROR :"+e.getMessage());

e.printStackTrace();

}

Boolean rep=false;

try

{

rep=stm.execute(query);

} catch (SQLException e) {

System.out.println("ERROR :"+e.getMessage());

e.printStackTrace();

}

return rep;

}

void disconnect()

{

try {

connexion.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}