javabean 的 sql字符串的问题

Question

insert into msg(nickName,qq,email,content,msgType) values('this.nickName+"','"this.qq+"','"this.email+"','"this.content+"',"this.msgType+")看看你这语句连成一块了,是不是有点错误!
提示:这种SQL语句,一般出错之后把它复制到SQLserver里面把对应的值改一下.看正不正确.

Answer 1

这个类本身少一个}啊，this.msgType这个少一个''

Answer 2

insert into msg(nickName,qq,email,content,msgType) values('"+this.nickName+"','"+this.qq+"','"+this.email+"','"+this.content+"','"+this.msgType+"')给你改了一下,正确的语法.
注:当变量为int型的时候就不能写'"+this.nickName+"'..要写"+ this.nickName +"

Answer 3

private int msgId;
private String nickName;
private String qq;
private String email;
private String content;
private String reContent;
private String msgType;
private int headImg;

public boolean newMsg(){
boolean flag=false;
StringBuffer str=new StringBuffer();
str.append("insert into msg(nickName,qq,email,content,msgType)");
str.append(" values('");
str.append(this.nickName+"','");
str.append(this.qq+"','");
str.append(this.email+"','");
str.append(this.content+"','");
str.append(this.msgType+"')");

this.doExecuteSql(str.toString());
return flag;
}改成样后，nickName列名无效，又是新问题，各位高手，再帮我看看

Answer 4

str.append(this.content+"',");
str.append(this.msgType+")");确认一下msgType是什么类型,int?
System.out.println(msgType==null||msgType.equals(""));

Answer 5

private String msgType;是字符形的

Answer 6

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]列名 'nickName' 无效。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeUpdate(Unknown Source)
at db.DBBasic.doExecuteSql(DBBasic.java:60)
at db.MsgManage.newMsg(MsgManage.java:25)
at org.apache.jsp.insert_005fdo_jsp._jspService(insert_005fdo_jsp.java:60)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:833)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:639)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)
at java.lang.Thread.run(Thread.java:595)给的错误提示