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