org.postgresql.util.PSQLException: ERROR: column "dsa" does not exist

Question

I am trying to develop a java web app. It is connected to a postgresql database. In this database, I have a table called emp99.In it there is a column called company. when I try to add values to the table I get an error which is:

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [insert into emp99(name,salary,designation,age,surname,department,company,address,working) values('s',1.0,'d',4,'ff',gg,'dd',true )]; nested exception is org.postgresql.util.PSQLException: ERROR: column "gg" does not exist

But I have this column

CREATE TABLE emp99 (
    id int PRIMARY KEY,
    name VARCHAR ( 50 ) ,
    salary float ,
    designation varchar(50),
    age int,
    surname varchar(50),
    department varchar(50),
    company varchar(50),
    address varchar(50),
    working Boolean
);

and this is my adding code:

public int save(Emp p){    
            String sql="insert into emp99(name,salary,designation,age,surname,department,company,address,working) values('"+p.getName()+"',"+p.getSalary()+",'"+p.getDesignation()+"',"+p.getAge()+",'"+p.getSurname()+"',"+p.getCompany()+",'"+p.getAddress()+"',"+p.getWorking()+" )";    
            return template.update(sql);    
        }

Quotes are missing. But you should use parameterized queries anyway. — sticky bit
– sticky bit, Commented Mar 18, 2021 at 15:02
I am new sorry. Can you give a small example about parameterized queries. — alp
– alp, Commented Mar 18, 2021 at 15:13
No. But you can use your favorite search engine, there's plenty on that. — sticky bit
– sticky bit, Commented Mar 18, 2021 at 15:14
Do not concatenate values like that into a SQL query. Use a PreparedStatement mkyong.com/tutorials/jdbc-tutorials — user330315
– user330315, Commented Mar 18, 2021 at 15:19

alp · Accepted Answer · 2021-03-19 05:41:28Z

0

@stiky bit you were right i was missing Quotes. The correct one:

public int save(Employee p){
String sql="insert into emp89(name,salary,surname,departmentname,company,address,working,age,saat) values('"+p.getName()+"','"+p.getSalary()+"','"+p.getSurname()+"','"+p.getDepartmentname()+"','"+p.getCompany()+"','"+p.getAddress()+"','"+p.getWorking()+"','"+p.getAge()+"','"+saat+"')";
return template.update(sql);

answered Mar 19, 2021 at 5:41

alp

131 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

org.postgresql.util.PSQLException: ERROR: column "dsa" does not exist

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related