时间: 2021-07-31 作者:daque
1、创造一个beanpackage guestbook;import java.sql.*;/*** title:用javabean贯穿数据库* description:用bean把常用的数据库功效封装,在jsp中证明该bean。* copyright: copyright (c) 2001* company:极速搜集小组* 编者:极速搜集小组* version 1.0*/public class sql_data{ string sdbdriver="sun.jdbc.odbc.jdbcodbcdriver"; string sconnstr="jdbc:odbc:guestbook"; connection conn=null; resultset rs=null; public sql_data() { try{ class.forname(sdbdriver); } catch(java.lang.classnotfoundexception e) { system.err.println("sql_data():"+e.getmessage()); } } public void executeinsert(string sql) { try { conn=drivermanager.getconnection(sconnstr); statement stmt=conn.createstatement(); stmt.executeupdate(sql); } catch(sqlexception ex) { system.err.println("sql_data.executeupdate:"+ex.getmessage()); } } public resultset executequery(string sql) { rs=null; try { conn=drivermanager.getconnection(sconnstr); statement stmt=conn.createstatement(); rs=stmt.executequery(sql); } catch(sqlexception ex) { system.err.println("sql_data.executequery:"+ex.getmessage()); } } public void executedelete(string sql) { try { conn=drivermanager.getconnection(sconnstr); statement stmt=conn.createstatement(); stmt.executeupdate(sql); } catch(sqlexception ex) { system.err.println("sql_data.executedelete:"+ex.getmessage()); } }}2、在jsp中证明bean:……<jsp:usebean id="sqlbean" scope="session" class="guestbook.sql_data"/><%!string sql,name;%><%sql="select * from table";resultset rs=sqlbean.executequery(sql);while(rs.nex()){ name=rs.getstring("name")}%>……name:<%=name%>……<%rs.close();%>……