使用jdbc向sqlserver2000中插入数据,长字符串出问题????
使用jdbc向sqlserver2000中插入数据,数据表字段的数据类型是varchar(8000),当字符串的长度达到大概1000左右时,无法将数据表写入数据库,同时也没有任何异常被扑捉到,很是奇怪??
try{
DriverManager.registerDriver(myDriver);
conn = DriverManager.getConnection(
"jdbc:sqlserver:***", "sa",
"***");
SQL = "insert into IQPCDetail Values(?,?,?,?,?,?,?,?,?,?,?)";
stm = conn.prepareStatement(SQL);
stm.setString(1, PieceNo);
stm.setString(2, titleDescript);
stm.setString(3, tilteVideo);
stm.setString(4, author);
stm.setString(5, authorUnit);
stm.setString(6, authorTitle);
stm.setString(7, authorIntro);
stm.setString(8, relativePath);
stm.setString(9, fileObject);
stm.setString(10, fileList);
stm.setString(11, createTime);
stm.execute();
} catch (Exception e) {
System.out.print(e.toString());
}