luce_and_lily的专栏

sql server2005之前 驱动jar包：mssqlserver2.jar driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"  url="jdbc:microsoft:sqlserver://10.195.191.4:1433;DatabaseName=CRF_APS_DB" sql server2005之后 驱动

select * from table for update;  --加排它锁 select * from table lock in share mode;--加共享锁