Struts2 postgresql找不到适用于jdbc的驱动程序

Question

下面是我的代码：

package org.apache.struts.helloworld.action;

导入com.opensymphony.xwork2.ActionSupport；

导入java.sql.DriverManager；导入java.sql.ResultSet；

private static final long serialVersionUID = 1L;

/**
 * The model class that stores the message
 * to display in the view.
 */
//private MessageStore messageStore;
private String name;

/*
 * Creates the MessageStore model object and 
 * returns success.  The MessageStore model
 * object will be available to the view.
 * (non-Javadoc)
 * @see com.opensymphony.xwork2.ActionSupport#execute()
 */
public String execute() {
    String ret = ERROR;
    java.sql.Connection connection = null;

    try {

        Class.forName("org.postgresql:postgresql:9.4.1207.jre7");
        connection = DriverManager.getConnection("jdbc:postgresql://localhost:5432/postgres", "postgres", "*******");



        java.sql.Statement st = connection.createStatement();

        ResultSet rt = st.executeQuery("SELECT * FROM provider where id=1");


        while (rt.next()) {
            // System.out.println(rt.getString(2));

            name = rt.getString(2);
            ret = SUCCESS;

        }
        rt.close();
        st.close();
    } catch (ClassNotFoundException e) {
    System.out.println("Where is your MySQL JDBC Driver?");
    e.printStackTrace();

} catch (Exception e) {
        System.out.println(e.getStackTrace());
        return ERROR;
    }

    return ret;
}

<dependency>
        <groupId>org.postgresql</groupId>
        <artifactId>postgresql</artifactId>
        <version>9.4.1207.jre7</version>
    </dependency>

附注。我使用Intellij Idea 14.1.4

有人知道原因吗？

Answer 1

PostgreSQL的JDBC驱动程序是org.postgreql.driver，所以

Class.forName("org.postgresql:postgresql:9.4.1207.jre7");

应该是

 Class.forName("org.postgresql.Driver");

虽然由于这是一个JDBC4驱动程序，您应该可以完全删除这个语句...