You have not concluded your cherry-pick (CHERRY_PICK_HEAD exists).Please, commit your changes

版权声明:本文为博主原创文章,遵循 CC 4.0 by-sa 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://icode.blog.csdn.net/article/details/98647068
Git 报错

在 IDEA 中使用 Git 报错:

You have not concluded your cherry-pick (CHERRY_PICK_HEAD exists).Please, commit your changes

我使用 git status 命令查看当前状态,也没看出什么问题,

解决方法

使用命令放弃 git cherry-pick 变更

git cherry-pick --abort 

再执行更新或者 pull

git pull
展开阅读全文

You have an error in your SQL syntax; check the manual that corresponds to your

08-07

原语句:rndatas = electricitycharge.daorn .paginate(rn pageNumber,rn pageSize,rn "select * ",rn "from electricitycharge left join room r where r.roomid in (select roomid from room where campus like ? and buildnumber like ? and roomnumber like ? and gzh like ? order by campus asc ,buildnumber asc,roomnumber asc )",rn campus, buildnumber, roomnumber, gzh);rnrn报错:Sql: select count(*) from electricitycharge left join room r where r.roomid in (select roomid from room where campus like ? and buildnumber like ? and roomnumber like ? and gzh like ? order by campus asc ,buildnumber asc,roomnumber asc )rn2014-8-7 15:14:40 com.jfinal.core.ActionHandler errorrn严重: /echarge/echargeList?_=1407395679877rncom.jfinal.plugin.activerecord.ActiveRecordException: com.mysql.jdbc.exceptions.jdbc4.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 'where r.roomid in (select roomid from room where campus like '%' and buildnumber' at line 1rn at com.jfinal.plugin.activerecord.Model.paginate(Model.java:235)rn at cn.jxust.controller.base.EChargeController.echargeList(EChargeController.java:64)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)rn at java.lang.reflect.Method.invoke(Method.java:597)rn at com.jfinal.core.ActionInvocation.invoke(ActionInvocation.java:55)rn at cn.jxust.interceptor.ManagerPowerInterceptor.intercept(ManagerPowerInterceptor.java:44)rn at com.jfinal.core.ActionInvocation.invoke(ActionInvocation.java:51)rn at com.jfinal.core.ActionHandler.handle(ActionHandler.java:73)rn at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:72)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)rn at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)rn at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)rn at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)rn at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)rn at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)rn at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)rn at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)rn at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)rn at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)rn at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)rn at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1822)rn at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)rn at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)rn at java.lang.Thread.run(Thread.java:619)rnCaused by: com.mysql.jdbc.exceptions.jdbc4.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 'where r.roomid in (select roomid from room where campus like '%' and buildnumber' at line 1rn at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)rn at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)rn at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)rn at java.lang.reflect.Constructor.newInstance(Constructor.java:513)rn at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)rn at com.mysql.jdbc.Util.getInstance(Util.java:386)rn at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)rn at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)rn at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)rn at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)rn at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)rn at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683)rn at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144)rn at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2310)rn at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2708)rn at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:465)rn at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2705)rn at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:99)rn at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:182)rn at com.jfinal.plugin.activerecord.Db.query(Db.java:46)rn at com.jfinal.plugin.activerecord.Model.paginate(Model.java:215)rn ... 26 more 论坛

提示:You have an error in your SQL syntax

11-25

