一个操作数据库的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());
}
}
}
闽公网安备 35060202000074号