package sjk;
import java.sql.*;
public class sjkText {
public static void main(String[] args) {
Connection ct=null;
Statement sm=null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
ct=DriverManager.getConnection("jdbc:odbc:sql server","sa","Aa123456");
sm=ct.createStatement();
ResultSet rs=sm.executeQuery("select xinming,nianling,zhiwei from renwu2");
while(rs.next()){
String xinming=rs.getNString(1);
int nianling=rs.getInt(2);
String zhiwei=rs.getString(3);
System.out.println(xinming+" "+nianling+" "+zhiwei);
}
} catch (Exception e) {
}finally{
try{
if(sm!=null){sm.close();}
if(ct!=null){ct.close();}
}catch(Exception e2){}
}
}
}