Java 串連 Sqlserver

import java.sql.*;
import com.microsoft.sqlserver.jdbc.*;

public class Main {

public static void main(String[] args){
System.out.print("hello world!");

int count = 0;

for(int i=0; i {
count += 1;
}

System.out.print("n"+count);

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

String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
//pubs為你的資料庫的
String user="sa";
String password="";

Connection conn = DriverManager.getConnection(url,user,password);

Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sql="select * from test";

ResultSet rs = stmt.executeQuery(sql);

while(rs.next()) {
System.out.print("n您的第一個欄位內容為："+rs.getString(1));
System.out.print("n您的第二個欄位內容為："+rs.getString(2));
}

System.out.print("資料庫操作成功，恭喜你");

rs.close();

stmt.close();

conn.close();
*/
// Declare the JDBC objects.
Connection con = null;
CallableStatement cstmt = null;
ResultSet rs = null;

try {
// Establish the connection.
SQLServerDataSource ds = new SQLServerDataSource();
ds.setUser("sa");
ds.setPassword("ruanyu");
ds.setServerName("HOME\Sqlexpress");
ds.setPortNumber(1433);
ds.setDatabaseName("AdventureWorks");
con = ds.getConnection();

// Execute a stored procedure that returns some data.
cstmt = con.prepareCall("{call dbo.uspGetEmployeeManagers(1)}");
//cstmt.setInt(1,10);
rs = cstmt.executeQuery();

// Iterate through the data in the result set and display it.
while (rs.next()) {
System.out.println("EMPLOYEE: " + rs.getString("LastName") +
", " + rs.getString("FirstName"));
System.out.println("MANAGER: " + rs.getString("ManagerLastName") +
", " + rs.getString("ManagerFirstName"));
System.out.println();
}
}

// Handle any errors that may have occurred.
catch (Exception e) {
e.printStackTrace();
}
finally {
if (rs != null) try { rs.close(); } catch(Exception e) {}
if (cstmt != null) try { cstmt.close(); } catch(Exception e) {}
if (con != null) try { con.close(); } catch(Exception e) {}
System.exit(1);
}
}
}