sqlserver2012 连接测试

package sqlserver2012;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;


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


{

System.out.println("---------------");

String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
        // HACT_MESDB
 String dbURL="jdbc:sqlserver://10.124.161.10:1433";


 String userName="***";


 String userPwd="***";




try


 {


  Class.forName(driverName);


  Connection dbConn=DriverManager.getConnection(dbURL,userName,userPwd);


   System.out.println("连接数据库成功");

   PreparedStatement pst = null; 
   try {  
     pst = dbConn.prepareStatement("select * from ITMSIBXSTS "); 
     ResultSetMetaData rsd = pst.executeQuery().getMetaData(); 
     List<String > colList =new ArrayList<String>();
     for(int i = 0; i < rsd.getColumnCount(); i++) { 
       System.out.print("java类型："+rsd.getColumnClassName(i + 1)); 
       System.out.print(" 数据库类型:"+rsd.getColumnTypeName(i + 1)); 
       System.out.print(" 字段名称:"+rsd.getColumnName(i + 1)); 
       System.out.print(" 字段长度:"+rsd.getColumnDisplaySize(i + 1)); 
       colList.add(rsd.getColumnName(i + 1));
       System.out.println(); 

     }  
     for (String str : colList) {
System.out.print(""+str+" ");
}
        System.out.println(); 
     pst = dbConn.prepareStatement("select * from ITMSIBXSTS "); 
     ResultSet rs =pst. executeQuery();
     while(rs.next()) {
     for (String col : colList) {
     System.out.print(rs.getString(col)+" ");
}
     System.out.println();

     }

   } finally {  
     try {  
       pst.close(); 
       pst = null; 
     } catch(SQLException e) {  
       throw new RuntimeException(e); 
     }  
   } 


 }


 catch(Exception e)


 {


  e.printStackTrace();


  System.out.print("连接失败");


 }    

}
}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!