📄 java研究组织 - 精品文章 - 使用jboss和postgresql-----快速开发ejb和j2ee web application.htm

📁 行业分类数据库管理系统
💻 HTM
📖 第 1 页 / 共 5 页
字号:
                          class=classLink><U>SQLException</U></FONT></A></B>; 
                          <LI><B><FONT 
                          color=#0000ff>import</FONT></B>&nbsp;java.sql.<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/sql/Statement.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>Statement</U></FONT></A></B>; 
                          <LI><B><FONT 
                          color=#0000ff>import</FONT></B>&nbsp;java.sql.<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/sql/ResultSet.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>ResultSet</U></FONT></A></B>; 
                          <LI>
                          <LI><B><FONT 
                          color=#0000ff>import</FONT></B>&nbsp;javax.naming.<B><A 
                          href="http://www.javaresearch.org/source/jdk142/javax/naming/InitialContext.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>InitialContext</U></FONT></A></B>; 
                          <LI><B><FONT 
                          color=#0000ff>import</FONT></B>&nbsp;javax.sql.<B><A 
                          href="http://www.javaresearch.org/source/jdk142/javax/sql/DataSource.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>DataSource</U></FONT></A></B>; 
                          <LI>
                          <LI>
                          <LI><B><FONT 
                          color=#0000ff>public</FONT></B>&nbsp;<B><FONT 
                          color=#0000ff>class</FONT></B>&nbsp;MysqlDao&nbsp;{ 
                          <LI>
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;<B><FONT 
                          color=#0000ff>public</FONT></B>&nbsp;<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/sql/Connection.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>Connection</U></FONT></A></B>&nbsp;getConnection()&nbsp;<B><FONT 
                          color=#0000ff>throws</FONT></B>&nbsp;<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/lang/Exception.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>Exception</U></FONT></A></B>&nbsp;{ 

                          <LI>
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><A 
                          href="http://www.javaresearch.org/source/jdk142/javax/naming/InitialContext.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>InitialContext</U></FONT></A></B>&nbsp;ctx&nbsp;=&nbsp;<B><FONT 
                          color=#0000ff>new</FONT></B>&nbsp;<B><A 
                          href="http://www.javaresearch.org/source/jdk142/javax/naming/InitialContext.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>InitialContext</U></FONT></A></B>(); 

                          <LI>
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><A 
                          href="http://www.javaresearch.org/source/jdk142/javax/sql/DataSource.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>DataSource</U></FONT></A></B>&nbsp;ds&nbsp;=&nbsp;(<B><A 
                          href="http://www.javaresearch.org/source/jdk142/javax/sql/DataSource.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>DataSource</U></FONT></A></B>)&nbsp;ctx.lookup(<FONT 
                          color=#ff33ff>"java:/PostgresDS"</FONT>); 
                          <LI>
                          <LI>
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/sql/Connection.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>Connection</U></FONT></A></B>&nbsp;conn&nbsp;=&nbsp;<B><FONT 
                          color=#0000ff>null</FONT></B>; 
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/sql/Statement.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>Statement</U></FONT></A></B>&nbsp;stmt&nbsp;=&nbsp;<B><FONT 
                          color=#0000ff>null</FONT></B>; 
                          <LI>
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><FONT 
                          color=#0000ff>try</FONT></B>&nbsp;{ 
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;conn&nbsp;=&nbsp;ds.getConnection(); 

                          <LI>
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;<B><FONT 
                          color=#0000ff>catch</FONT></B>&nbsp;(<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/sql/SQLException.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>SQLException</U></FONT></A></B>&nbsp;sqlEx)&nbsp;{ 

                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/lang/System.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>System</U></FONT></A></B>.out.println(<FONT 
                          color=#ff33ff>"Error&nbsp;connect&nbsp;to&nbsp;pool."</FONT>); 

                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} 
                          <LI>
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><FONT 
                          color=#0000ff>return</FONT></B>&nbsp;conn; 
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;} 
                          <LI>
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;<B><FONT 
                          color=#0000ff>public</FONT></B>&nbsp;<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/lang/String.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>String</U></FONT></A></B>&nbsp;getName(<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/lang/String.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>String</U></FONT></A></B>&nbsp;id)&nbsp;<B><FONT 
                          color=#0000ff>throws</FONT></B>&nbsp;<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/lang/Exception.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>Exception</U></FONT></A></B>&nbsp;{ 

                          <LI>
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/sql/Connection.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>Connection</U></FONT></A></B>&nbsp;conn&nbsp;=&nbsp;<B><FONT 
                          color=#0000ff>null</FONT></B>; 
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/sql/Statement.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>Statement</U></FONT></A></B>&nbsp;stmt&nbsp;=&nbsp;<B><FONT 
                          color=#0000ff>null</FONT></B>; 
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/sql/ResultSet.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>ResultSet</U></FONT></A></B>&nbsp;rs&nbsp;=&nbsp;<B><FONT 
                          color=#0000ff>null</FONT></B>; 
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/lang/String.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>String</U></FONT></A></B>&nbsp;name&nbsp;=&nbsp;<FONT 
                          color=#ff33ff>""</FONT>; 
                          <LI>
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><FONT 
                          color=#0000ff>try</FONT></B>&nbsp;{ 
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;conn&nbsp;=&nbsp;getConnection(); 

                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><FONT 
                          color=#0000ff>if</FONT></B>&nbsp;(&nbsp;conn&nbsp;!=<B><FONT 
                          color=#0000ff>null</FONT></B>&nbsp;)<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/lang/System.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>System</U></FONT></A></B>.out.println(<FONT 
                          color=#ff33ff>"Get&nbsp;conecttion.&nbsp;"</FONT>+&nbsp;conn.toString()); 

                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;stmt&nbsp;=&nbsp;conn.createStatement(); 

                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><FONT 
                          color=#0000ff>if</FONT></B>&nbsp;(&nbsp;stmt&nbsp;!=<B><FONT 
                          color=#0000ff>null</FONT></B>&nbsp;)<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/lang/System.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>System</U></FONT></A></B>.out.println(<FONT 
                          color=#ff33ff>"Get&nbsp;Statement.&nbsp;"</FONT>+&nbsp;stmt.toString()); 

                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/lang/String.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>String</U></FONT></A></B>&nbsp;sql&nbsp;=&nbsp;<FONT 
                          color=#ff33ff>"SELECT&nbsp;*&nbsp;from&nbsp;users&nbsp;where&nbsp;id&nbsp;=&nbsp;'"</FONT>+id+<FONT 
                          color=#ff33ff>"'"</FONT>; 
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/lang/System.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>System</U></FONT></A></B>.out.println(<FONT 
                          color=#ff33ff>"Sql&nbsp;from&nbsp;getId():&nbsp;"</FONT>+sql); 

                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rs&nbsp;=&nbsp;stmt.executeQuery(sql); 

                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><FONT 
                          color=#0000ff>if</FONT></B>&nbsp;(&nbsp;rs&nbsp;!=<B><FONT 
                          color=#0000ff>null</FONT></B>&nbsp;)<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/lang/System.java.html" 
                          target=_blank><FONT 
                          class=classLink><U>System</U></FONT></A></B>.out.println(<FONT 
                          color=#ff33ff>"Get&nbsp;result.&nbsp;"</FONT>); 
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><FONT 
                          color=#0000ff>if</FONT></B>&nbsp;(rs.next()){ 
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name&nbsp;=&nbsp;rs.getString(<FONT 
                          color=#ff33ff>"name"</FONT>); 
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} 

                          <LI>
                          <LI>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;<B><FONT 
                          color=#0000ff>catch</FONT></B>&nbsp;(<B><A 
                          href="http://www.javaresearch.org/source/jdk142/java/lang/Exception.java.html"
⌨️ 快捷键说明

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