自己写的一个JAVA小程序总结:
要点:1)con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
2)rs.updateString(j,tableSql);
rs.updateRow();
String query
=
"
select * from
"
+
table;
Connection con = getConnectionMys();
try ... {
Statement stmt =con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery(query);
ResultSetMetaData rm=rs.getMetaData();
while(rs.next())
...{
for(int j=1;j<rm.getColumnCount()+1;j++)
...{
if(rm.getColumnTypeName(j).equals("VARCHAR"))
...{
String tableSql=rs.getString(j);
if (tableSql!=null&&(tableSql.indexOf("四川")>=0||tableSql.indexOf("成都")>=0||tableSql.indexOf("****")>=0))
...{
System.out.print(table+" "+rm.getColumnName(j)+" "+tableSql.substring(0,Math.min(tableSql.length(),60))+" ");
tableSql=Replace(tableSql,"四川","上海");
tableSql=Replace(tableSql,"成都"," ");
tableSql=Replace(tableSql,"****","****");
rs.updateString(j,tableSql);
rs.updateRow();
System.out.print(table+" "+rm.getColumnName(j)+" "+tableSql.substring(0,Math.min(tableSql.length(),60))+" ");
n++;
}
}
}
}
System.out.print(n+"");
rs.close();
stmt.close();
con.close();
}
catch (Exception e)
... {
e.printStackTrace();
}
Connection con = getConnectionMys();
try ... {
Statement stmt =con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery(query);
ResultSetMetaData rm=rs.getMetaData();
while(rs.next())
...{
for(int j=1;j<rm.getColumnCount()+1;j++)
...{
if(rm.getColumnTypeName(j).equals("VARCHAR"))
...{
String tableSql=rs.getString(j);
if (tableSql!=null&&(tableSql.indexOf("四川")>=0||tableSql.indexOf("成都")>=0||tableSql.indexOf("****")>=0))
...{
System.out.print(table+" "+rm.getColumnName(j)+" "+tableSql.substring(0,Math.min(tableSql.length(),60))+" ");
tableSql=Replace(tableSql,"四川","上海");
tableSql=Replace(tableSql,"成都"," ");
tableSql=Replace(tableSql,"****","****");
rs.updateString(j,tableSql);
rs.updateRow();
System.out.print(table+" "+rm.getColumnName(j)+" "+tableSql.substring(0,Math.min(tableSql.length(),60))+" ");
n++;
}
}
}
}
System.out.print(n+"");
rs.close();
stmt.close();
con.close();
}
catch (Exception e)
... {
e.printStackTrace();
}