ganshan.java

来自「core java第二卷源代码第四章。欢迎大家下载」· Java 代码 · 共 47 行

import java.io.*;
import java.sql.*;

public class Ganshan
  {
    public static void main(String args[])
    {
       String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ganshan";
       String user = "sa";
       user.trim();
       String password = "sa";

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

       catch (ClassNotFoundException ce)
       {
		   System.out.println("1-------SQLException:"+ce.getMessage());
       }

       try
      {
        Connection con =
           DriverManager.getConnection
               (url,user,password);

        //Statement stmt = con.createStatement();
        /*
        ResultSet rs=stmt.executeQuery("select * from student");
        while (rs.next())
        {
        System.out.println(
          "1: " + rs.getString(1) + "\t" +
          "2: " + rs.getInt(2) + "\t" +
          "3: " + rs.getString(3) + "\t" 
             );
        }*/
        //stmt.close();
        con.close();
      }
      catch (SQLException e)
      { System.out.println("2--------SQLException:"+e.getMessage()); }
    }
  }