📄 jsp-querybean.htm

📁 写给JSP初级程序员的书
💻 HTM
字号:
<html><!-- #BeginTemplate "/Templates/more.dwt" -->
<head>
<!-- #BeginEditable "doctitle" --> 
<title>csdn_利用javabean轻松实现对数据库的连接、查询以及增删改</title>
<!-- #EndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE type=text/css>
A:link {
	COLOR: #000000; FONT-FAMILY:verdana,宋体,新宋体; TEXT-DECORATION: none
}
A:visited {
	COLOR: #333399; FONT-FAMILY:verdana,宋体,新宋体; TEXT-DECORATION: none
}
A:active {
	COLOR: #ff0000; FONT-FAMILY:verdana,宋体,新宋体; TEXT-DECORATION: none
}
A:hover {
	COLOR: black; TEXT-DECORATION: underline
}
BODY {
	 COLOR: #000000; FONT-SIZE:9pt; LETTER-SPACING: normal; LINE-HEIGHT: 150%; WORD-SPACING: 2em
}
TH {
	FONT-SIZE: 9pt
}
TD {
	FONT-SIZE: 9pt
}
TD.page {
	COLOR: #000000; FONT-SIZE:9pt; LETTER-SPACING: normal; LINE-HEIGHT: 150%; WORD-SPACING: 2em
}
TD.title {
	COLOR: #000000; FONT-FAMILY:verdana,宋体,新宋体
}
TD.detail {
	COLOR: #9966ff; FONT-FAMILY:verdana,宋体,新宋体
}
</STYLE>

</head>

