sqlserverpopulator.java

SQLServerPopulator is the Demo which using the class of DriverManagerConnectionProvider to connect D

/*
 * SQLServerPopulator.java Created on 2004-12-6 
 */
package com.darkblue.db;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

public class SQLServerPopulator {

    public static void main(String[] args) {
        DriverManagerConnectionProvider driv=new DriverManagerConnectionProvider();
        try {
            String sql="SELECT firstname,lastname,title FROM Employees";
            driv.configure( "com.microsoft.jdbc.sqlserver.SQLServerDriver",
                            "jdbc:Microsoft:sqlserver://192.168.70.94:1433;DatabaseName=Northwind",
                            "sa", "sa");
            Connection conn = driv.getConnection();
            
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery(sql);
            while(rs.next()){
                String firstname = rs.getString(1);
                String dname = rs.getString(2);
                String title = rs.getString(3);
                System.out.print(" name " + firstname+"." +dname);
                System.out.println(" , title " + title);
            }
        } catch (Exception e) {
            e.printStackTrace();
            // TODO: handle exception
        }
    }
}