Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Unhandled exception type SQLException
at JavaName.main(JavaName.java:)
安裝jdk
vscode設定中java.Home加入如下:
"java.home": "/Library/Java/JavaVirtualMachines/jdk1.8.0_211.jdk/Contents/Home"
private static final String Connurl = "jdbc:sqlserver:%s; databaseName=%s";
private static final String HostName = "//*****:1433";
private static final String DatabaseName = "*****";
private static final String UserName = "*****";
private static final String PassWord = "*****";
private static Connection conn;
public static void main(String[] args) throws Exception{
query();
}
public static Connection DBConnect(){
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection(String.format(Connurl, HostName, DatabaseName), UserName, PassWord);
} catch (ClassNotFoundException e) {
System.out.println("資料庫連接時發生了：ClassNotFoundException！");
e.printStackTrace();
} catch (Exception ex) {
System.out.println("Error: " + ex);
}
return conn;
}
//查詢
public static void query() throws Exception{
Connection con = getConnection();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from TabelName");
// 如果物件中有資料，就會迴圈打印出來
while (rs.next()){
System.out.println(rs.getString("FieldName"));
}
rs.close();
stmt.close();
conn.close();
}