java连接sqlserver2005数据库

//javabean 中连接sqlserver2005数据库，在jsp,servlet中方法相同。

String strout="<table border=/"2/">";
  try{
   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
   String url="jdbc:sqlserver://localhost:1433;DatabaseName=PesonalInfoMgr";
   String user="sa";
   String password="";
   Connection con=DriverManager.getConnection(url,user,password);
   Statement stmt=con.createStatement();
   String query="select * from UsualInfo";
   ResultSet rs=stmt.executeQuery(query);
   ResultSetMetaData rsmd=rs.getMetaData();
   int numCols=rsmd.getColumnCount();
   strout=strout+"<tr>";
   for(int i=1;i<numCols;i++)
   {
    strout=strout+"<td>"+rsmd.getColumnLabel(i)+"</td>";
   }
     strout=strout+"</tr>";
   boolean more=rs.next();
   while(more)
   {
    strout=strout+"<tr>";
    for(int i=1;i<numCols;i++){
     strout=strout+"<td>"+rs.getString(i)+"</td>";
    }
    strout=strout+"</tr>";
    more=rs.next();
   }
   strout=strout+"</table>";
  }
  catch(Exception ex){
   strout+=ex.toString();
  }
  return strout;