java 通用jdbc_基本通用的使用jdbc文件java代碼連接數據庫

import java.sql.*;

public class test_dm {

public static void getResult(ResultSet rs) throws Exception

{

while (rs.next()){

String name = rs.getString(1);

String type = rs.getString(2);

System.out.println("Name: " + name + " Type: " + type);

}

}

static String url = "jdbc:dm://192.168.7.43:5236";

static String username = "SYSDBA";

static String password = "sysdba";

public static void runSelectPrepare() throws Exception

{

Connection con = DriverManager.getConnection(url,username,password);

Statement stmt = con.createStatement();

String query0 = "select * from SYSDBA.t1";

con.commit();

ResultSet rs0 = stmt.executeQuery(query0);

getResult(rs0);

}

public static void main(String... args) throws Exception {

try{

runSelectPrepare();

//runInsertPrepare();

//runUpdatePrepare(http://www.my516.com);

//runNormalUpdateStmt();

}catch (Exception e) {

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

---------------------