还有一个错误没有解决,数据库的连接DBConn没有问题,可以编译生成class文件,就是下边的操作文件DBResult.java总是编译错,找不到错在哪里??
-------------------------------------------
错误信息:
javac DBResult.javaDBResult.java:12: unreported exception java.lang.Exception; must be caught or de
clared to be thrown
this.con=DBConn.getConnection();
^
1 error
---------------------------------------------
//数据库连接的DBConn.java
package com.mingri.dbconn; import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource; public class DBConn
{
public static synchronized Connection getConnection() throws Exception{
try{
Context initCtx=new javax.naming.InitialContext();
//从Context中lookup数据源
Context envCtx=(Context)initCtx.lookup("java:comp/env");
DataSource ds=(DataSource)envCtx.lookup("jdbc/mingri");
return ds.getConnection();
}
catch(SQLException e){
throw e;
}
catch(NamingException e){
throw e;
}
}
}
--------------------------------------------------
//数据库操作DBResult.javapackage com.mingri.dbconn;import java.sql.*;import javax.naming.*;public class DBResult
{
private Connection con;
public DBResult(){
try{
this.con=DBConn.getConnection();
}
catch(SQLException ex){}
catch(NamingException ex){ }
}
/**
* 用于获得执行SQL语句的ResultSet对象
*/
public ResultSet getResult(String sql){
try{
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
return rs;
}
catch(Exception e){}
return null;
}
/**
* 用于执行SQL语句没有返回值
*/
public void doExecute(String sql){
try{
Statement stmt=con.createStatement();
stmt.executeQuery(sql);
}catch(Exception e){}
}
/**
* 用于获得执行SQL语句的PreparedStatement(预处理)对象
*/
public PreparedStatement getPreparedStatement(String sql){
try{
PreparedStatement pstmt=con.prepareStatement(sql);
return pstmt;
}
catch(Exception e){}
return null;
}
/**
* 关闭连接
*/
public void closeCon(){
try{
this.con.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
-------------------------------------------
错误信息:
javac DBResult.javaDBResult.java:12: unreported exception java.lang.Exception; must be caught or de
clared to be thrown
this.con=DBConn.getConnection();
^
1 error
---------------------------------------------
//数据库连接的DBConn.java
package com.mingri.dbconn; import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource; public class DBConn
{
public static synchronized Connection getConnection() throws Exception{
try{
Context initCtx=new javax.naming.InitialContext();
//从Context中lookup数据源
Context envCtx=(Context)initCtx.lookup("java:comp/env");
DataSource ds=(DataSource)envCtx.lookup("jdbc/mingri");
return ds.getConnection();
}
catch(SQLException e){
throw e;
}
catch(NamingException e){
throw e;
}
}
}
--------------------------------------------------
//数据库操作DBResult.javapackage com.mingri.dbconn;import java.sql.*;import javax.naming.*;public class DBResult
{
private Connection con;
public DBResult(){
try{
this.con=DBConn.getConnection();
}
catch(SQLException ex){}
catch(NamingException ex){ }
}
/**
* 用于获得执行SQL语句的ResultSet对象
*/
public ResultSet getResult(String sql){
try{
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
return rs;
}
catch(Exception e){}
return null;
}
/**
* 用于执行SQL语句没有返回值
*/
public void doExecute(String sql){
try{
Statement stmt=con.createStatement();
stmt.executeQuery(sql);
}catch(Exception e){}
}
/**
* 用于获得执行SQL语句的PreparedStatement(预处理)对象
*/
public PreparedStatement getPreparedStatement(String sql){
try{
PreparedStatement pstmt=con.prepareStatement(sql);
return pstmt;
}
catch(Exception e){}
return null;
}
/**
* 关闭连接
*/
public void closeCon(){
try{
this.con.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
解决方案 »
- 关于struts2上传文件类型限制的配置问题
- 问个非常基础的问题
- 可以在javascript中操纵javaBean吗?
- 一个新手的问题
- include指令引入一个*.html后,出现乱码现象,怎么解决?
- 在 Struts 的 Model-View-Controller 中,如果 TestFormBean 的全部属性 与 TestModelBean 里面的全部属性相一致,TestModelBean 与 Test
- 明年大家都有好钱途!200,散掉!
- 求助!在Applet里面写框架结构~
- 急求jspSmartUpload.zip
- TOMCAT4服务器配置虚拟目录问题???
- 搞了一个星期还是不行,大家帮忙看下!JSP数据库操作问题?
- Context的lookup()函数的实现
clared to be thrown 错误提示很清楚呀。public class DBResult throws Exception{ must be caught or declared to be thrown
{
try
{
this.con = DBConn.getConnection();
}
catch (SQLException ex)
{
}
catch (NamingException ex)
{
}
catch (Exception e)
{
}
}