Conn

最新推荐文章于 2024-10-16 12:53:45 发布

cg102

最新推荐文章于 2024-10-16 12:53:45 发布

阅读量433

点赞数

文章标签： string sqlserver microsoft null sql scroll

本文链接：https://blog.csdn.net/cg102/article/details/1537382

版权

package bean;
import java.sql.*;
public class ConnDB{
  String dbDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
  String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=exam";
  String user = "sa";
  String password = "";
Connection connect=null;
Statement stmt=null;
ResultSet rs=null;

public ConnDB(){
  try{
   Class.forName(dbDriver);
   }
   catch(java.lang.ClassNotFoundException e){
    System.err.println(e.getMessage());
   }
  }

public ResultSet executeQuery(String sql){

  try{
   connect=DriverManager.getConnection(dbURL,user,password);
   stmt=connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
   rs=stmt.executeQuery(sql);
   }
   catch(SQLException ex){
    System.err.println(ex.getMessage());
    }
    return rs;
  }

public int executeUpdate(String sql){
int result=0;
  try{
   connect=DriverManager.getConnection(dbURL,user,password);
   stmt=connect.createStatement();
   result=stmt.executeUpdate(sql);
   }
   catch(SQLException ex){
    System.err.println(ex.getMessage());
    }
    return result;
   }

public void close(){
  try{
   if(stmt != null) stmt.close();
   if(connect != null)connect.close();
  }
  catch(SQLException ex){
    System.err.println(ex.getMessage());
  }
}
}