javaweb连接oracle数据库

javaWEB项目与普通java项目在连接oracle数据库上似乎略有不同。

普通java项目直接将ojdbc.jar构建路径即可；

而javaweb项目却可能并不能运行，需要再设置一下：

项目名上右键点击→属性→Deployment Assembly→Add→java Build Path Entries →ojdbc.jar,最后确定，重新运行项目。

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54

package dal;   import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;   public class OracleHelper {       static final String DB_USER="sys as sysdba";     static final String DB_PWD="******";     static final String ORCL_URL="jdbc:oracle:thin:@localhost:1521/orcl";     public String getUser(String findEmpno){               Connection con=null;         PreparedStatement pre=null;         ResultSet result=null;         String nameInOrcl=null;         try{             Class.forName("oracle.jdbc.driver.OracleDriver");             con=DriverManager.getConnection(ORCL_URL,DB_USER,DB_PWD);             String sql="select empname from t_emp where empno=?";             pre=con.prepareStatement(sql);             pre.setString(1,findEmpno);                     result=pre.executeQuery();                  while(result.next()){                       nameInOrcl=result.getString("empname");                 }                       }catch(Exception ex){             System.out.println("未能返回结果");         }finally{             try {                 result.close();             } catch (SQLException e) {                 System.out.println("关闭记录集失败");             }             try {                 pre.close();             } catch (SQLException e) {                 System.out.println("关闭控制器失败");             }             try {                 con.close();             } catch (SQLException e) {                 System.out.println("关闭连接失败");             }           }               return nameInOrcl;     }             }