import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Iterator;import net.moraleboost.mecab.Node;
import net.moraleboost.mecab.impl.StandardLattice;
import net.moraleboost.mecab.impl.StandardTagger;public class DataAccess {
//private ArrayList<String> array=null;
//private ArrayList<String> arry=null;
public static void main(String[] args) {
DataAccess dataAccess =new DataAccess();
try {
dataAccess.selectPostgre();
} catch (Exception e) {
e.printStackTrace();
}
}public void selectPostgre() throws Exception{
String user = "qito"; String pass = "111"; String servername = "127.0.0.1"; String dbname = "book";
Connection conn = null;
Statement stmt = null;
ResultSet rset = null;
String isbn=null;
String title=null;
String str=null;
int i;
ResultSet idnum;
int listid;
ArrayList<String> array=new ArrayList();
try {
Class.forName ("org.postgresql.Driver");
/* Connection作成 */
conn = DriverManager.getConnection
("jdbc:postgresql://" + servername + ":5432/" + dbname,user,pass); /* Statement作成 */
stmt = conn.createStatement(); /* Resultset作成 */
rset = stmt.executeQuery("select * from book");
//while(rset.next()){
//System.out.println(rset.getString("isbn"));
//}
//System.out.println("!!!!!!!!!!!!!!!!");
String insertstr ;
while (rset.next()) {
//System.out.println(rset.getString("title"));
title=rset.getString("title");
//System.out.println(title);
isbn=rset.getString("isbn");
//System.out.println(isbn);
array=new ArrayList<String>(parse(rset.getString("title")));
for(i=1;i<array.size()+1;i++){
Iterator<String> it = array.iterator();
while(it.hasNext())
{
str=new String(it.next());
if(str.equals("")||str.equals("(")||str.equals(")")||str.equals("=")||str.equals("-")||str.equals("は")||str.equals("が")||str.equals("に")||str.equals("の")||str.equals("/")||str.equals("、")||str.equals("?")||str.equals("."))continue;
str=str.replaceAll("\r\n","");
System.out.print(str);
stmt.executeQuery("insert into morpheme_list (morpheme_name) values('"+str+"')");//这里出错 但是数据可以插到数据库里 }
}
}
} catch (ClassNotFoundException e) {
throw e;
} catch (SQLException e) {
throw e;
} catch ( Exception e){
throw e;
}
finally{
if(conn != null){
conn.close();
conn = null;
}
if(stmt != null){
stmt.close();
stmt = null;
}
if(rset != null){
rset.close();
rset = null;
}
}
}
private ArrayList<String> parse(String str){
ArrayList<String> arry=new ArrayList();
StandardTagger tagger = new StandardTagger("-Oyomi");
StandardLattice lattice = tagger.createLattice();
lattice.setSentence(str); tagger.parse(lattice);
Node node=lattice.bosNode();
while (node != null) {
String surface = node.surface();
arry.add(surface);
node = node.next();
}
lattice.destroy();
tagger.destroy();
return arry;
}}
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Iterator;import net.moraleboost.mecab.Node;
import net.moraleboost.mecab.impl.StandardLattice;
import net.moraleboost.mecab.impl.StandardTagger;public class DataAccess {
//private ArrayList<String> array=null;
//private ArrayList<String> arry=null;
public static void main(String[] args) {
DataAccess dataAccess =new DataAccess();
try {
dataAccess.selectPostgre();
} catch (Exception e) {
e.printStackTrace();
}
}public void selectPostgre() throws Exception{
String user = "qito"; String pass = "111"; String servername = "127.0.0.1"; String dbname = "book";
Connection conn = null;
Statement stmt = null;
ResultSet rset = null;
String isbn=null;
String title=null;
String str=null;
int i;
ResultSet idnum;
int listid;
ArrayList<String> array=new ArrayList();
try {
Class.forName ("org.postgresql.Driver");
/* Connection作成 */
conn = DriverManager.getConnection
("jdbc:postgresql://" + servername + ":5432/" + dbname,user,pass); /* Statement作成 */
stmt = conn.createStatement(); /* Resultset作成 */
rset = stmt.executeQuery("select * from book");
//while(rset.next()){
//System.out.println(rset.getString("isbn"));
//}
//System.out.println("!!!!!!!!!!!!!!!!");
String insertstr ;
while (rset.next()) {
//System.out.println(rset.getString("title"));
title=rset.getString("title");
//System.out.println(title);
isbn=rset.getString("isbn");
//System.out.println(isbn);
array=new ArrayList<String>(parse(rset.getString("title")));
for(i=1;i<array.size()+1;i++){
Iterator<String> it = array.iterator();
while(it.hasNext())
{
str=new String(it.next());
if(str.equals("")||str.equals("(")||str.equals(")")||str.equals("=")||str.equals("-")||str.equals("は")||str.equals("が")||str.equals("に")||str.equals("の")||str.equals("/")||str.equals("、")||str.equals("?")||str.equals("."))continue;
str=str.replaceAll("\r\n","");
System.out.print(str);
stmt.executeQuery("insert into morpheme_list (morpheme_name) values('"+str+"')");//这里出错 但是数据可以插到数据库里 }
}
}
} catch (ClassNotFoundException e) {
throw e;
} catch (SQLException e) {
throw e;
} catch ( Exception e){
throw e;
}
finally{
if(conn != null){
conn.close();
conn = null;
}
if(stmt != null){
stmt.close();
stmt = null;
}
if(rset != null){
rset.close();
rset = null;
}
}
}
private ArrayList<String> parse(String str){
ArrayList<String> arry=new ArrayList();
StandardTagger tagger = new StandardTagger("-Oyomi");
StandardLattice lattice = tagger.createLattice();
lattice.setSentence(str); tagger.parse(lattice);
Node node=lattice.bosNode();
while (node != null) {
String surface = node.surface();
arry.add(surface);
node = node.next();
}
lattice.destroy();
tagger.destroy();
return arry;
}}
解决方案 »
- 关于ajaxfileupload在spring环境中的使用问题
- 怎样给struts标签动态传递参数?
- sql查询问题
- struts2的validation文件放在classpath里可以吗?
- 请教为什么出现这个错误??急啊!
- encType=multipart/form-data request取不出来值
- osb中javabean如何调用jms协议的proxy
- 跪求,一个DOM的问题
- 请问如何将jb9+tomcat+jboss组合起来?
- 我的SQL SERVER数据库中有时间字段create_date(数值为2003-3-4这种形式),在JSP中如何根据这个字段值筛选出某一周内的记录
- 关于java过滤器的问题。
- 求各位前辈 给推荐一本JAVA 基础书籍
每次执行到插入数据库的地方就出现
org.postgresql.util.PSQLException:
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
at DataAccess.selectPostgre(DataAccess.java:102)
at DataAccess.main(DataAccess.java:21)错误请问哪里错了?
谢谢
如果是的话建议看看数据表定义,是否有constraint violation,或者trigger抛出异常
主key设的自增