String dropSQL = "if exists (select * from dbo.sysobjects " +
"where id = object_id(N'IPView') and OBJECTPROPERTY(id,N'IsView') = 1)" +
" Drop view IPView ";
String createSQL = "create view IPView as (select * " +
"from IPDistribution where IP like ?)" + "\n";
String querySQL = "declare @lastIP int " + "\n" +
" set @lastIP=1" + "\n" +
" while ((@lastIP in (select intIP from IPView)) and (@lastIP<=255))" + "\n" +
" begin" + "\n" +
" set @lastIP=@lastIP+1" + "\n" +
" end" + "\n" +
" select @lastIP" + "\n";
try {
openConn();
_pstmt = _conn.prepareStatement(dropSQL);
_pstmt.executeUpdate();
_pstmt = _conn.prepareStatement(createSQL);
_pstmt.setString(1, "172.16."+Vlan+".%");
//System.out.println("++++++++++"+"172.16."+Vlan+".%"+"=====");
_pstmt.executeUpdate();
_pstmt = _conn.prepareStatement(querySQL);
_resultset = _pstmt.executeQuery();
if (_resultset.next()){
int lastIP = _resultset.getInt("@lastIP");
newIP = "172.16." + Vlan + "." + String.valueOf(lastIP);
//System.out.println("====="+newIP+"=====");
return newIP;
}
} catch (SQLException e) {
log.error(e.getMessage());
AppException ex = new AppException(e.getMessage());
throw ex;
} finally{
dispose();
}
return null;
}
这个老是报错:- 关键字 'view' 附近有语法错误!求大虾给帮帮忙!
"where id = object_id(N'IPView') and OBJECTPROPERTY(id,N'IsView') = 1)" +
" Drop view IPView ";
String createSQL = "create view IPView as (select * " +
"from IPDistribution where IP like ?)" + "\n";
String querySQL = "declare @lastIP int " + "\n" +
" set @lastIP=1" + "\n" +
" while ((@lastIP in (select intIP from IPView)) and (@lastIP<=255))" + "\n" +
" begin" + "\n" +
" set @lastIP=@lastIP+1" + "\n" +
" end" + "\n" +
" select @lastIP" + "\n";
try {
openConn();
_pstmt = _conn.prepareStatement(dropSQL);
_pstmt.executeUpdate();
_pstmt = _conn.prepareStatement(createSQL);
_pstmt.setString(1, "172.16."+Vlan+".%");
//System.out.println("++++++++++"+"172.16."+Vlan+".%"+"=====");
_pstmt.executeUpdate();
_pstmt = _conn.prepareStatement(querySQL);
_resultset = _pstmt.executeQuery();
if (_resultset.next()){
int lastIP = _resultset.getInt("@lastIP");
newIP = "172.16." + Vlan + "." + String.valueOf(lastIP);
//System.out.println("====="+newIP+"=====");
return newIP;
}
} catch (SQLException e) {
log.error(e.getMessage());
AppException ex = new AppException(e.getMessage());
throw ex;
} finally{
dispose();
}
return null;
}
这个老是报错:- 关键字 'view' 附近有语法错误!求大虾给帮帮忙!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货