Windows2000Mysql4.0.13Tomcat4.1.24Jsp|peilei|Windows2000Mysql4.0.13Tomcat4.1.24Jsp &nbsp; &nbsp;hoxisoftԭ <br> &nbsp;<br>ؼ &nbsp; &nbsp; MysqlTomcatJsp <br> &nbsp;<br><br><br>ĿWindows2000Mysql4.0.13Tomcat4.1.24Jsp<br><br>ߣhoxisoft ([email]hoxisoft@263.net[/email])<br><br>ڣ2003-06-20<br><br>ԭɣϺ嫵ĻУȴҲһµMysql4.0.13Tomcat4.1.24ĵԼ֮࣬ܽԼJSPʵʾ鲢ǰ汾MysqlTomcat£дƪĵϣܸһϲJAVAĹѧοЩ·ˮƽ޼֮ʱִ٣ӭ<br><br>Ŀ¼<br><br>һ׼<br><br>װ<br><br>״ü<br><br>ġ<br><br>塢ȫ߲<br><br>˵<br><br>ߡл<br><br>ˡ˵<br><br><br>ʵֲ裺<br><br><br>һ׼<br><br>һ̨win2000 Ӳ<br><br>1.J2sdk1.4.1: [url]http://java.sun.com/j2se/1.4.1/download.html[/url]أ<br><br>2.Mysql4.0.13: [url]http://www.mysql.com[/url] ;<br><br>3.Tomcat4.1.24 [url]http://jakarta.apache.org/[/url] ;<br><br>4.mm.mysql-2.0.4-bin.jar: &nbsp;[url]http://mysql.ihostunit.com/Downloads/Contrib/mm.mysql-2.0.4-bin.jar[/url] ;<br><br><br>װ<br><br>1.װJ2sdk<br><br>հװ򵼽аװһ㰲װC:\j2sdk1.4.1£<br><br>2.װMysql:<br><br>հװ򵼽аװѡװĿ¼ΪC:\װɹ·ΪC:\mysql<br><br>3.װTomcat:<br><br>հװ򵼽аװİװĿ¼ΪC:\Tomcat41ҪAdminϵͳԱĿ<br><br>4.MysqlJdbc<br><br>mm.mysql-2.0.4-bin.jarļŵC:\j2sdk1.4.0-rc\lib£ʵŵĶӦνҪϵͳָһ¾Ϳˣв˵ŵãҾͷˣ<br><br><br>״üԣ<br><br>ϰװ״ã价<br><br>(1)--<br><br>1.½ϵͳJAVA_HOMEֵΪC:\j2sdk1.4.1 û·װΪİװ·<br><br>2.½ϵͳTOMCAT_HOMEֵΪC:\Tomcat4 û·װΪİװ·<br><br>3.ϵͳCLASSPATHӣֵΪC:\Tomcat 4.1\common\classes;C:\Tomcat 4.1\common\lib<br><br>4.ϵͳCLASSPATHӣֵΪC:\j2sdk1.4.0-rc\lib\mm.mysql-2.0.4-bin;<br><br><br>(2)ĬϷ<br><br>1.Tomcat4.1(ڿʼ-ҵApache Tomcat4.1Start Tomcat)<br><br>ڵַ룺[url]http://localhost:8080[/url] 飺ʱпTomcatĻӭ.˵Tomcatע⣬TomcatĬ϶˿Ϊ8080ռãģ<br><br>2.MysqlMysqlĬϵͳwinmysqladmin.exeСϵͳϣ<br><br>CMDC:\mysql\binĿ¼£ִmysqlسĻһЩӭϢ˵Mysql<br><br><br>ġã<br><br>Mysql4Tomcat4Ӧã乲ͬΪ㹤<br><br>1.mm.mysql-2.0.4-bin.jarTomcatcommon/libĿ¼£<br><br>2.Ƿ´뱣test.jspC:\Tomcat 4.1\webapps\ROOTĿ¼£<br><br><%@ page contentType=&quot;text/html;charset=gb2312&quot; %> <br><% <br>java.sql.Connection conn; <br>java.lang.String strConn; <br>Class.forName(&quot;org.gjt.mm.mysql.Driver&quot;).newInstance(); <br>conn= java.sql.DriverManager.getConnection(&quot;jdbc:mysql://localhost/test&quot;,&quot;root&quot;,&quot;&quot;); <br>%><br><%--ӵMysql4ĬԴtest⣬ûõĬϵroot--%><br><br>3ĵַ[url]http://localhost:8080/test.jsp[/url]Ժ󣬳ֿհҳ棬ʾMysql4Tomcat4ϳɹ<br><br><br>塢ȫ߲ԣ<br><br>1.Tomcat4.1<br><br>2.ݿ⼰;<br><br>mysql潨һҲ缸ݡsql£<br>create database test;--<br>use test;--<br>create talbe admin (id int(4) auto_increment primary key,name varchar(20));--<br>INSERT INTO user(name) VALUES('test');--<br>ok,Ѿݿtest˱userҲһ¼<br><br>3ʾݿеļ¼;<br><br>´뱣test2.jspC:\Tomcat 4.1\webapps\ROOTĿ¼£<br><%@ page contentType=&quot;text/html;charset=GBK&quot; %><br><%@ page language=&quot;java&quot; import=&quot;java.sql.*&quot;%><br><%<br>Connection conn = null;<br>Class.forName(&quot;org.gjt.mm.mysql.Driver&quot;).newInstance(); <br>conn = java.sql.DriverManager.getConnection(&quot;jdbc:mysql://localhost/test&quot;,&quot;root&quot;,&quot;&quot;);<br>if(conn==null){<br>System.out.println(&quot;get Conn Error&quot;);<br>}<br>Statement stmt=conn.createStatement();<br>ResultSet RS_result=null;<br>%><br><html><br><head><br><title></title></head><br><body><br><%<br>RS_result=stmt.executeQuery(&quot;select * from user&quot;);<br>String Name;<br>while(RS_result.next())<br>{<br>Name=RS_result.getString(&quot;name&quot;);<br>%><br><%=Name%><br><%<br>}<br>RS_result.close();<br>stmt.close();<br>conn.close();<br>%><br></body><br></html><br><br>4.ڵַ[url]http://localhost:8080/test.jsp[/url]Ժҳʾtestʾȡݿɹ<br><br><br>˵<br><br>1.һĿE:\test\oaĿ¼£index.jspjspļbeanWEB-INF\classes\µservletjavabean<br>Tomcat֧ĿC:\Tomcat4.1\conf\server.xmlļ&quot;</Host>&quot;֮ǰ,&quot;</Context>&quot;֮<br><Context path=&quot;/oa&quot; debug=&quot;0&quot; docBase=&quot;E:\test\oa&quot; reloadable=&quot;true&quot;/>档<br>˵Context (ʾһwebӦó): docBaseӦó·path ʾwebӦóurlǰ׺url<br>Ϊ[url]http://localhost:8080/oa[/url]reloadable ԷǳҪΪtruetomcatԶӦó/WEB-INF/lib<br>/WEB-INF/classesĿ¼ı仯Զװ޸Ļµbeanservletǿڲtomcat¿beanjspı仯; <br><br>2.Tomcat4.1ĵַ[url]http://localhost:8080/oa[/url]jspbeanûдһὫindex.jsp/index.html<br>ļݸִвʾ<br><br><br>ߡл<br><br>1.лApacheMysql֯Ϊṩ֮õѵӦ÷ݿ⣻<br><br>2.лǰдTomcat3.x/Tomcat4.*ĵǣΪҽдƪĵ˲ο<br>|1073712364|218.68.248.79|ran|checkbox____|none|none||none||
