packagejsp;

importjava.sql.*;//JDBCpackage

publicclasssql_data{

Stringurl="jdbc:inetdae:192.168.2.70?sql7=true";//useyourhostnameandportnumber

Stringlogin="sa";//useyourloginhere

Stringpassword="";//useyourpasswordhere

publicConnectionconnection=null;

publicStatementst=null;

publicResultSetrs=null;

publicsql_data(){

try{

Class.forName("com.inet.tds.TdsDriver").newInstance();

DriverManager.setLoginTimeout(10);

}catch(Exceptione){

e.printStackTrace();

}

}

publicvoidsqlclose(){

try{

st.close();

connection.close();

}

catch(SQLExceptionex){

System.err.println("sqlclose:"+ex.getMessage());

}

}

publicResultSetexecuteQuery(Stringsql){

try{

connection=DriverManager.getConnection(url,login,password);

connection.setCatalog("register");

st=connection.createStatement();

rs=st.executeQuery(sql);

}

catch(SQLExceptionex){

System.err.println("aq.executeQuery:"+ex.getMessage());

}

returnrs;

}

}