100分求解程序，急

[pbnow]

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class test {

public static void main(String[] args) {
String dburl = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=myjob";
String user = "sa";
String pws = "";
Connection conn = null;//why must be initialized as null
Statement stmt = null;
ResultSet rs;

try {
Class.forName("com.microsoft.jdbc.sqlserver.SqlServerDriver");
conn = DriverManager.getConnection(dburl,user,pws);
stmt = conn.createStatement();
}
catch(java.lang.ClassNotFoundException e)
{ System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
catch(SQLException ex)
{ System.err.println("SQLException: " + ex.getMessage() );
}

String query = "select * from t_sudent";
rs = stmt.executeQuery(query);
while (rs.next())
{
System.out.println(rs.getString("st_name"));
}
stmt.close();
conn.close();
}
}

载jbuilder中，提示以下几行出错，错误一样
rs = stmt.executeQuery(query);
rs.next()；
System.out.println(rs.getString("st_name"));
stmt.close();
conn.close();
unreported Exception:java.sql.SQLException;must be caught or declared to be thrown
但我有catch语句，不只为啥？

question2:
我怎样在jbuilder中将java tutorial中的java文件加入我自己的jpx文件中使其能在jbuilder中运行？
我能在jbuilder中打开但不能运行？

[zez]

rs = stmt.executeQuery(query);
这里要有try catch
你干脆用一个try cathc包含所有程序不得了...

把java源文件按包建路径放在jb你的工程src里即可

[pbnow]

现在可以编译了
但抛出异常
是不是需要安装sqlserver for jdbc的驱动程序？

[yongqi]

String query = "select * from t_sudent";
rs = stmt.executeQuery(query);
while (rs.next())
{
System.out.println(rs.getString("st_name"));
}
stmt.close();
conn.close();

以上这些代码也要放到try catch块里面

[winthan]

String url = "jdbc:odbc:MyDB";
String username = "";
String password = "";
//加载驱动程序以连接数据库
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
connection = DriverManager.getConnection(
url, username, password );
}
//捕获加载驱动程序异常
catch ( ClassNotFoundException cnfex ) {
System.err.println(
"装载 JDBC/ODBC 驱动程序失败。" );
cnfex.printStackTrace();
System.exit( 1 ); // terminate program
}
//捕获连接数据库异常
catch ( SQLException sqlex ) {
System.err.println( "无法连接数据库" );
sqlex.printStackTrace();
System.exit( 1 ); // terminate program
}