glstest.java

来自「图文混排工具 1、新建一个Web工程 2、将Jsp下的页面与.js文件拷贝」· Java 代码 · 共 35 行

import java.io.StringReader;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import smart.css.database.DBOperator;

public class GlsTest {	
	public static boolean add(String Content) throws SQLException,Exception {
	    DBOperator dbo = new DBOperator();
	    Content=Content.replaceAll("'","‘");  //将大文本中的英文单引号转换成中文单引号
	    boolean btn = false;
	   
	    String sql="insert into tableName(auto_id,content) values(?,?)";
	    PreparedStatement ps = null;	    
	    try {
	 	    long autoID = Long.parseLong(dbo.getSequenceValue("seq_tableName"));
	 	    ps = DBOperator.getConnection().prepareStatement(sql);  //预编译SQL语句
	 	    ps.setLong(1,autoID);
	 	    ps.setCharacterStream(2,new StringReader(Content),Content.length()); //将大文本插入表tableName
		    ps.executeUpdate();
		    ps.close();
	     } catch (Exception e) {
		         e.printStackTrace();
	     } finally {
		        try {
			         dbo.close();
		            } catch (RuntimeException e) {
			         e.printStackTrace();
		        }
	     }
	     return btn;
     }
}