下面是小弟写的,可以用,但是,在关闭那里,我觉得还有问题。package bxconn;
import java.io.*;
import java.sql.*;
import javax.sql.*;
import java.util.*;
import java.lang.Boolean;
import net.sourceforge.jtds.jdbc.Driver.*;
public class connPool{String dbUrl="proxool.test:net.sourceforge.jtds.jdbc.Driver:jdbc:jtds:sqlserver://localhost:1433/lzudata;user=sa;password=00000000";
ResultSet rs=null;
Statement stmt;
Connection connection=null;
public void connPool(){
try {
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
} catch (Exception e) {
System.out.println(e);
}
}
//查询数据库public ResultSet executeQuery(String sql){
rs=null;
try{
connection=DriverManager.getConnection(dbUrl);
Statement stmt=connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(sql);}catch(SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
//插入数据库
public boolean executeUpdate(String sql){
boolean a=false;
try{
connection=DriverManager.getConnection(dbUrl);
Statement stmt=connection.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE,java.sql.ResultSet.CONCUR_UPDATABLE);
int b=stmt.executeUpdate(sql);
if(b!=0) a=true;
}catch(SQLException ex)
{
System.err.println("aq.executeUpdate:"+ex.getMessage());
}
return a;
}
public void close() throws Exception
{
if (stmt != null) {
stmt.close();
}
if(connection != null){
connection.close();
}
}}关闭部分是不是应该用以下写法?还有其他地方,是不是有不完善的地方?finally
{if (rst != null)
{
try
{
rst.close();
}
catch (SQLException ex1)
{
ex1.printStackTrace();
}
}if (pstm != null)
{
try
{
pstm.close();
}
catch (SQLException ex2)
{
ex2.printStackTrace();
}
}if (conn != null)
{
try
{
conn.close();
}
catch (SQLException ex3)
{
ex3.printStackTrace();
}
}
}
import java.io.*;
import java.sql.*;
import javax.sql.*;
import java.util.*;
import java.lang.Boolean;
import net.sourceforge.jtds.jdbc.Driver.*;
public class connPool{String dbUrl="proxool.test:net.sourceforge.jtds.jdbc.Driver:jdbc:jtds:sqlserver://localhost:1433/lzudata;user=sa;password=00000000";
ResultSet rs=null;
Statement stmt;
Connection connection=null;
public void connPool(){
try {
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
} catch (Exception e) {
System.out.println(e);
}
}
//查询数据库public ResultSet executeQuery(String sql){
rs=null;
try{
connection=DriverManager.getConnection(dbUrl);
Statement stmt=connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(sql);}catch(SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
//插入数据库
public boolean executeUpdate(String sql){
boolean a=false;
try{
connection=DriverManager.getConnection(dbUrl);
Statement stmt=connection.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE,java.sql.ResultSet.CONCUR_UPDATABLE);
int b=stmt.executeUpdate(sql);
if(b!=0) a=true;
}catch(SQLException ex)
{
System.err.println("aq.executeUpdate:"+ex.getMessage());
}
return a;
}
public void close() throws Exception
{
if (stmt != null) {
stmt.close();
}
if(connection != null){
connection.close();
}
}}关闭部分是不是应该用以下写法?还有其他地方,是不是有不完善的地方?finally
{if (rst != null)
{
try
{
rst.close();
}
catch (SQLException ex1)
{
ex1.printStackTrace();
}
}if (pstm != null)
{
try
{
pstm.close();
}
catch (SQLException ex2)
{
ex2.printStackTrace();
}
}if (conn != null)
{
try
{
conn.close();
}
catch (SQLException ex3)
{
ex3.printStackTrace();
}
}
}
解决方案 »
- 有没有什么工具或软件能对比一下同一个项目但不同版本之间的区别?
- tomcat服务内最多能运行多少Thread对象
- Java导入*.sql实现方法?
- 为啥第一页的数据插不进,而第二页的数据可以阿?
- 新手的问题——new InitialContext()
- 水晶报表中定义一个空的文本框(TextObject),JSP中如何为其赋值??
- 再问一下关于:java中两个数组的交集怎么求?
- 如何实现“推荐给朋友”这个功能,即将文章发送到朋友的邮箱中。
- JSP之间协调的问题。
- WINDOWS下做的jsp+servlet+javabean能够直接移植到linux系统中去吗?
- 在JSF 里,我有一个错误是在调用ACTION后输出,然后那个错误信息有图片和文字,我该用哪个组件?
- xml 超级简单问题 schemaLocation jdom
{
finally
{if (rs != null)
{
try
{
rs.close();
}
catch (SQLException ex1)
{
ex1.printStackTrace();
}
}if (stmt != null)
{
try
{
stmt.close();
}
catch (SQLException ex2)
{
ex2.printStackTrace();
}
}if (connection != null)
{
try{
connection.close();
}catch (SQLException ex3){
ex3.printStackTrace();
}
}
}
/*
if (stmt != null) {
stmt.close();
}
if(connection != null){
connection.close();
}
*/
}}这样写错在哪里?