4-2-17:06今天开始j2ee构架

王朝java/jsp·作者佚名  2006-01-09
窄屏简体版  字體: |||超大  

昨天搞好了下面这个3个东西,相信大家一看就明白了:3中链数据库的途径。

<%@ page contentType="text/html;charset=gb2312"%>

<%@ page import="java.sql.*" %>

<html>

<body>

<%

Class.forName("org.gjt.mm.mysql.Driver").newInstance();

Connection conn= DriverManager.getConnection("jdbc:mysql://localhost/test","root","123456");

Statementstmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sql="select * from stu";

ResultSet rs=stmt.executeQuery(sql);

while(rs.next())

{%>

<%=rs.getString("xh")%>

<%=rs.getString("xm")%>

<%}%>

</body>

</html>

--------------------------------------------------------------------------------------------------------------------------------------------

server.xml

<GlobalNamingResources>

<!-- Test entry for demonstration purposes -->

<Environment name="simpleValue" type="java.lang.Integer" value="30"/>

<!-- Editable user database that can also be used by

UserDatabaseRealm to authenticate users -->

<Resource name="UserDatabase" auth="Container"

type="org.apache.catalina.UserDatabase"

description="User database that can be updated and saved"

factory="org.apache.catalina.users.MemoryUserDatabaseFactory"

pathname="conf/tomcat-users.xml" />

<Resource name="JDBC for MySQL"

type="javax.sql.DataSource"

driverClassName="com.mysql.jdbc.Driver"

username="root"

password="123456"

maxIdle="2"

maxWait="5000"

url="jdbc:mysql://localhost/test"

maxActive="4"/>

</GlobalNamingResources>

contex.xml

<Context>

<WatchedResource>WEB-INF/web.xml</WatchedResource>

<ResourceLink name="JDBC for MySQL" global="JDBC for MySQL" type="javax.sql.DataSource"/>

</Context>

web.xml

<resource-ref>

<description>Connect Mysql</description>

<res-ref-name>JDBC for MySQL</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Container</res-auth>

</resource-ref>

<%@ page import="java.sql.*"%>

<%@ page import="javax.sql.*"%>

<%@ page import="javax.naming.*"%>

<%@ page session="false" %>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<title>Test of MySQL connection pool</title>

</head>

<body>

<%

out.print("Start<br/>");

try{

Context initCtx = new InitialContext();

Context ctx = (Context) initCtx.lookup("java:comp/env");

Object obj = (Object) ctx.lookup("JDBC for MySQL");

javax.sql.DataSource ds = (javax.sql.DataSource)obj;

Connection conn = ds.getConnection();

out.print("MySQL connection pool runs perfectly!");

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,

ResultSet.CONCUR_UPDATABLE);

String sql="select * from stu";

ResultSet rs=stmt.executeQuery(sql);

while(rs.next())

{%>

<%=rs.getString("xh")%>

<%=rs.getString("xm")%>

<br>

<%}%>

<%

conn.close();

}

catch(Exception ex){

out.print(ex.getMessage());

ex.printStackTrace();

}

%>

</body>

</html>

-------------------------------------------------------------------------------------------------------------------------------------

struts-config.xml

<data-sources>

<data-source key="A" type="org.apache.commons.dbcp.BasicDataSource">

<set-property property="driverClassName" value="org.gjt.mm.mysql.Driver" />

<set-property property="url" value="jdbc:mysql://localhost/test" />

<set-property property="username" value="root" />

<set-property property="password" value="123456" />

</data-source>

</data-sources>

三个需要的程序包:

commons-dbcp-1.2.1.jar

http://apache.linuxforum.net/dist/jakarta/commons/dbcp/binaries/

struts-legacy.jar

http://apache.linuxforum.net/dist/jakarta/struts/struts-legacy/

commons-pool-1.2.jar

http://apache.linuxforum.net/dist/jakarta/commons/pool/binaries/

H:\java\Tomcat 5.5\common\lib\mysql-connector-java-3.0.16-ga-bin.jar;

------------------------------------------------------------------------------------------------------------------------------------------

今天开始j2ee构架

但是星期六又要期末考试,哎----烦呀,这日子简直没法活了,中国的程序员,不是人才,而是奴隶,正的是。

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航