简单数据库操作封装成javaBean

最新推荐文章于 2019-02-19 21:54:16 发布

kingfish

最新推荐文章于 2019-02-19 21:54:16 发布

阅读量1.2k

点赞数

分类专栏： JAVA EE 文章标签：数据库 exception null sql string sqlserver

本文链接：https://blog.csdn.net/kzl623/article/details/5940518

版权

JAVA EE 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

在web应用中数据库操作一般占据很大比重,有必要将这些重复的代码封装一下!关于数据库封装成Bean的各种好处这里不解释....

下面贴上一段数据库简单操作封装的代码

文件名:DBUtil.java

package beans; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class DBUtil { /** * 取得一个数据库连接 * @return * @throws SQLException * @throws InstantiationException * @throws IllegalAccessException * @throws ClassNotFoundException */ public Connection getConnection() throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException { Connection conn = null; //加载数据库驱动类 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver") .newInstance(); //数据库连接URL String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind"; //数据库用户名 String user = "sa"; //数据库密码 String password = "kingfish"; //根据数据库参数取得一个数据库连接 conn = DriverManager.getConnection(url, user, password); return conn; } /** * 根据传入的SQL语句返回一个结果集 * @param sql * @return * @throws Exception */ public ResultSet select(String sql) throws Exception { Connection conn = null; Statement stmt = null; ResultSet rs = null; try { conn = getConnection(); stmt = conn.createStatement(); rs = stmt.executeQuery(sql); return rs; } catch (SQLException sqle) { throw new SQLException("select data exception: " + sqle.getMessage()); } catch (Exception e) { throw new Exception("System e exception: " + e.getMessage()); } } /** * 根据传入的SQL语句向数据库增加一条记录 * @param sql * @throws Exception */ public void insert(String sql) throws Exception { Connection conn = null; PreparedStatement ps = null; try { conn = getConnection(); ps = conn.prepareStatement(sql); ps.executeUpdate(); } catch (SQLException sqle) { throw new Exception("insert data exception: " + sqle.getMessage()); } finally { try { if (ps != null) { ps.close(); } } catch (Exception e) { throw new Exception("ps close exception: " + e.getMessage()); } } try { if (conn != null) { conn.close(); } } catch (Exception e) { throw new Exception("connection close exception: " + e.getMessage()); } } /** * 根据传入的SQL语句更新数据库记录 * @param sql * @throws Exception */ public void update(String sql) throws Exception { Connection conn = null; PreparedStatement ps = null; try { conn = getConnection(); ps = conn.prepareStatement(sql); ps.executeUpdate(); } catch (SQLException sqle) { throw new Exception("update exception: " + sqle.getMessage()); } finally { try { if (ps != null) { ps.close(); } } catch (Exception e) { throw new Exception("ps close exception: " + e.getMessage()); } } try { if (conn != null) { conn.close(); } } catch (Exception e) { throw new Exception("connection close exception: " + e.getMessage()); } } /** * 根据传入的SQL语句删除一条数据库记录 * @param sql * @throws Exception */ public void delete(String sql) throws Exception { Connection conn = null; PreparedStatement ps = null; try { conn = getConnection(); ps = conn.prepareStatement(sql); ps.executeUpdate(); } catch (SQLException sqle) { throw new Exception("delete data exception: " + sqle.getMessage()); } finally { try { if (ps != null) { ps.close(); } } catch (Exception e) { throw new Exception("ps close exception: " + e.getMessage()); } } try { if (conn != null) { conn.close(); } } catch (Exception e) { throw new Exception("connection close exception: " + e.getMessage()); } } }

文件名:Query.jsp

<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%> <%@ page import="java.sql.*" %> <jsp:useBean id="db" class="beans.DBUtil" scope="page"></jsp:useBean> <% String sql = "select * from sysprotects"; ResultSet rs = db.select(sql); %> <html> <head> <title>数据库连接JavaBean使用示例</title> </head> <body> <font size="2"><strong> 本页面利用JavaBean实现查询数据库的功能：</strong><br> 下面的表格就是查询结果： </font> <table width="387" border="1" height="82"> <tr> <td>id</td> <td>uid</td> <td>action</td> <td>protecttype</td> <td>columns</td> <td>grantor</td> </tr> <% while(rs.next()) { out.print("<tr>"); out.print("<td>"+rs.getInt("id")+"</td>"); out.print("<td>"+rs.getInt("uid")+"</td>"); out.print("<td>"+rs.getInt("action")+"</td>"); out.print("<td>"+rs.getInt("protecttype")+"</td>"); out.print("<td>"+rs.getString("columns")+"</td>"); out.print("<td>"+rs.getInt("grantor")+"</td>"); out.print("</tr>"); } if(rs != null) { rs.close(); } %> </table> </body> </html>

这个Bean封装了数据库的基本操作,连接的数据库为sql server 2000自带的Northwind,后续还得对这个Bean改造,以达到能实际应用的地步

kingfish

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
简单数据库操作封装成javaBean

在web应用中数据库操作一般占据很大比重,有必要将这些重复的代码封装一下!关于数据库封装成Bean的各种好处这里不解释....下面贴上一段数据库简单操作封装的代码文件名:DBUtil.javapackage beans;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.S
复制链接

扫一扫

专栏目录