package firm;
import java.sql.*;public class firm {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:firm";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null; public firm() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("firm(): " + 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 e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}
import java.sql.*;public class firm {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:firm";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null; public firm() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("firm(): " + 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 e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}
解决方案 »
- 求解异样解决方案
- java web程序如何调用后台运行的jar程序中的对象?
- java做一个按钮或连接点击后下载本地的某个文件
- 收藏 不显示删除回复显示所有回复显示星级回复显示得分回复 struts2里面我在action 里面返回一段拼写好的json格式的字符,在页面怎么用脚本获取值在显
- 用Bean连接数据库连接池,不知道行不行?
- 新手请教功能实现
- 请问一个关于eclipse中启tomcat的问题
- 新手问:<input type="button" value="测试" onclick='test(1)'>这里调用test函数能用参数吗?例如:...onclick='test(' + 标签值 + ')'>
- 请帮帮菜鸟谢谢!
- SOS!急!!!做一个购物网项目到后期,评论的回复方法不会写!
- 急急--如何去结果集的纪录条数 在线等
- 在javaScript中如何使用jsp(服务器端)中定义的变量,
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%><jsp:useBean id="coon" class="com.cn"/>
<%
try{
String sql="select * form user";
ResultSet rs=coon.executeQuery(sql);
while(rs.next()){
out.println(rs.getString(1)+"<br/>");
}
}catch(Exception e){
e.printStackTrace();
}
%>
数据库可以用其他的方法啊,写个servlet或者是用一个辅助类。还可以采用过滤器。不能强行加在一个类里面就认为是javaBean啊。