import java.sql.*;

public class test {
public static void main(String []args){

String jdbc=”com.microsoft.jdbc.sqlserver.SQLServerDriver”;
String conUrl=”jdbc:sqlserver://192.168.0.100:1433;databaseName=test”;
String user=”sa”;
String pwd=””;
try{
Class.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver”);
}
catch(java.lang.ClassNotFoundException e){
System.out.print(“ForName:”+e.getMessage());
}
try{
Connection con=DriverManager.getConnection(conUrl,user,pwd);
Statement s=con.createStatement();
String query=”select * from table01”;
ResultSet rs=s.executeQuery(query);
while(rs.next()){
System.out.println(rs.getString(“id”)+rs.getString(“name”));
}

}
catch(SQLException e){
System.out.print(“SQLException:”+e.getMessage());
}

}
}