我在线程“main”java中遇到一个异常。sql。执行JDBC程序时发生SQLException
这是我的密码
import java.sql.*;
import java.util.Scanner;
class AccountDeletionApplication
{
public static void main(String[] args) throws ClassNotFoundException,SQLException
{
Scanner s=new Scanner(System.in);
System.out.println("Enter the Acc no:");
int ano=s.nextInt();
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","scott","tiger");
Statement st=con.createStatement();
int n=st.executeUpdate("delete from ACCOUNT1 where ACCNO="+ano);
if(n==1)
System.out.println("account deleted succesfully");
else
System.out.println("account doesnt exist");
st.close();
con.close();
}
}
# 1 楼答案
请发布整个堆栈跟踪,但很可能您的驱动程序不在类路径上。它不附带JVM。转到here下载它,并将其添加到类路径中