//在工程中还要导入sql数据库的驱动。
package conn;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class SqlBean {
ResultSet rs=null;
Connection connect=null;
public SqlBean(){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");//加载相应的驱动
}
catch(java.lang.ClassNotFoundException e){
System.err.println(e.getMessage());
}
}
public ResultSet executeQuery(String sql){
try{
connect=DriverManager.getConnection("jdbc:microsoft:sqlserver://10.28.74.205:1433;DatabaseName=text","sa","123");//创建数据库连接对象("驱动类型:数据库名","用户名","密码")
Statement stm=connect.createStatement();
rs=stm.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println(ex.getMessage());
}
return rs;
}
public int executeUpdate(String sql){
int result=0;
try{
connect=DriverManager.getConnection("jdbc:microsoft:sqlserver://10.28.74.205:1433;DatabaseName=test","","");
Statement stm=connect.createStatement();
result=stm.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println(ex.getMessage());
}
return result;
}
public void CloseDataBase(){
try{
connect.close();
}
catch(Exception end){
System.err.println("wrong");
}
}
}