可以的,试试这个,具体的你自己再改改吧 ;)
import java.io.PrintStream;
import java.sql.*;public class DBOperation
{ private String strDbDriver;
private String strConn;
private Connection conn;
private ResultSet result;
private String strUser;
private String strPassword; public DBOperation()
{
strDbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
strConn = "jdbc:odbc:abc";
conn = null;
result = null;
strUser = "sa";
strPassword = "";
try
{
Class.forName(strDbDriver);
}
catch(ClassNotFoundException ex)
{
System.err.println(ex.getMessage());
}
} public DBOperation(String strUser, String strPassword)
{
this();
this.strUser = strUser;
this.strPassword = strPassword;
} public ResultSet executeQuery(String strSql)
throws SQLException
{
result = null;
conn = DriverManager.getConnection(strConn, strUser, strPassword);
Statement st = conn.createStatement();
return st.executeQuery(strSql);
} public int executeUpdate(String strSql)
throws SQLException
{
int nRetValue = -1;
conn = DriverManager.getConnection(strConn, strUser, strPassword);
Statement st = conn.createStatement();
nRetValue = st.executeUpdate(strSql);
st.close();
conn.close();
return nRetValue;
}
}
import java.io.PrintStream;
import java.sql.*;public class DBOperation
{ private String strDbDriver;
private String strConn;
private Connection conn;
private ResultSet result;
private String strUser;
private String strPassword; public DBOperation()
{
strDbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
strConn = "jdbc:odbc:abc";
conn = null;
result = null;
strUser = "sa";
strPassword = "";
try
{
Class.forName(strDbDriver);
}
catch(ClassNotFoundException ex)
{
System.err.println(ex.getMessage());
}
} public DBOperation(String strUser, String strPassword)
{
this();
this.strUser = strUser;
this.strPassword = strPassword;
} public ResultSet executeQuery(String strSql)
throws SQLException
{
result = null;
conn = DriverManager.getConnection(strConn, strUser, strPassword);
Statement st = conn.createStatement();
return st.executeQuery(strSql);
} public int executeUpdate(String strSql)
throws SQLException
{
int nRetValue = -1;
conn = DriverManager.getConnection(strConn, strUser, strPassword);
Statement st = conn.createStatement();
nRetValue = st.executeUpdate(strSql);
st.close();
conn.close();
return nRetValue;
}
}
解决方案 »
- Hibernate 递归实现树形结构
- 新手提问:jsp获取日期的问题?
- Hibernate 2 级 缓存问题??
- 如何用JAVA模拟用户登陆网站系统?
- 菜鸟问一个很简单的问题,请高手帮忙!在线等!
- 求cvs 使用问题
- Calendar取得每个月的最后一天。明明这个月只有30天,为什么会结果会是31了,奇怪了
- 高分求如何写一个BEAN
- Tomcat + win2000 + IE6.0 修改JSP,关于页面显示不刷新的问题。
- Struts2和Hibernate保存带外键的数据库对象
- 如何解决TABLE中行数不确定的问题?急!!
- 在Action中如何得到Form的全部值,一共涉及到3个table大约有30来个字段
ServletContext sc = this.servlet.getServletContext;
DataSource ds = (DataSource)sc.getAttribute(key); 这里的key为struts配置的数据库的key值。