<body bgcolor="#FFFFFF" text="#000000" >
<div align="center"></div>
<table width="700" border="0" align="center">
  <tr> 
    <table width="700" border="1" cellpadding="1" cellspacing="0" bordercolorlight="#9898ba" bordercolordark="#000000">
        
      </table>
      
      <br>
      <table width="700" border="0">
        <tr> 
          <td width="20">&nbsp;</td>
          <td colspan="2"> 
            <div align="center">
              <h3><b><!-- #BeginEditable "5" -->
              <h3><font face="Verdana, Arial, Helvetica, sans-serif"><b><font>利用javabean轻松实现对数据库的连接、查询以及增删改 
                </font> </b> </font></h3>
              <!-- #EndEditable --></b></h3>
            </div>
          </td>
          <td width="20">&nbsp;</td>
        </tr>
        <tr> 
          <td width="20">&nbsp;</td>
          <td  colspan="2"><!-- #BeginEditable "6" --><br>
            <br>
            我们在做jsp开发的时候，经常需要对数据库进行查询及增删改，而这些操作使用的又<br>
            是非常频繁，因此，我写了一个javabean，来实现与数据库的连接以及对数据库的增删改。<br>
            pacakage operate_db;<br>
            /**<br>
            * Title: select insert update and delete<br>
            * Description: select insert update and delete<br>
            * Copyright: Copyright (c) 2001<br>
            * @author Lci21<br>
            * @version 1.0<br>
            */<br>
            import java.sql.*;<br>
            public class QueryBean<br>
            { <br>
            public String query_statement; /*定义sql语句*/<br>
            public String param[]; /*查询条件,或者是新的记录*/<br>
            public ResultSet result=null; <br>
            public Connection conn;<br>
            <br>
            public void setParam(String[] param)<br>
            {<br>
            this.param=param;<br>
            }<br>
            public void setQuerystatement(String query_statement)<br>
            {<br>
            this.query_statement=query_statement;<br>
            }<br>
            public void setConnection(String driverName,String jdbcURL,String 
            username,String passwd) throws Exception<br>
            {<br>
            Connection conn1;<br>
            Class.forName(driverName);<br>
            conn1=DriverManager.getConnection(jdbcURL,username,passwd);<br>
            conn1.setAutoCommit(false);<br>
            this.conn = conn1;<br>
            }<br>
            /*获取查询结果*/<br>
            public ResultSet getResult() <br>
            {<br>
            try<br>
            {<br>
            PreparedStatement select_stm=conn.prepareStatement(query_statement,java.sql.ResultSet.TYPE_SCROLL_INS<br>
            ENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);<br>
            if (param!=null)<br>
            for(int i=0;i&lt;param.length;i++)<br>
            select_stm.setString(i+1,param[i]);<br>
            result=select_stm.executeQuery(); <br>
            }catch(Exception e){System.out.println(e);}<br>
            return result;<br>
            }<br>
            <br>
            /*对数据库进行增加记录操作*/ <br>
            public void insertRecord() throws SQLException,java.io.UnsupportedEncodingException<br>
            {<br>
            try<br>
            {<br>
            PreparedStatement insert_stm=conn.prepareStatement(query_statement);<br>
            if (param!=null)<br>
            for(int i=0;i&lt;param.length;i++)<br>
            insert_stm.setString(i+1,param[i]);<br>
            insert_stm.executeUpdate();<br>
            insert_stm.close();<br>
            conn.commit();<br>
            }<br>
            catch(Exception e)<br>
            {<br>
            System.out.println(e);<br>
            conn.rollback();<br>
            } <br>
            }<br>
            <br>
            /*对数据记录进行更改操作*/ <br>
            public void updateRecord() throws SQLException,java.io.UnsupportedEncodingException<br>
            {<br>
            try<br>
            {<br>
            PreparedStatement update_stm=conn.prepareStatement(query_statement);<br>
            if (param!=null)<br>
            for (int i=0;i&lt;param.length;i++)<br>
            update_stm.setString(i+1,param[i]);<br>
            update_stm.executeUpdate();<br>
            update_stm.close();<br>
            conn.commit();<br>
            }<br>
            catch(Exception e)<br>
            {<br>
            System.out.println(e);<br>
            conn.rollback();<br>
            }<br>
            }<br>
            /*删除数据记录*/ <br>
            public void deleteRecord() throws SQLException,java.io.UnsupportedEncodingException<br>
            {<br>
            try<br>
            {<br>
            PreparedStatement delete_stm=conn.prepareStatement(query_statement);<br>
            if (param!=null)<br>
            for (int i=0;i&lt;param.length;i++)<br>
            delete_stm.setString(i+1,param[i]);<br>
            delete_stm.executeUpdate();<br>
            delete_stm.close();<br>
            conn.commit();<br>
            }<br>
            catch(Exception e)<br>
            {<br>
            System.out.println(e);<br>
            conn.rollback();<br>
            }<br>
            } <br>
            }<br>
            以下给简单地给出了使用的范例，请参考：<br>
            &lt;%@ page contentType=&quot;text/html&quot; import=&quot;operate_db.*,java.sql.*&quot; 
            %&gt;<br>
            &lt;jsp:useBean id=&quot;querybean&quot; scope=&quot;request&quot; 
            class=&quot;operate_db.QueryBean&quot; /&gt;<br>
            &lt;%<br>
            String prm1,prm2,prm3;<br>
            ResultSet rst=null;<br>
            prm1 = ...;<br>
            prm2 = ...;<br>
            prm3 = ...;<br>
            querybean.setConnection(&quot;sun.jdbc.odbc.JdbcOdbcDriver&quot;,&quot;jdbc:odbc:数据源名&quot;,&quot;sa&quot;,&quot;&quot;);<br>
            <br>
            try{<br>
            String[] param = {prm1,prm2,prm3};<br>
            /*设置select语句*/<br>
            querybean.setQuerystatement(&quot;Select * from table where field1 
            = ? and field2=? and field3=?&quot;);<br>
            querybean.setParam(param);<br>
            rst=querybean.getResult();<br>
            }catch(Exception e){System.out.println(e); }<br>
            while (rst.next()){<br>
            %&gt;&lt;%=rst.getString(1)%&gt;<br>
            &lt;%}%&gt;<br>
           
            <!-- #EndEditable --></td>
          <td width="20">&nbsp;</td>
        </tr>
        <tr> 
          <td width="20" height="11">&nbsp;</td>
          <td width="541" height="11"><!-- #BeginEditable "7" --><!-- #EndEditable --></td>
          <td width="101" height="11"> 
            
          </td>
          <td width="20" height="11">&nbsp;</td>
        </tr>
      </table><div align="center"> <br>
      </div>
      
    </td>
  </tr>
</table>
<div align="center"> 
  
  <br>
</div>
</body>
<!-- #EndTemplate --></html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -