//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;