package Irey;
import java.sql.*;
import java.util.*;public class mxsm{
String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
Connection Conn=null;
ResultSet rs=null;
Statement stmt=null;
int mm;
java.util.Date date;
CallableStatement cstmt=null;
public mxsm(){
try{
Class.forName(sDBDriver).newInstance();
DBConnectionPool pool=new DBConnectionPool("dbc","jdbc:microsoft:sqlserver://192.168.1.1:1433;DatabaseName=mxsm","liu","2108",0);
Conn=pool.getConnection();
stmt=Conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
date=new java.util.Date();
mm=date.getMonth()+1;
}catch(Exception e){}
}
public ResultSet executeQuery(String SQL){
try{
if(mm<=2){
rs=stmt.executeQuery(SQL);
}
}catch(Exception e){}
return rs;
}
public void executeUpdate(String s){
try{
stmt.executeUpdate(s);
}catch(Exception e){}
}
public void procedureUpdate(String pp){
try{
cstmt = Conn.prepareCall(pp);
cstmt.executeUpdate();
cstmt.close();
Conn.close();
}catch(Exception e){}
}
public void Close(){
try{
stmt.close();
Conn.close();
}catch(Exception e){}
}
}
import java.sql.*;
import java.util.*;public class mxsm{
String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
Connection Conn=null;
ResultSet rs=null;
Statement stmt=null;
int mm;
java.util.Date date;
CallableStatement cstmt=null;
public mxsm(){
try{
Class.forName(sDBDriver).newInstance();
DBConnectionPool pool=new DBConnectionPool("dbc","jdbc:microsoft:sqlserver://192.168.1.1:1433;DatabaseName=mxsm","liu","2108",0);
Conn=pool.getConnection();
stmt=Conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
date=new java.util.Date();
mm=date.getMonth()+1;
}catch(Exception e){}
}
public ResultSet executeQuery(String SQL){
try{
if(mm<=2){
rs=stmt.executeQuery(SQL);
}
}catch(Exception e){}
return rs;
}
public void executeUpdate(String s){
try{
stmt.executeUpdate(s);
}catch(Exception e){}
}
public void procedureUpdate(String pp){
try{
cstmt = Conn.prepareCall(pp);
cstmt.executeUpdate();
cstmt.close();
Conn.close();
}catch(Exception e){}
}
public void Close(){
try{
stmt.close();
Conn.close();
}catch(Exception e){}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货