非常菜的两个问题。有劳各位了
我用java链数据库,但是不能运行:就连forClass,getConnection,等函数执行时都抛出异常,我的程序应该没错,一定是非程序的东西有问题。所以我想问:
(1)用java链数据库时,如何设置jdbc相关内容?
(2)还有一个问题,如何在tomcat5.0下设置虚拟目录?
现将源程序贴在这里,供参考:import java.sql.*;
public class FirstDB{
public static void main(String args[]){
String login="";
String passwd="";
String dburl="jdbc:odbc:friend";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
String query="select ID,name,email,hobby,telephone from book";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection(dburl,login,passwd);
stmt=conn.createStatement();
rs=stmt.executeQuery(query);
while(rs.next())
{
System.out.print(rs.getInt(1));
System.out.print(rs.getString(2));
System.out.print(rs.getString(3));
System.out.print(rs.getString(4));
System.out.print(rs.getString(5));
System.out.print("\n");
}
rs.close();
stmt.close();
conn.close();
}
}