jdbc连接池与数据源.docVIP

JDBC连接池与数据源 JDBC回顾 实例5-01 安装和配置Oracle的JDBC驱动程序 实例5-02 JDBC操作Oracle数据库的例子 Sqlplus u1/yishugao Create table muyser (username varchar2(20), Password varchar2(20)); 或使用Oracle SQL Developer Jdbcexample项目--右键--bulidpath--configure bulid path--libraries--add library---user library JDBCExample.java package com.v512.example; import java.sql.*; public class JDBCExample { public static void main(String[] args) { String driver = oracle.jdbc.driver.OracleDriver; String url = jdbc:oracle:thin:@localhost:1521:ORCL; String username = U1; String password = yishugao; String sql = insert into myuser(username,password) values(?,?); try { Class.forName(driver); // new oracle.jdbc.driver.OracleDriver(); Connection conn = DriverManager.getConnection(url, username, password); // Statement stat=conn.createStatement(); PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, LiuWei);// 用户名 pstmt.setString(2, yishugao);// 密码 pstmt.executeUpdate(); pstmt = conn.prepareStatement(select * from myuser); ResultSet rs=pstmt.executeQuery(); while (rs.next()) { System.out.print(rs.getString(username)); System.out.print( ); System.out.println(rs.getString(password)); } rs.close(); pstmt.close(); conn.close(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } } 实例5-03 网络留言板v1.0 Oracle sql developer 新建序列来产生编号 拷贝fckeditor和js 修改validation-framework.js里的var ValidationRoot = /guestbook/js/; 使用dreamweaver编写addMessage.html !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN /TR/xhtml1/DTD/xhtml1-transitional.dtd html xmlns=/1999/xhtml head meta http-equiv=Content-Type content=text/html; charset=utf-8 / titleadd Message/title /head body script type=text/javascript src=/guestbook/js/validation-framework.js/script !-- script type=text/javascript src=/guestbook/fckeditor/fckeditor.js/script -- script type=text/javas