txwd007
发贴: 2
积分: 0
|
于 2006-06-30 00:00
import java.net.*; import java.io.*; import java.lang.*; import java.sql.*;
public class Openinto { public String getContent(String strUrl) // 一个public方法,返回字符串,错误则返回error open url { StringBuffer sb=new StringBuffer(); try{ URL url=new URL(strUrl); BufferedReader br=new BufferedReader(new InputStreamReader(url.openStream())); String s=br.readLine(); while((s=br.readLine())!=null){ sb.append; } br.close(); } catch(Exception e) { // return error open url + strUrl; e.printStackTrace(); } return sb.toString(); } public static void main(String args[]) { String web = "http://www.21cn.com"; Openinto ou=new Openinto(); String yes = ou.getContent(web); //intojdbc try{ String driverName = "org.gjt.mm.mysql.Driver"; String dbpath = "jdbc:mysql://localhost/gray"; String username = "root"; String password = "gemini0527"; String sql3 = "insert into person values(?,?)"; String id = "www.21cn.com"; String name = yes; Class.forName(driverName); Connection conn = DriverManager.getConnection(dbpath,username,password); PreparedStatement pstmt = conn.prepareStatement(sql3); pstmt.setString(1,id); pstmt.setString(2,name); pstmt.executeUpdate(); pstmt.close(); conn.close(); }catch(SQLException sqe) { System.out.println("SQL Error:" + sqe.getMessage()); }catch(ClassNotFoundException cnfe) { System.out.println(cnfe.getMessage()); } } } 出现的错误是: SQL Error: Data truncation: Data too long for column 'name' at row 1 我的数据库(id[char];name[txet]); 我把name的类型改的text,但是还是出现这个错误~~ -_-! 本人菜鸟一个,在此求教了!
|