try {
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundException ex) {
System.out.print("*** ClassNotFoundException: ");
System.out.println(ex.getMessage());
}
try {
String url="jdbc:oracle:thin:@zxl:1521:test";
//orcl为你的数据库的SID
String user="cpsc";
String password="cpsc";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
System.out.print("您的第一个字段内容为");
System.out.print(rs.getString(1));
}
out.print("数据库操作成功,恭喜你");%>
rs.close();
stmt.close();
conn.close();
}catch(SQLException ex) {
System.out.println(ex.getMessage());
}
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundException ex) {
System.out.print("*** ClassNotFoundException: ");
System.out.println(ex.getMessage());
}
try {
String url="jdbc:oracle:thin:@zxl:1521:test";
//orcl为你的数据库的SID
String user="cpsc";
String password="cpsc";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
System.out.print("您的第一个字段内容为");
System.out.print(rs.getString(1));
}
out.print("数据库操作成功,恭喜你");%>
rs.close();
stmt.close();
conn.close();
}catch(SQLException ex) {
System.out.println(ex.getMessage());
}
try{
//这里写你的代码
}
catch(Exception e){
//异常处理
}
里面
jdbc的驱动就怎么指定指定在classpath中。
但还是出错,就怎么解决那