数据库连接出错怎么回事啊?
package mydata;
import java.sql.*;
import java.lang.*;
public class jdbcDemo {
public static void main(String[] args)
{
String zbdh;
String sm;
String zz;
int sl;
String sql="select zbdh,sm,zz,sl from book";
//String jdbcora="oracle.jdbc.driver.OracleDriver";
String jdbcora="jdbc.oracle.driver.OracleDriver";
// String url="jdbc:oracle:thin:@jacked:1521:oradb";
// Class.forName(jdbcora);
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance() ;
Connection conn= DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:oradb","xuf","xuf");
// Connection conn= DriverManager.getConnection("jdbc:oracle:thin@jacked:1521:oradb","xuf","xuf");
Statement stmt=conn.createStatement() ;
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
zbdh=rs.getString("zbdh");
sm=rs.getString("sm");
zz=rs.getString(3);
sl=rs.getInt("sl");
System.out.println("zbdh"+zbdh+"\t"+"sm+"+sm+"\t"+"zz"+zz+"\t"+"sl"+sl);
}
}
}
我是在jbuilder里面编译的,请问:
1.措施提示是"jdbcDemo.java": Error #: 302 : cannot access class oracle.jdbc.driver; java.io.IOException: class not found: class oracle.jdbc.driver at line 16, column 29
怎么解决?
2.这是一个有主函数的class,我需要什么样的执行环境啊?直接在jbuilder里执行可以么?我需要设置些什么呢