亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全,請及時綁定郵箱和手機立即綁定

麻煩各位大神幫我看看,我在查詢單個女神為啥老是報下面的異常?

Exception in thread "main" 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 '=1' at line 1

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

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

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

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

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

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

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)

at com.imooc.dao.GoddessDao.get(GoddessDao.java:96)

at com.imooc.action.GoddessAction.main(GoddessAction.java:35)


package com.imooc.action;


import java.util.Date;

import java.util.List;


import com.imooc.dao.GoddessDao;

import com.imooc.model.Goddess;


public class GoddessAction {

? ? ?public static void main(String[] args) throws Exception {

GoddessDao g=new GoddessDao();


/** List<Goddess> gs=g.query();

for (Goddess goddess : gs) {

System.out.println(goddess.getUser_name()+","+goddess.getAge());

}

**/

// Goddess g1=new Goddess();

//

// g1.setUser_name("小夏");

// g1.setAge(22);

// g1.setSex(1);

// g1.setBirthday(new Date());

// g1.setEmail("[email protected]");

// g1.setMobile("18766123456");

// g1.setCreate_user("ADMIN");

// g1.setUpdate_user("ADMIN");

// g1.setIsdel(1);

// g1.setId(4);

// g.addGoddess(g1);

// g.updateGoddess(g1);

// g.delGoddess(3);

Goddess g2=g.get(1);

System.out.println(g2.toString());

}

?}


正在回答

1 回答

不好意思,太粗心了,原來是空格的問題,原因是“select * from imooc_goddesswhere id=?”,imooc_goddesswhere這兩沒有空格連在一起啦

0 回復 有任何疑惑可以回復我~

舉報

0/150
提交
取消

麻煩各位大神幫我看看,我在查詢單個女神為啥老是報下面的異常?

我要回答 關注問題
微信客服

購課補貼
聯系客服咨詢優惠詳情

幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

公眾號

掃描二維碼
關注慕課網微信公眾號