這是代碼
public static void get(){
try {
BufferedReader br=new BufferedReader(new FileReader(new File("tt.html")));
StringBuffer s=new StringBuffer();
String b;
while ((b=br.readLine())!=null){
s.append(b+"\r\n");
}
br.close();
InputStream inputStream= Resources.getResourceAsStream("mybatis_config.xml");
SqlSessionFactory sqlSessionFactory= new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession=sqlSessionFactory.openSession();
ArticleDao articleDao=sqlSession.getMapper(ArticleDao.class);
TArticle article=new TArticle();
article.setContent(s.toString());
System.out.println(article.getContent());
article.setUuid(UUID.randomUUID().toString().replace("-",""));
article.setDelsign("1");
article.setInserttime("1");
article.setIscollection("1");
article.setIsfabulous("1");
article.setIsopen("1");
article.setPointnumber("1");
article.setTitle("1");
article.setTypeid("1");
article.setUpdatetime("1");
article.setUrl("1");
article.setUserid("1");
articleDao.add(article);
sqlSession.commit();
sqlSession.close();
} catch (IOException e) {
e.printStackTrace();
}
}
下面是異常
Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException:
### Error committing transaction. Cause: org.apache.ibatis.executor.BatchExecutorException: cn.autually.dao.ArticleDao.add (batch index #1) failed. Cause: java.sql.BatchUpdateException: No value specified for parameter 1
### Cause: org.apache.ibatis.executor.BatchExecutorException: cn.autually.dao.ArticleDao.add (batch index #1) failed. Cause: java.sql.BatchUpdateException: No value specified for parameter 1
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.commit(DefaultSqlSession.java:227)
at org.apache.ibatis.session.defaults.DefaultSqlSession.commit(DefaultSqlSession.java:218)
at service.sss.get(sss.java:59)
at service.sss.main(sss.java:25)
Caused by: org.apache.ibatis.executor.BatchExecutorException: cn.autually.dao.ArticleDao.add (batch index #1) failed. Cause: java.sql.BatchUpdateException: No value specified for parameter 1
at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:146)
at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:129)
at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:122)
at org.apache.ibatis.executor.BaseExecutor.commit(BaseExecutor.java:242)
at org.apache.ibatis.executor.CachingExecutor.commit(CachingExecutor.java:119)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
at com.sun.proxy.$Proxy11.commit(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.commit(DefaultSqlSession.java:224)
... 3 more
Caused by: java.sql.BatchUpdateException: No value specified for parameter 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1666)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1082)
at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:122)
... 14 more
我試著輸出了讀出來的s，跟html的內(nèi)容一樣，但就是存不到數(shù)據(jù)庫里，不知道為什么，求大神指點
為什么我的mybatis存儲html頁面的所有代碼到mysql數(shù)據(jù)庫的text類型中 直接存會報錯。
寶慕林4294392
2019-03-01 10:31:59
