我需要在java中为postresql添加值,

Question

所有功能都在工作，只有添加才是问题

java trowing异常：

public class Maintest {

/**
 * @param args
 */
public static void main(String[] args) {
    // TODO Auto-generated method stub
    DBConnector dbConn = DBConnector.getInstance();
    ArrayList<Project> projects = dbConn.qSelect(null);
    for(int i=0; i<projects.size(); i++){

        System.out.println(projects.get(i).getId());
    }
    Project newProject = new Project();
    double kkk=3;
    newProject.setId(new Integer(10011));
    newProject.setName("newName");
    newProject.setOt_collection_id("newOtCollectionId");
    newProject.setDoi("newDoi");
    newProject.setAka("newAka");
    newProject.setCollection_platform("newCollectionPlatform");
    newProject.setDataset_overwiew("newDatasetOverwiew");
    newProject.setDataset_acknowledgement("newDatasetAcknowledgement");
    newProject.setKeywords("newKeywords");
    newProject.setFunder("newFunder");
    newProject.setCollector("newCollector");
    newProject.setArea(kkk);
    newProject.setPoint_density(kkk);
    newProject.setX_coordinate(kkk);
    newProject.setY_coordinate(kkk);
    newProject.setCoordinates_system("newCoordinatesSystem");
    newProject.setLink_truview("newLinkTruView");
    newProject.setSurvey_date("newSurveyDate");
    newProject.setTotal_lidar_returns("newTotalLidarReturns");
    newProject.setImage("none.jpg");
    dbConn.addProject(newProject);
}

下面是dbconnector类：

public class DBConnector {

private Connection c = null;
private Statement stmt = null;

private static DBConnector me = null;

public static DBConnector getInstance() {
    if (me == null)
        me = new DBConnector();

    return me;
}

private DBConnector() {
    c = null;
    try {
        Class.forName("org.postgresql.Driver");
        c = DriverManager.getConnection(
                "jdbc:postgresql://localhost:5432/postgres", "postgres",
                "pass");
        c.setAutoCommit(false);
        stmt = c.createStatement();
    } catch (Exception e) {
        e.printStackTrace();
        System.err.println(e.getClass().getName() + ": " + e.getMessage());
        System.exit(0);
    }
    System.out.println("Opened database successfully");
}

public void deleteProject(Integer id) {

    String sql = "DELETE from DIPLOMSKI_PROJEKTI where ID=" + id.toString()
            + ";";

    try {
        stmt.executeUpdate(sql);
        c.commit();
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

}

public void addProject(Project proj) {
    String sql = "INSERT INTO DIPLOMSKI_PROJEKTI (ID,NAME,OT_COLLECTION_ID,DOI,AKA,COLLECTION_PLATFORM,DATASET_OVERWIEW,DATASET_ACKNOWLEDGEMENT,KEYWORDS,FUNDER,COLLECTOR,AREA(KM2),POINT_DENSITY(PTS_PER_M2),X_COORDINATE,Y_COORDINATE,COORDINATES_SYSTEM,LINK_TRUVIEW,IMAGE,SURVEY_DATE,TOTAL_LIDAR_RETURNS(PTS)) "
            + "VALUES ("
            + proj.getId()
            + ",'"
            + proj.getName()
            + "','"
            + proj.getOt_collection_id()
            + "','"
            + proj.getDoi()
            + "','"
            + proj.getAka()
            + "','"
            + proj.getCollection_platform()
            + "','"
            + proj.getDataset_overwiew()
            + "','"
            + proj.getDataset_acknowledgement()
            + "','"
            + proj.getKeywords()
            + "','"
            + proj.getFunder()
            + "','"
            + proj.getCollector()
            + "',"
            + proj.getArea()
            + ","
            + proj.getPoint_density()
            + ","
            + proj.getX_coordinate()
            + ","
            + proj.getY_coordinate()
            + ",'"
            + proj.getCoordinates_system()
            + "','"
            + proj.getLink_truview()
            + "','"
            + proj.getImage()
            + "','"
            + proj.getSurvey_date()
            + "','"
            + proj.getTotal_lidar_returns() + "');";
    System.out.println("PUKAO1");

    try {
        System.out.println("PUKAO2");
        stmt.executeUpdate(sql);
        c.commit();
    } catch (SQLException e) {
        System.out.println("PUKAO3");
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
}

public ArrayList<Project> qSelect(String strQuery) {
    Statement stmt = null;
    ArrayList<Project> projects = new ArrayList<Project>();

    Project project_temp = null;

    try {
        stmt = c.createStatement();

        ResultSet rs = stmt
                .executeQuery("SELECT * FROM DIPLOMSKI_PROJEKTI;");
        while (rs.next()) {
            Integer id = rs.getInt("id");
            String name = rs.getString("name");
            String ot_collection_id = rs.getString("ot_collection_id");
            String doi = rs.getString("doi");
            String aka = rs.getString("aka");
            String collection_platform = rs
                    .getString("collection_platform");
            String dataset_overwiew = rs.getString("dataset_overwiew");
            String dataset_acknowledgement = rs
                    .getString("dataset_acknowledgement");
            String keywords = rs.getString("keywords");
            String survey_date = rs.getString("survey_date");
            String funder = rs.getString("funder");
            String collector = rs.getString("collector");
            String total_lidar_returns = rs
                    .getString("total_lidar_returns(pts)");
            double point_density = rs
                    .getDouble("point_density(pts_per_m2)");
            double area = rs.getDouble("area(km2)");
            double x_coordinate = rs.getDouble("x_coordinate");
            double y_coordinate = rs.getDouble("y_coordinate");
            String coordinates_system = rs.getString("coordinates_system");
            String link_truview = rs.getString("link_truview");
            String image = rs.getString("image");

            project_temp = new Project();

            project_temp.setId(id);
            project_temp.setName(name);
            project_temp.setOt_collection_id(ot_collection_id);
            project_temp.setDoi(doi);
            project_temp.setAka(aka);
            project_temp.setCollection_platform(collection_platform);
            project_temp.setDataset_overwiew(dataset_overwiew);
            project_temp.setDataset_acknowledgement(dataset_acknowledgement);
            project_temp.setKeywords(keywords);
            project_temp.setSurvey_date(survey_date);
            project_temp.setFunder(funder);
            project_temp.setCollector(collector);
            project_temp.setCollection_platform(collection_platform);
            project_temp.setTotal_lidar_returns(total_lidar_returns);
            project_temp.setArea(area);
            project_temp.setPoint_density(point_density);
            project_temp.setX_coordinate(x_coordinate);
            project_temp.setY_coordinate(y_coordinate);
            project_temp.setCoordinates_system(coordinates_system);
            project_temp.setLink_truview(link_truview);
            project_temp.setImage(image);

            projects.add(project_temp);

        }
        rs.close();
        stmt.close();
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    return projects;
}

public boolean projectExist(Integer id) {
    DBConnector dbConn = DBConnector.getInstance();
    ArrayList<Project> projects = dbConn.qSelect(null);
    for (int i = 0; i < projects.size(); i++) {
        if (projects.get(i).getId() == id)
            return true;
    }
    return false;
}

public Project returnProject(Integer id) {
    DBConnector dbConn = DBConnector.getInstance();
    ArrayList<Project> projects = dbConn.qSelect(null);
    for (int i = 0; i < projects.size(); i++)
        if (projects.get(i).getId() == id)
            return projects.get(i);

    return null;
}

}

Answer 1

由于异常说明，您不能在insert SQL语句中使用“（”符号作为列列表的一部分（即area(KM2)、POINT_DENSITY(PTS_PER_M2))。