java 均值插值_java往数据库里插值的问题 急用

我的表CREATETABLE`user`(`id`int(11)NOTNULLauto_increment,`email`varchar(50)defaultNULL,`password`varchar(20)defaultNULL,`realname`varchar(20)defaultNULL,`sex`varchar(4)de...

我的表

CREATE TABLE `user` (

`id` int(11) NOT NULL auto_increment,

`email` varchar(50) default NULL,

`password` varchar(20) default NULL,

`realname` varchar(20) default NULL,

`sex` varchar(4) default NULL,

`birthday` date default NULL,

`education` varchar(20) default NULL,

`jobcategory` varchar(20) default NULL,

`phone` int(11) default NULL,

`post` int(11) default NULL,

`address` varchar(20) default NULL,

`right` int(4) default NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

我写的程序

//添加用户

public int addUser(String email,String password,String realname,String sex,String birthday,String education,String jobcategory,int phone,int post,String address) {

String sql="insert into user(email,password,realname,sex,birthday,education,jobcategory,phone,post,address,right)values(?,?,?,?,?,?,?,?,?,?,?)";

Connection conn=DBConnection.getConnection();

PreparedStatement pstmt=null;

int i = 0;

try {

pstmt = conn.prepareStatement(sql);

pstmt.setString(1, email);

pstmt.setString(2, password);

pstmt.setString(3, realname);

pstmt.setString(4, sex);

pstmt.setDate(5,Date.valueOf(birthday) );

pstmt.setString(6, education);

pstmt.setString(7, jobcategory);

pstmt.setInt(8, phone);

pstmt.setInt(9, post);

pstmt.setString(10, address);

pstmt.setInt(11,1);

i = pstmt.executeUpdate();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally

{

DBConnection.close(pstmt);

DBConnection.close(conn);

}

return i;

}

提示的错误

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'right)values('s','a','s','s','1986-05-01','s','s',1,1,'a',1)' at line 1

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2822)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1536)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1626)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3031)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:943)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1184)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1101)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1086)

at com.chen.denglu.impl.UserImpl.addUser(UserImpl.java:35)

at test.Test.main(Test.java:30)

各位高手哥哥姐姐们 帮忙研究一下吧 急用

展开