信息发布界面 提供发布信息的交互界面,调用 recordMessage.jsp程序。 sayMessage.jsp <% @ page contentType=“ text/html; charset=GB2312”% > <% @ page language=“ java” import=“ java .sql .*”% > 连接数据库 通过调用 Java Bean连接 Oracle数据库。 opDb.java package ymbean; // java包 import java.sql.* ; public class opDb { public opDb() { } public ResultSet executeQuery(String sql) { ResultSet rs = null; Statement lstmt = null; try { lstmt = connectdb(); rs = lstmt.executeQuery(sql); System.out.println(“ executeQuery:”+ sql); } catch(SQLException ex) { return(null); } return rs; } public String executeUpdate(String sql) { ResultSet rs = null; Statement lstmt = null; try { lstmt = connectdb(); lstmt.executeUpdate(sql); System.out.println(“ executeUpdate:”+ sql); lstmt.executeUpdate(“ commit” ); }catch(SQLException ex) {} return(“ executeUpdate ok” ); } //连接数据库 public Statement connectdb() { Statement lstmt=null; Connection conn=null; final String connect_string=“ jdbc:oracle:thin:scott/tiger@192.168.0.1:1521:test” ; final String driver_string=“ oracle.jdbc.driver. OracleDriver” ; Connection lconn; try { Class.forName(driverstr); lconn=DriverManager.getConnection(connectstr); lstmt=lconn.createStatement(); } catch (Exception e) { return(null);} return lstmt; } }//end opDb.java |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 15:22 , Processed in 0.155914 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.