package jsp;
import java.sql.*; // jdbc package
public class sql_data {
string url = "jdbc:inetdae:192.168.2.70?sql7=true"; // use your hostname and port number
string login = "sa"; // use your login here
string password =""; // use your password here
public connection connection = null;
public statement st = null;
public resultset rs = null;
public sql_data(){
try {
class.forname("com.inet.tds.tdsdriver").newinstance();
drivermanager.setlogintimeout(10);
} catch(exception e) {
e.printstacktrace();
}
}
public void sqlclose() {
try {
st.close();
connection.close();
}
catch(sqlexception ex) {
system.err.println("sqlclose: " + ex.getmessage());
}
}
public resultset executequery(string sql) {
try {
connection = drivermanager.getconnection(url,login,password);
connection.setcatalog( "register");
st = connection.createstatement();
rs = st.executequery(sql);
}
catch(sqlexception ex) {
system.err.println("aq.executequery: " + ex.getmessage());
}
return rs;
}
}
如对本文有疑问,
点击进行留言回复!!
相关文章:
-
-
-
-
-
-
-
-
-
-
tta
ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQC58eVE6F5OedOYE3nf...
[阅读全文]
-
网友评论