java 的 数据库连接测试类 （SQL server）

package com.xrom.ssh.test;

import java.sql.*;
import java.text.SimpleDateFormat;

/**
 * 测试sql server 数据库是否能连接
 * Created by bill xu on 2019/1/31.
 */
public class TestConn {
    public static void main(String[] args) {

        String DataBaseName = "mydb";//数据库名称
        String user = "sa";  //数据库用户名
        String Psd = "sa";    //数据库密码
        String name = "localhost";//数据库ip地址
        String instancename = "SQLEXPRESS";//实例名称

        //实例连接方式
        //如果式默认实例则不需要加实例名，直接这样jdbc:sqlserver://localhost;databaseName=mydb;user=sa;password=sa
        //https://bbs.csdn.net/topics/392190826
        String url = "jdbc:sqlserver://"+name +"instanceName="+instancename+
                ";databaseName="+DataBaseName+
                ";user="+user+";password="+Psd;//sa身份连接

        //数据库端口连接方式
//        String url = "jdbc:sqlserver://"+ name +":1433;databaseName="+DataBaseName+
//                ";user="+user+";password="+Psd;//sa身份连接

        // Declare the JDBC objects.
        try {
            // Establish the connection.
            System.out.println("begin.");
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            System.out.println(url);
            Connection conn = DriverManager.getConnection(url);
            System.out.println("数据库连接成功！！！");
            System.out.println("end.");

            Statement stmt = null;
            ResultSet rs = null;

            // Create and execute an SQL statement that returns some data.
            String SQL = "SELECT  * FROM [Real]";
            stmt = conn.createStatement();
            rs = stmt.executeQuery(SQL);


            // Iterate through the data in the result set and display it.
            while (rs.next()) {
//                System.out.println("时间+" + rs.getTime(1));
//                java.util.Date date;
//                System.out.println("日期 +" + (date = rs.getDate(1)));
//                SimpleDateFormat format0 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//                System.out.println("first:" + format0.format(date.getTime()));
//                String timeStr = rs.getString(1);
//                java.util.Date sene =  format0.parse(timeStr);
//                System.out.println("second:" + format0.format(sene.getTime()));

                System.out.println(rs.getString(1) + " " + rs.getString(2));
            }

            conn.close();

        }
        catch (Exception e) {
            e.printStackTrace();
        }
    }
}

//

 

1

package com.xrom.ssh.test;

2

3

import java.sql.*;

4

import java.text.SimpleDateFormat;

5

6

/**

7

 * 测试sql server 数据库是否能连接

8

 * Created by bill xu on 2019/1/31.

9

 */

10

public class TestConn {

11

    public static void main(String[] args) {

12

13

        String DataBaseName = "mydb";//数据库名称

14

        String user = "sa";  //数据库用户名

15

        String Psd = "sa";    //数据库密码

16

        String name = "localhost";//数据库ip地址

17

        String instancename = "SQLEXPRESS";//实例名称

18

19

        //实例连接方式

20

        //如果式默认实例则不需要加实例名，直接这样jdbc:sqlserver://localhost;databaseName=mydb;user=sa;password=sa

21

        //https://bbs.csdn.net/topics/392190826

22

        String url = "jdbc:sqlserver://"+name +"instanceName="+instancename+

23

                ";databaseName="+DataBaseName+

24

                ";user="+user+";password="+Psd;//sa身份连接

25

26

        //数据库端口连接方式

27

//        String url = "jdbc:sqlserver://"+ name +":1433;databaseName="+DataBaseName+

28

//                ";user="+user+";password="+Psd;//sa身份连接

29

30

        // Declare the JDBC objects.

31

        try {

32

            // Establish the connection.

33

            System.out.println("begin.");

34

            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

35

            System.out.println(url);

36

            Connection conn = DriverManager.getConnection(url);

37

            System.out.println("数据库连接成功！！！");

38

            System.out.println("end.");

39

40

            Statement stmt = null;

41

            ResultSet rs = null;

42

43

            // Create and execute an SQL statement that returns some data.

44

            String SQL = "SELECT  * FROM [Real]";

45

            stmt = conn.createStatement();

46

            rs = stmt.executeQuery(SQL);

47

48

49

            // Iterate through the data in the result set and display it.

50

            while (rs.next()) {

51

//                System.out.println("时间+" + rs.getTime(1));

52

//                java.util.Date date;

53

//                System.out.println("日期 +" + (date = rs.getDate(1)));

54

//                SimpleDateFormat format0 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

55

//                System.out.println("first:" + format0.format(date.getTime()));

56

//                String timeStr = rs.getString(1);

57

//                java.util.Date sene =  format0.parse(timeStr);

58

//                System.out.println("second:" + format0.format(sene.getTime()));

59

60

                System.out.println(rs.getString(1) + " " + rs.getString(2));

61

            }

62

63

            conn.close();

64

65

        }

66

        catch (Exception e) {

67

            e.printStackTrace();

68

        }

69

    }

70

}

71

来自为知笔记(Wiz)

转载于:https://www.cnblogs.com/billxxx/p/10588008.html