private static int TRANSACTION_READ_UNCOMMITTED=1;
private Properties dbs_properties=new Properties();
private String strConnection="jdbc:microsoft:sqlserver://192.168.0.169:1433";
//函数getConnectIni获取据库连接的参数
private void getConnectIni()
{
dbs_properties.put("User","sa");
dbs_properties.put("Password","741028");
dbs_properties.put("DatabaseName","WebGps");
dbs_properties.put("SelectMethod","cursor"); //设置游标形式,以便于设置事务
}//实现SqlServer数据库的连接
private Connection dbsConnection()
{
Connection dbsCon=null;
try
{
dbsCon=DriverManager.getConnection(strConnection,dbs_properties);
dbsCon.setAutoCommit(false);//设置事务为手动模式
dbsCon.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED); //设置数据库事务隔离级别为最高级别
}
catch(Exception ex)
{
writeErrorLog(ex.getMessage().toString());
}
return dbsCon;
}
private Properties dbs_properties=new Properties();
private String strConnection="jdbc:microsoft:sqlserver://192.168.0.169:1433";
//函数getConnectIni获取据库连接的参数
private void getConnectIni()
{
dbs_properties.put("User","sa");
dbs_properties.put("Password","741028");
dbs_properties.put("DatabaseName","WebGps");
dbs_properties.put("SelectMethod","cursor"); //设置游标形式,以便于设置事务
}//实现SqlServer数据库的连接
private Connection dbsConnection()
{
Connection dbsCon=null;
try
{
dbsCon=DriverManager.getConnection(strConnection,dbs_properties);
dbsCon.setAutoCommit(false);//设置事务为手动模式
dbsCon.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED); //设置数据库事务隔离级别为最高级别
}
catch(Exception ex)
{
writeErrorLog(ex.getMessage().toString());
}
return dbsCon;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货