[code=Java]rn/**rn * 添加操作记录rn */rn public Statistics saveStatistics(Integer status, List batchProcess) rn Statistics stat = new Statistics();rn Article article = getArticle();rn User user = getLoggedOnUser();rn stat.setType(2);//文章rn stat.setUserId(user.getId());rn Date date = new Date();rn SimpleDateFormat dateformat=new SimpleDateFormat("yyyy-MM-dd");rn dateformat.format(date);rn stat.setStatisticsTime(date);rn if(status != null) rn switch (status) rn case 0://重申rn stat.setDescribe(user.getUsername() + "重申了"+article.getCommUser().getUserName()+"发表的文章" + article.getTitle());rn break;rn case 1://通过rn stat.setDescribe(user.getUsername() +article.getCommUser().getUserName()); //article.getTitle()rn break;rn case 2://屏蔽rn stat.setDescribe(user.getUsername() + "屏蔽了"+article.getCommUser().getUserName()+"发表的文章" + article.getTitle());rn break;rn case 3://删除rn stat.setDescribe(user.getUsername() + "删除了"+article.getCommUser().getUserName()+"发表的文章" + article.getTitle());rn break;rn rn rn if(batchProcess != null) rn stat.setDescribe(user.getUsername() + "处理了"+article.getCommUser().getUserName()+"发表的文章" + article.getTitle());rn rn [color=#FF0000statisticsManager.save(stat);][/color] //这里执行走不了rn this.saveStatisticsDesc(stat,article);rn return stat;rn rn[/code]rnrn错误信息如下:rnrnHibernate: insert into ibokee_statistics (describe, statisticsTime, type, userId) values (?, ?, ?, ?)rnWARN ["http-bio-8080"-exec-9] JDBCExceptionReporter.logExceptions(100) | SQL Error: 1064, SQLState: 42000rnERROR ["http-bio-8080"-exec-9] JDBCExceptionReporter.logExceptions(101) | 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 'describe, statisticsTime, type, userId) values ('adminzhender', '2011-11-25 10:4' at line 1rn 论坛

遇到 You have an error in your SQL syntax

09-04

先说一下,小弟新手,是编写的一个小型SQL数据库查询功能时遇到的问题。rnrn贴一下问题日志:rn九月 04, 2014 1:29:02 上午 org.apache.catalina.core.StandardWrapperValve invokern严重: Servlet.service() for servlet [jsp] in context with path [/J2EEWEB] threw exception [javax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.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 'NAME='123'' at line 1] with root causerncom.mysql.jdbc.exceptions.jdbc4.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 'NAME='123'' at line 1rn at sun.reflect.GeneratedConstructorAccessor12.newInstance(Unknown Source)rn at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)rn at java.lang.reflect.Constructor.newInstance(Constructor.java:526)rn at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)rn at com.mysql.jdbc.Util.getInstance(Util.java:386)rn at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)rn at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)rn at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)rn at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)rn at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)rn at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)rn at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)rn at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)rn at beans.apps.Resultm.search(Resultm.java:25)rn at org.apache.jsp.jsp.result_jsp._jspService(result_jsp.java:74)rn at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)rn at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)rn at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)rn at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)rn at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)rn at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)rn at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)rn at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)rn at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)rn at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)rn at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)rn at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)rn at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)rn at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)rn at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)rn at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)rn at java.lang.Thread.run(Thread.java:744)rn九月 04, 2014 1:31:03 上午 org.apache.catalina.core.StandardWrapperValve invokern严重: Servlet.service() for servlet [jsp] in context with path [/J2EEWEB] threw exception [javax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.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 'NAME='123'' at line 1] with root causerncom.mysql.jdbc.exceptions.jdbc4.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 'NAME='123'' at line 1rn at sun.reflect.GeneratedConstructorAccessor12.newInstance(Unknown Source)rn at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)rn at java.lang.reflect.Constructor.newInstance(Constructor.java:526)rn at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)rn at com.mysql.jdbc.Util.getInstance(Util.java:386)rn at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)rn at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)rn at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)rn at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)rn at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)rn at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)rn at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)rn at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)rn at beans.apps.Resultm.search(Resultm.java:25)rn at org.apache.jsp.jsp.result_jsp._jspService(result_jsp.java:74)rn at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)rn at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)rn at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)rn at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)rn at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)rn at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)rn at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)rn at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)rn at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)rn at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)rn at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)rn at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)rn at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)rn at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)rn at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)rn at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)rn at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)rn at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)rn at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)rn at java.lang.Thread.run(Thread.java:744)rnrnrnrn下面是搜索的类rn[code=javascript]rnpackage beans.apps;rnimport java.sql.*;rnrnimport beans.db.GetStatement;rnrnpublic class Resultm rn private ResultSet rs;rn private String sql;rn private GetStatement ges=new GetStatement();rn public Resultm()rn public ResultSet search(String name,String gender,String t_num) throws ClassNotFoundException, SQLExceptionrn //连接数据库rn sql="select * from sheet where 1=1 ";rn if(!name.equals(""))rn sql=sql+" and NAME like '%"+name+"%'";rn rn if(!gender.equals(""))rn sql=sql+" and SEX='"+gender+"'";rn rn if(!t_num.equals(""))rn sql=sql+" and num like '%"+t_num+"%'";rn rn //以上是sql拼接rn rn rs=ges.getst().executeQuery(sql);rn rn rn return rs;rnrnrn rn rn rn public void closed() throws SQLExceptionrn ges.closeAll();rn rn [/code]rnrn查询SQL中三个关键字内容 NAME SEX numrn我在查询后两个关键字是没有问题的只有NAME报错rn我最不理解的是为什么报错的是'NAME=123' 123是我输入的东西啊。rn希望高手指教rn 论坛

