import java.io.StringReader; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; public class DbUtil { public static void main(String[] args) { Connection conn=null; PreparedStatement preparedStatement = null; try { String url="jdbc:mysql://192.168.230.129:3306/test"; String user="root"; String password="123456"; Class.forName("com.mysql.jdbc.Driver");//加载数据驱动 conn = DriverManager.getConnection(url, user, password);// 连接数据库 preparedStatement = conn.prepareStatement("update user set remark = ? where id = ?"); String clobContent = "xxx"; StringReader reader = new StringReader(clobContent); preparedStatement.setCharacterStream(1,reader,clobContent.length()); preparedStatement.setString(2,"1"); preparedStatement.executeUpdate(); } catch (ClassNotFoundException e) { e.printStackTrace(); System.out.println("加载数据库驱动失败"); }catch(Exception e){ e.printStackTrace(); System.out.println("连接数据库失败"); }finally { try { if(conn!=null){ conn.close(); } if(preparedStatement!=null){ preparedStatement.close(); } }catch (Exception e){ e.printStackTrace(); } } } }
通过sql语句更新Clob字段内容
最新推荐文章于 2024-05-06 11:24:03 发布