| |
技术文档>>JAVA>>新手入门>>基础入门>查看文档 |
|
| |
一个操作数据库的java bean…… |
|
| |
文章作者:未知 文章来源:水木森林 |
|
| |
查看:135次 录入:管理员--2007-11-17 |
|
| |
一个操作数据库的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());
}
}
}
|
|
|
|
相关文档
|
