一个数据库类用于java中操作sql2005数据库_编写sql2005数据库类-CSDN博客

本文链接：https://blog.csdn.net/zhangxinwei/article/details/3058221

package test;
import java.sql.*;

public class DB {

    String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动
      String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=Test"; //连接服务器
      String userName = "sa"; //默认用户名
      String userPwd ="123456"; //密码
      Connection dbConn=null;
       Connection con=null;
      Statement stmt = null;
        ResultSet rs = null;
        public DB() { try{Class.forName(driverName);
       dbConn = DriverManager.getConnection(dbURL, userName, userPwd);

        }catch(Exception e){closeAll(); e.printStackTrace();}
    }
    public ResultSet exeQury(String sql)//执行查询返回结果集ResultSet
    {
      try {


     String SQL = sql;
               stmt = dbConn.createStatement();
               rs = stmt.executeQuery(SQL);
      }catch(Exception e){closeAll();e.printStackTrace();}
return rs;
}
public boolean exeUpdate(String sql)//执行更新操作
{      try {

     String SQL = sql;
               stmt = dbConn.createStatement();
              stmt.executeUpdate(SQL);
      }catch(Exception e){closeAll();e.printStackTrace();return false;}
return true;
}
public void closeAll()//关闭连接
{if (rs != null) try { rs.close(); } catch(Exception e) {e.printStackTrace();}
         if (stmt != null) try { stmt.close(); } catch(Exception e) {e.printStackTrace();}
         if (dbConn != null) try { dbConn .close(); } catch(Exception e) {e.printStackTrace();}
}
}

测试：

<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="test.DB" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>
testDB
</title>
</head>
<body bgcolor="#ffffff">
<h1>
<%
DB db=new DB();
String sql="select * from test";

String update="insert into test values('11','22')";
boolean flag=db.exeUpdate(update);
if(flag)
{out.print("insert success");}
ResultSet rs=db.exeQury(sql);
try{
while (rs.next()) {
out.println(rs.getString(1) + " " + rs.getString(2)+"<br />");

}}catch(Exception e){e.printStackTrace();}
%>
</h1>
</body>
</html>