java bean 更新数据库_一个操作数据库的Java Bean……

一个操作数据库的java Bean，有兴趣的朋友看一下吧~~

package dbconnect;

import java.sql.*;

http://www.gaodaima.com/?p=43092一个操作数据库的Java Bean……

public class sqlconnection

{

String sDbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";

String sConnStr = "jdbc:odbc:sqlconnect"; // sqlconnect 数据源名称；

private Connection conn = null;

private Statement stmt = null;

ResultSet rs = null;

public sqlconnection()

{

try

{

Class.forName(sDbDriver);

}catch(java.lang.ClassNotFoundException e){

System.err.println("sqlconnection():" + e.getMessage());

}

}

public ResultSet executeQuery(String sql)

{

rs = null;

try

{

conn = DriverManager.getConnection(sConnStr);

stmt = conn.createStatement();

rs = stmt.executeQuery(sql);

}catch (SQLException ex){

System.err.println("aq.executeQuery:" + ex.getMessage());

}

return rs;

}

public void executeUpdate(String sql)

{

stmt = null;

rs = null;

try

{

conn = DriverManager.getConnection(sConnStr);

stmt = conn.createStatement();

stmt.executeQuery(sql);

stmt.close();

conn.close();

}catch (SQLException ex){

System.err.println("aq.executeQuery:" + ex.getMessage());

}

}

public void closeStmt()

{

try

{

stmt.close();

}catch (SQLException ex){

System.err.println("aq.executeQuery:" + ex.getMessage());

}

}

public void closeConn()

{

try

{

conn.close();

}catch (SQLException ex){

System.err.println("aq.executeQuery:" + ex.getMessage());

}

}

}

欢迎大家阅读《一个操作数据库的Java Bean……》,跪求各位点评,若觉得好的话请收藏本文，by 搞代码

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~