FilesExpand file tree

 master

/

connDB.java

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

92 lines (85 loc) · 2.2 KB

 master

/

connDB.java

Copy path

Top

File metadata and controls

• Code
• Blame

92 lines (85 loc) · 2.2 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

88

89

90

91

92

package beans;

import java.io.PrintStream;

import java.sql.*;

public class connDB

{

private static Connection conn = null;

private static Statement stmt = null;

private static ResultSet rs = null;

private static final String driverClass = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

private static final String URL = "jdbc:sqlserver://localhost:1433;DatabaseName=db_bookmanage";

private static final String user = "sa";

private static final String pwd = "111";

public connDB()

{

try {

Class.forName(driverClass);

conn = DriverManager.getConnection(URL,user,pwd);

} catch (Exception e) {

e.printStackTrace();

}

}

public ResultSet executeQuery(String sql)

{

try {

stmt = conn.createStatement(1004, 1007);

rs = stmt.executeQuery(sql);

}

catch(SQLException ex)

{

System.err.println(ex.getMessage());

}

return rs;

}

public int executeUpdate(String sql)

{

int result = 0;

try

{

stmt = conn.createStatement(1004, 1007);

result = stmt.executeUpdate(sql);

}

catch(SQLException ex)

{

result = 0;

}

return result;

}

public int executeUpdate_id(String sql)

{

int result = 0;

try

{

stmt = conn.createStatement(1004, 1007);

result = stmt.executeUpdate(sql);

String ID = "select @@IDENTITY as id";

rs = stmt.executeQuery(ID);

if(rs.next())

{

int autoID = rs.getInt("id");

result = autoID;

}

}

catch(SQLException ex)

{

result = 0;

}

return result;

}

public void close()

{

try

{

if(rs != null)

rs.close();

if(stmt != null)

stmt.close();

if(conn != null)

conn.close();

}

catch(Exception e)

{

e.printStackTrace(System.err);

}

}

}