错误代码: 1064 You have an error in your SQL syntax;

08-14

求高手指点 语法哪里有问题啊nnDELIMITER $$nnCREATEn /*[DEFINER = user | CURRENT_USER ]*/n PROCEDURE `x_similarity`.`CovarianceEngine`()n /*LANGUAGE SQLn | [NOT] DETERMINISTICn | CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA n | SQL SECURITY DEFINER | INVOKER n | COMMENT 'string'*/n BEGINn /* 定义变量一 */n DECLARE done, done2 INT DEFAULT 0;n DECLARE stockNo_a VARCHAR(6);n DECLARE coefficient DOUBLE(16,14);n /* 定义光标 */ n DECLARE _Cur CURSOR FOR n SELECT DISTINCT stock_no FROM history_day;n n DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;#错误定义,标记循环结束 n n /* 打开光标 */ n OPEN _Cur; n /* 循环执行 */ n REPEAT n FETCH _Cur INTO stockNo_a; n IF NOT done THEN n BEGINn /* 定义变量一 */ n DECLARE stockNo_b VARCHAR(6);n /* 定义光标 */ n DECLARE _CurInner CURSOR FOR n SELECT DISTINCT stock_no FROM history_day;n OPEN _CurInner;n REPEATn FETCH _CurInner INTO stockNo_b;n IF NOT done2 THENn n SELECTn (n AVG(a. CLOSE * b. CLOSE) - AVG(a. CLOSE) * AVG(b. CLOSE)n ) / SQRT(n (n AVG(a. CLOSE * a. CLOSE) - AVG(a. CLOSE) * AVG(a. CLOSE)n ) * (n AVG(b. CLOSE * b. CLOSE) - AVG(b. CLOSE) * AVG(b. CLOSE)n )n ) INTO coefficientn FROMn history_day a,n history_day bn WHEREn a.date = b.daten AND a.date >= '2015-08-05'n AND a.date <= '2015-08-11'n AND a.stock_no = stockNo_an AND b.stock_no = stockNo_b;nn IF coefficient > 0.5 OR coefficient < -0.5 THENnn INSERT INTO correlationanalysis (stock_no_f, stock_no_r, coefficient) VALUES(stockNo_a, stockNo_b, coefficient);n COMMIT;nn END IF;nn END IF;n UNTIL done2 END REPEAT;n CLOSE _CurInner;n SET done2 = 0;n ENDn END IF;n UNTIL done END REPEAT;n CLOSE _Cur;n END$$nnDELIMITER ;nnn错误代码: 1064nYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END IF;n UNTIL done END REPEAT;n CLOSE _Cur;n END' at line 65 问答

Error Code: 1064 - You have an error in your SQL syntax;

07-11

