主题:[原创]用连接池操作时报错,请大家帮我看看!!
我的代码:
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;
public class DBConnection {
private Connection conn = null;
private Statement stmt = null;
private ResultSet rs = null;
private int resultNum = 0;
public static void main(String args[])
{
String sql="select * from bookinfo";
DBConnection exec=new DBConnection(sql);
}
/**
* 构造函数
* 找到数据源,并用这个数据源创建连接
*/
public DBConnection( String sql) {
try {
Context env = new InitialContext();
DataSource pool = (DataSource) env.lookup("java:comp/env/JDBC/moive");
if (pool == null)
throw new Exception("jdbc/movie is an unknown DataSource");
conn = pool.getConnection();
stmt = conn.createStatement();
if(conn!=null)
System.out.println("Success!");
}
catch (Exception e) {
System.out.println("naming:" + e.getMessage());
}
rs = null;
try {
rs = stmt.executeQuery(sql);
while(rs.next())
{
String nm=rs.getString("Name");
String prc=rs.getString("price");
System.out.println("书名:"+nm);
System.out.println("价格:"+prc);
System.out.println("");
}
}
catch(SQLException se) {
System.out.println("Query error:" + se.getMessage());
}
try{
if (conn != null)
{conn.close();
conn = null;}
}
catch (SQLException se) {
System.out.println("close error: " + se.getMessage());
}
}
}
报错是:
[img]D:\{29E18511-E24F-43D6-9B6C-2F0270651528}.BMP[/img]
请高手们指点啊,郁闷了!
我应该怎么做呢?
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;
public class DBConnection {
private Connection conn = null;
private Statement stmt = null;
private ResultSet rs = null;
private int resultNum = 0;
public static void main(String args[])
{
String sql="select * from bookinfo";
DBConnection exec=new DBConnection(sql);
}
/**
* 构造函数
* 找到数据源,并用这个数据源创建连接
*/
public DBConnection( String sql) {
try {
Context env = new InitialContext();
DataSource pool = (DataSource) env.lookup("java:comp/env/JDBC/moive");
if (pool == null)
throw new Exception("jdbc/movie is an unknown DataSource");
conn = pool.getConnection();
stmt = conn.createStatement();
if(conn!=null)
System.out.println("Success!");
}
catch (Exception e) {
System.out.println("naming:" + e.getMessage());
}
rs = null;
try {
rs = stmt.executeQuery(sql);
while(rs.next())
{
String nm=rs.getString("Name");
String prc=rs.getString("price");
System.out.println("书名:"+nm);
System.out.println("价格:"+prc);
System.out.println("");
}
}
catch(SQLException se) {
System.out.println("Query error:" + se.getMessage());
}
try{
if (conn != null)
{conn.close();
conn = null;}
}
catch (SQLException se) {
System.out.println("close error: " + se.getMessage());
}
}
}
报错是:
[img]D:\{29E18511-E24F-43D6-9B6C-2F0270651528}.BMP[/img]
请高手们指点啊,郁闷了!
我应该怎么做呢?