Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.1k views
in Technique[技术] by (71.8m points)

jdbc - java.sql.SQLException: Column count doesn't match value count at row 1

The structure of my table:

id int AUTO_INCREMENT PRIMARY KEY
title text
url text
age int

Here's how I am trying to save data into this table:

PreparedStatement ps=con.prepareStatement("insert into table(title, url, age) values ('"+title+","+url+","+age+"')");
System.out.println("Connected database successfully..");
ps.executeUpdate(); 

But when I run the app, I get

java.sql.SQLException: Column count doesn't match value count at row 1

I guess the problem might be in the id column, how to solve it?

Question&Answers:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

The problem is not the id column.

From the statement it looks like you have quotes around all columns. Therefore it seems to the SQL, that you have only one column

'"title","url","age"'

What you might want to have is

"insert into table(title, url, age) values ('" + title + "','" + url + "'," + age + ")"

or even better yet, since it is a prepared statement

"insert into table(title, url, age) values (?, ?, ?)"

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...