批量修改sqlserver 字段wid 默认值
package com.pm360.pip.test;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
public class TestSqlserver {
public static void testMS ()throws NamingException {
Connection conn=null;
ResultSet rs=null;
ResultSet rs1=null;
Statement statement=null;
Statement statement1=null;
Statement statement2=null;
Statement statement3=null;
try {
Context initCtx = new InitialContext();
DataSource ds= (DataSource) initCtx.lookup("java:/comp/env/jdbc/pip");
conn=ds.getConnection();
//得到数据库所有包含WID字段的表
String sql="S