private void seach()
{
Statement ps;
ResultSet rs;
Connection con;
String url;
String query="select * from us";
try
{
//连接数据库
String name = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jyb;";
Class.forName(name);
con = DriverManager.getConnection(url, "sa", "");
ps = con.createStatement();
rs = ps.executeQuery(query);
displayResultSet( rs );
}
catch ( SQLException sqlex )
{
sqlex.printStackTrace();
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
}
{
Statement ps;
ResultSet rs;
Connection con;
String url;
String query="select * from us";
try
{
//连接数据库
String name = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jyb;";
Class.forName(name);
con = DriverManager.getConnection(url, "sa", "");
ps = con.createStatement();
rs = ps.executeQuery(query);
displayResultSet( rs );
}
catch ( SQLException sqlex )
{
sqlex.printStackTrace();
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
}
throws SQLException
{
boolean moreRecords = rs.next();
if ( ! moreRecords )
{
JOptionPane.showMessageDialog(null, "无记录);
return;
}
Vector columnHeads = new Vector();
Vector rows = new Vector();
try
{
ResultSetMetaData rsmd = rs.getMetaData();
for ( int i = 1; i <= rsmd.getColumnCount(); i++)
columnHeads.addElement( rsmd.getColumnName( i ) );
do
{
rows.addElement( getNextRow( rs, rsmd ) );
} while ( rs.next() );
JTable jTable= new JTable( rows, columnHeads );
jTable.validate();
}
catch ( SQLException sqlex )
{
sqlex.printStackTrace();
}
}
{
Vector currentRow = new Vector();
try
{
for ( int i = 1; i <= rsmd.getColumnCount(); i++ )
currentRow.addElement( rs.getString( i ) );
}
catch (SQLException e)
{
e.printStackTrace();
}
}
我去你说的论坛去了。那个JM是什么东东啊。上面怎么没有介绍性的文档?