JAVA SQLSERVER資料庫連接

 package cn.ctgu.edu.ac;
import java.sql.*;

public class test {

 /**
  * @param args
  */
 public static void main(String[] args) {
  // TODO Auto-generated method stub
  String url="jdbc:sqlserver://localhost:1433;Database=網上書店管理系統;integratedSecurity=true;"; //用widows身份登入
  String sql="select * from users";
  Connection conn=null;
  try
  {
   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
   conn=DriverManager.getConnection(url);
   Statement state=conn.createStatement();
   ResultSet rs=state.executeQuery(sql);
   while(rs!=null&&rs.next())
   {
    System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+" "+rs.getString(6));
    
   }
   conn.close();

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