Jsp,JavaBean,Mysql的连接方法
利用JSP实现Web与数据库的连接: (1).完成环境设置,导入java.sql包,命令如下: import java.sql.* (2).载入驱动器 (3).连接到数据库 (4).语句接口 (5).获得结果集 1. 测试环境:
windows 2003 j2sdk1.4.2_06 Tomcat 5.0 mysql-4.0.23-win mm.mysql-2.0.4-bin.jar 2. 建立数据库及表 在Mysql中建个publish数据库,并建个book表。在book中添加id,title,price 3. JavaBean的代码: dbconn.java package Border; import java.sql.*; //完成环境设置,导入java.sql包 public class dbconn { public dbconn() { } //declare variable private Connection conn = null; private ResultSet rs = null private String server = "127.0.0.1"; // Can''''t use localhost , you must use IP or CNAME private String port = "3306"; //change to your port private String db = "publish"; //change to your db name private String user = "root"; //change to your username private String pass = "root"; //change to your password private String drivername="org.gjt.mm.mysql.Driver"; //mysql driver private String URL="jdbc:mysql://"+server+":"+port+"/"+db+"?useUnicode=true&characterEncoding=GBK&user="+user+"&password="+pass; public Connection getConn(){ //get database connection try{ Class.forName(drivername).newInstance(); //载入驱动器 conn = DriverManager.getConnection(URL); //连接到数据库 } catch(Exception e){ e.printStackTrace(); } return conn ; } public ResultSet executeSQL(String str) { try{ Statement stmt = conn.createStatement(); //语句接口 rs = stmt.executeQuery(str); //获得结果集 } catch(Exception e){ e.printStackTrace(); } return rs; } } 编译javac dbconn.java,将编译后的文件dbconn.class放到目录 "你的项目"\WEB-INF\classes\Border\下
4. 调用Java Bean的JSP文件test.jsp
<%@ page contentType="text/html;charset=GBK" import="java.sql.*"%>
<jsp:useBean id="Border" scope="page" class="Border.dbconn" /> <% ResultSet rs = null; Connection conn = null; conn = Border.getConn() ; rs = Border.executeSQL("select * from book"); %> <html> <body> <br> <h2 align="center" > My first Jsp JavaBean Mysql </h2> <br> <table border="1" align="center"> <tr> <th> id </th> <th> title </th> <th> price </th> </tr> <% while(rs.next()) { %> <tr> <th> <%=rs.getString("id")%> </th> <th> <%=rs.getString("title")%> </th> <th> <%=rs.getString("price")%> </th> </tr> <%}%> <% rs.close(); conn.close(); %> </table> <form name="form1" method="post" action="update.jsp"> <table width="210" border="1" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="77">title:</td> <td width="127"><label> <input name="Title" type="text" id="Title"> </label></td> </tr> <tr> <td>price:</td> <td><label> <input name="Price" type="text" id="Price"> </label></td> </tr> <tr> <td><div align="right"> <label> <input type="submit" name="Submit" value="提交"> </label> </div></td> <td> [1] [2] 下一页 [Web开发]JSP入门学习经验总结 [Web开发]JSP 2.0下的动态内容缓存分析讲解 [Web开发][JSP] 循序渐进教程 [Web开发]纯 jsp 操作服务器上的文本文件 [Web开发]JSP: 调用servlet 显示图片 [Web开发]Jsp + JavaBean循序渐进教程(二) [Web开发]Jsp + JavaBean循序渐进教程(三) [Web开发]Jsp + JavaBean循序渐进教程(四)上 [Web开发]Jsp + JavaBean循序渐进教程(四)下 [Web开发]Jsp + JavaBean循序渐进教程(一)
|