我知道这可能是一个重复的问题,已经有人在这里发布过类似的问题了。抱歉。以下是我编写的数据库连接代码:
try{
Class.forName("org.postgresql.Driver");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
try{
String URL = "jdbc:posgresql://localhost:5432/postgres";
String USER = "postgres";
String PASS = "postgres";
Connection conn = DriverManager.getConnection(URL, USER, PASS);
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("Select * from employee");
while(rs.next()){
System.out.println(rs.getString(1));
}
}
catch(SQLException es){
es.printStackTrace();
}
在运行这段代码时,我遇到了以下异常:
java.sql.SQLException: No suitable driver found for jdbc:posgresql://localhost:5432/postgres
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at ManageEmployee.main(ManageEmployee.java:60)
我已经在Eclipse中构建了这个项目,并添加了Postgres的外部jar包。
如果有帮助,以下是.classpath文件:
<?xml version="1.0" encoding="UTF-8"?>
<classpath>
<classpathentry kind="src" path="src"/>
<classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER/org.eclipse.jdt.internal.debug.ui.launcher.StandardVMType/JavaSE-1.6">
<attributes>
<attribute name="owner.project.facets" value="java"/>
</attributes>
</classpathentry>
<classpathentry kind="con" path="org.eclipse.jst.j2ee.internal.web.container"/>
<classpathentry kind="con" path="org.eclipse.jst.j2ee.internal.module.container"/>
<classpathentry kind="lib" path="//10.202.6.95/kavitha_share/jars/postgresql-8.2-504.jdbc2ee.jar"/>
<classpathentry kind="output" path="build/classes"/>
</classpath>
我已经添加了jar文件,可能的原因是什么?