关于网友提出的“ javasqlSQLException: No suitable driver found for oracle:jdbc:thin:”问题疑问,本网通过在网上对“ javasqlSQLException: No suitable driver found for oracle:jdbc:thin:”有关的相关答案进行了整理,供用户进行参考,详细问题解答如下:
问题: javasqlSQLException: No suitable driver found for oracle:jdbc:thin:描述:
用java访问数据库,出现java.sql.SQLException: No suitable driver found for oracle:jdbc:thin:的异常。
代码如下:
//连接oracle
Class.forName("oracle.jdbc.driver.OracleDriver");
//DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
String url = "jdbc:oracle:thin:@172.16.16.37:1521:chenjie";
String users = "system";
String password = "chenjie";
ct = DriverManager.getConnection(url, users, password);
//查询数据库,看看用户名存不存在,若存在则将返回的密码与用户输入的密码进行比较
smt = ct.createStatement(); //创建Statement对象
rs = smt.executeQuery("select password from users where name =" + uname);
if(rs.next()){
String pwd = rs.getString("password");
if(upwd.equals(pwd)){
hsRes.sendRedirect("welcome?u="+ uname +"&p=" + upwd);
}else{
hsRes.sendRedirect("login");
}
}else{
hsRes.sendRedirect("login");
}
//关闭
if(rs != null){
rs.close();
}
if(smt != null){
smt.close();
}
if(ct != null){
ct.close();
}