第七章JDBC连接数据库总汇.ppt

Resource name = jdbc/mysql auth = Container type = javax.sql.DataSource driverClassName = com.mysql.jdbc.Driver url = jdbc:mysql://localhost:3306/test username = root password = maxActive = 100 maxIdle = 30 maxWait = 10000 / /Context Web.xml resource-ref descriptionOracle Datasource example/description res-ref-namejdbc/mysql/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref 注: 1.在tomcat 5.5以后的版本不写也可以 2.驱动程序需放在服务器lib目录下 try{ javax.naming.InitialContext ctx = new javax.naming.InitialContext(); javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup(java:comp/env/jdbc/mysql); conn = ds.getConnection(); preparedStmt =conn.prepareStatement(select customerid,address,phone from customer where firstname like ? ); //设置参数 String parm= request.getParameter(parm); preparedStmt.setString(1, %+parm+%); //执行Sql语句 sqlRst=preparedStmt.executeQuery (); % 程序7－6：test2.jsp（片段） JDBC工作原理 通过JDBC对数据库执行SQL语句 基于数据源访问数据库 高级开发技巧√ BLOB字段的处理 // 执行Sql语句 sqlRst=Stmt.executeQuery ( SQLString); while(sqlRst.next()){ java.sql.Blob blob=sqlRst.getBlob( data ); byte[] ab = blob.getBytes(1, (int)blob.length()); response.setContentType(image/gif); response.reset(); op.write(ab); op.flush(); op.close(); } Stmt.close (); conn.close(); 程序7－7：ShowImage.java（片段） //添加图片到数据库 javax.naming.InitialContext ctx = new javax.naming.InitialContext(); javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup(java:/MySqlDS); conn = ds.getConnection(); String filelocation =request.getParameter(file); File files = new File(filelocation); FileInputStream fis=new FileInputStream(files); preparedStmt = conn.prepareStatement( INSERT INTO album (name,data) + VALUES (?, ?)); //预编译SQL语句 preparedStmt.setSt