Query:rn/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */rnrnError occured at:2008-07-11 17:14:38rnLine no.:8rnError Code: 1064 - 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1rnrn数据库代码:rn-- MySQL dump 10.10rn--rn-- Host: localhost Database: studyphprn-- ------------------------------------------------------rn-- Server version 5.0.24-community-ntrnrn/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;rn/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;rn/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;rn/*!40101 SET NAMES utf8 */;rn/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;rn/*!40103 SET TIME_ZONE='+00:00' */;rn/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;rn/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;rn/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;rn/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;rnrn--rn-- Table structure for table `complay`rn--rnrnDROP TABLE IF EXISTS `complay`;rnCREATE TABLE `complay` (rn `item_id` int(11) default NULL,rn `complay` varchar(50) default NULLrn) ENGINE=InnoDB DEFAULT CHARSET=latin1;rnrn--rn-- Dumping data for table `complay`rn--rnrnrn/*!40000 ALTER TABLE `complay` DISABLE KEYS */;rnLOCK TABLES `complay` WRITE;rnINSERT INTO `complay` VALUES (1,'º¼ÖÝÆ·½Ü¿Æ¼¼ÓÐÏÞ¹«Ë¾'),(5,'º¼ÖÝÌ«Ô­¿Æ¼¼ÓÐÏÞ¹«Ë¾'),(12,'ÄϲýÌ쳩¿Æ¼¼ÓÐÏÞ¹«Ë¾'),(123,'Äϲý»ªÏÄÓÐÏÞ¹«Ë¾'),(125,'º¼ÖÝÌìÏ¿Ƽ¼ÓÐÏÞ¹«Ë¾'),(768,'º¼ÖݺìÈտƼ¼ÓÐÏÞ¹«Ë¾'),(56,'º¼ÖÝË®¹ûÅú·¢²¿'),(181,'Ìì½òÒ½Ò©¹«Ë¾ ');rnUNLOCK TABLES;rn/*!40000 ALTER TABLE `complay` ENABLE KEYS */;rnrn--rn-- Table structure for table `people`rn--rnrnDROP TABLE IF EXISTS `people`;rnCREATE TABLE `people` (rn `name` varchar(50) default NULL,rn `age` int(11) default NULL,rn `phone` int(11) default NULLrn) ENGINE=InnoDB DEFAULT CHARSET=latin1;rnrn--rn-- Dumping data for table `people`rn--rnrnrn/*!40000 ALTER TABLE `people` DISABLE KEYS */;rnLOCK TABLES `people` WRITE;rnUNLOCK TABLES;rn/*!40000 ALTER TABLE `people` ENABLE KEYS */;rnrn--rn-- Table structure for table `price`rn--rnrnDROP TABLE IF EXISTS `price`;rnCREATE TABLE `price` (rn `item_id` int(11) default NULL,rn `price` varchar(50) default NULL,rn `content` varchar(50) default NULLrn) ENGINE=InnoDB DEFAULT CHARSET=latin1;rnrn--rn-- Dumping data for table `price`rn--rnrnrn/*!40000 ALTER TABLE `price` DISABLE KEYS */;rnLOCK TABLES `price` WRITE;rnINSERT INTO `price` VALUES (1,'75','¸ÃÉÌÆ·ºÜºÃ'),(12,'74','»¶Ó­´ó¼ÒµÄ¹ºÂò '),(25,'218','´ó¼Ò¾õµÄÔõôÑùÄØ'),(123,'158','²»´íµÄÉÌÆ·£¬ºÜºÃ£¬well good'),(158,'2960','ºÃµÄÉÌÆ·'),(758,'7760','ºÃ°ôŶ ');rnUNLOCK TABLES;rn/*!40000 ALTER TABLE `price` ENABLE KEYS */;rnrn--rn-- Table structure for table `shoping`rn--rnrnDROP TABLE IF EXISTS `shoping`;rnCREATE TABLE `shoping` (rn `item_id` int(11) default NULL,rn `name` varchar(20) default NULLrn) ENGINE=InnoDB DEFAULT CHARSET=latin1;rnrn--rn-- Dumping data for table `shoping`rn--rnrnrn/*!40000 ALTER TABLE `shoping` DISABLE KEYS */;rnLOCK TABLES `shoping` WRITE;rnINSERT INTO `shoping` VALUES (12,'»Æº£'),(25,'Ììʱ'),(56,'éÙ×Ó'),(123,'Äã´íÁË°É '),(789,'°§Á¯µçÊÓ»ú·¢»Ó'),(987,'¾Ï¹ª'),(7289,'°§Á¯µçÊÓ»ú·¢»Ó');rnUNLOCK TABLES;rn/*!40000 ALTER TABLE `shoping` ENABLE KEYS */;rn/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;rnrn/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;rn/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;rn/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;rn/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;rn/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;rn/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;rn/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;rnrn 论坛

You have an error in your SQL syntax;??????帮忙看看 在线等

