import java.sql.*;
import java.util.*;
import java.io.*;import oracle.sql.*;
/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2003</p>
* <p>Company: </p>
* @author not attributable
* @version 1.0
*/public class TestClob {
public static void main(String[] args) {
try {
Properties pro = new Properties();
pro.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory");
pro.put(Context.PROVIDER_URL, "t3://198.188.168.113:7001"); Context ctx = new InitialContext(pro);
javax.sql.DataSource driver = (javax.sql.DataSource) ctx.lookup("newStarDB");
Connection conn = driver.getConnection();
System.out.println(conn);
java.sql.PreparedStatement pstmt = null;
ResultSet rs = null;
String query = "";
query =
"update name set text=? where id = 1";
pstmt = conn.prepareStatement(query);
pstmt.setCharacterStream(1,new BufferedReader(new FileReader(new File("c:/read.txt"))), new FileInputStream("c:/read.txt").available());
System.out.println("Buffer =========" + new BufferedReader(new FileReader(new File("c:/read.txt"))));
BufferedReader bread = new BufferedReader(new BufferedReader(new FileReader(new File("c:/read.txt"))));
while(query!= null)
{
System.out.println(query);
query = bread.readLine();
} pstmt.executeUpdate(); query =
"select text from name where id = 1";
pstmt = conn.prepareStatement(query);
rs = pstmt.executeQuery();
rs.next();
Clob clob = rs.getClob(1);
Reader read = clob.getCharacterStream();
bread = new BufferedReader(read);
query = bread.readLine();
while(query!= null)
{
System.out.println(query);
query = bread.readLine();
} System.out.println("over"); }
catch (Exception ep) {
ep.printStackTrace();
} }}
import java.util.*;
import java.io.*;import oracle.sql.*;
/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2003</p>
* <p>Company: </p>
* @author not attributable
* @version 1.0
*/public class TestClob {
public static void main(String[] args) {
try {
Properties pro = new Properties();
pro.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory");
pro.put(Context.PROVIDER_URL, "t3://198.188.168.113:7001"); Context ctx = new InitialContext(pro);
javax.sql.DataSource driver = (javax.sql.DataSource) ctx.lookup("newStarDB");
Connection conn = driver.getConnection();
System.out.println(conn);
java.sql.PreparedStatement pstmt = null;
ResultSet rs = null;
String query = "";
query =
"update name set text=? where id = 1";
pstmt = conn.prepareStatement(query);
pstmt.setCharacterStream(1,new BufferedReader(new FileReader(new File("c:/read.txt"))), new FileInputStream("c:/read.txt").available());
System.out.println("Buffer =========" + new BufferedReader(new FileReader(new File("c:/read.txt"))));
BufferedReader bread = new BufferedReader(new BufferedReader(new FileReader(new File("c:/read.txt"))));
while(query!= null)
{
System.out.println(query);
query = bread.readLine();
} pstmt.executeUpdate(); query =
"select text from name where id = 1";
pstmt = conn.prepareStatement(query);
rs = pstmt.executeQuery();
rs.next();
Clob clob = rs.getClob(1);
Reader read = clob.getCharacterStream();
bread = new BufferedReader(read);
query = bread.readLine();
while(query!= null)
{
System.out.println(query);
query = bread.readLine();
} System.out.println("over"); }
catch (Exception ep) {
ep.printStackTrace();
} }}
解决方案 »
- 北风网企业普及版贝斯OA的静态页面
- tomcat 使用时加载部署项目出现 “Exploded location overlaps an existing deployment” ?
- JAVA继承类的反射为什么报错啊?
- j2ee
- 异常处理问题
- struts框架中,struts标签使用css变型很严重!
- Exception creating bean of class org.apache.struts.action.ActionForm: {1}
- 一个建表的问题
- 小问题
- WebSphere中的EJB事务极其简单的问题
- help me!!!请教关于struts的问题
- 在线等: Runtime.getRuntime().exec()的问题
测试通过,呵呵,接分了!