一个操作数据库的Java Bean……

2024-07-13 09:55:00

字体：大中小

来源：转载

供稿：网友

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

package dbconnect;

import java.sql.*;

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程序的性能优化

下一篇：在java里读取大对象数据