12-10

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 '[topic]' at line 1rn10rnrnrnrnrn[code=Java]<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>rn<%rn String path = request.getContextPath();rn String basePath = request.getScheme() + "://"rn + request.getServerName() + ":" + request.getServerPort()rn + path + "/";rn%>rnrnrnrn rn BBS添加板块rn rnrnrnrn rn<%@ include file = "header.jsp" %>rn rn rn rn rn rn rn rn rn 添加板块rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn 板块名称:rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rnrnrnrn[/code]rnrnrnrn[code=Java]<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>rn<%@ page import="com.study.dao.*"%>rn<%@ page import="com.study.vo.*"%>rn<%@ page isErrorPage="true"%>rn<%@ page errorPage="login.jsp"%>rnrnrn rn JSPBBS论坛rn rn rn rn <% rn if(session.getAttribute("bbsmember")==null)rn out.println(" ");rn out.flush();rn out.close();rn rn Member bbsmember = (Member)session.getAttribute("bbsmember");rn if(bbsmember.getMemberauthority()>0)rn out.println(" ");rn rn catch(Exception ex)rn rn rn out.flush();rn out.close();rn rnrn /**rn * The doPost method of the servlet. rn *rn * This method is called when a form has its tag value method equals to post.rn * rn * @param request the request send by the client to the serverrn * @param response the response send by the server to the clientrn * @throws ServletException if an error occurredrn * @throws IOException if an error occurredrn */rn public void doPost(HttpServletRequest request, HttpServletResponse response)rn throws ServletException, IOException rnrn boolean re = false;rn response.setContentType("text/html");rn response.setCharacterEncoding("GB18030");rn String path = request.getContextPath();rn String basePath = request.getScheme() + "://"rn + request.getServerName() + ":" + request.getServerPort()rn + path + "/";rn PrintWriter out = response.getWriter();rn String type = request.getParameter("type");rn String topictitle = request.getParameter("topictitle");rn Topic topic = new Topic();rn if(topictitle==null||topictitle.length()<1)rn out.println(" ");rn out.flush();rn out.close();rn rn topictitle = DataContext.getDataContext(topictitle);rn topic.setTopicname(topictitle);rn TopicDAO topicdao = DAOFactory.getTopicDAO();rn if(type.equalsIgnoreCase("add"))rn tryrn re = topicdao.addTopic(topic);rn if(re)rn out.println(" ");rn rn catch(Exception ex)rn else if(type.equalsIgnoreCase("update"))rn tryrn int topicid = Integer.parseInt(request.getParameter("topicid"));rn topic.setTopicid(topicid);rn re = topicdao.updateTopic(topic);rn if(re)rn out.println(" ");rn rn catch(Exception ex)rn rn out.flush();rn out.close();rn rn rnrn /**rn * Initialization of the servlet. rn *rn * @throws ServletException if an error occurern */rn public void init() throws ServletException rn // Put your code herern rnrnrn[/code]rnrnrn 论坛

Your dependecy isn't in the deployed application. You may have to change ***

09-09

Your dependecy isn't in the deployed application. You may have to change the "provided" scope to "compile"rnrnjava新手理解不了这句话什么意思,求翻译与指点.rnrn我在用resteasy 开发web服务是,按照一个教程在配置文件中配置了rn[code=XML]rn rn rn org.jboss.resteasy.plugins.server.servlet.ResteasyBootstraprn rn[/code]rnrn结果运行时候报错,说rnrn严重: Error configuring application listener of class org.jboss.resteasy.plugins.server.servlet.ResteasyBootstraprnjava.lang.ClassNotFoundException: org.jboss.resteasy.plugins.server.servlet.ResteasyBootstraprn at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1678)rn at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1523)rn at org.apache.catalina.core.DefaultInstanceManager.loadClass(DefaultInstanceManager.java:415)rn at org.apache.catalina.core.DefaultInstanceManager.loadClassMaybePrivileged(DefaultInstanceManager.java:397)rn at org.apache.catalina.core.DefaultInstanceManager.newInstance(DefaultInstanceManager.java:118)rn at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4660)rn at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5226)rn at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5221)rn at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)rn at java.util.concurrent.FutureTask.run(FutureTask.java:138)rn at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)rn at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)rn at java.lang.Thread.run(Thread.java:662)rn2011-9-9 0:54:17 org.apache.catalina.core.StandardContext listenerStartrnrn不知道为什么,就到网上搜,找到stackflow上的东东http://stackoverflow.com/questions/3683002/maven-strange-class-not-found-exception,如此而云,却不知何意。。求解决方案。。rnrn非常感谢!! 论坛

没有更多推荐了,返回首页