4-2-17: 06 J2EE architecture today

Yesterday, I did a good job in this three things. I believe that everyone will understand: 3 The path of the new chain database.

<% @ Page ContentType = "text / html; charset = GB2312"%>

<% @ Page Import = "java.sql. *"%>

<%

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")%>

<%}%>

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

Server.xml

UserdatabaseEnderalm to Authenticate Uses ->

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" />

TYPE = "javax.sql.datasource"

Driverclassname = "com.mysql.jdbc.driver"

Username = "root"

PASSWORD = "123456"

Maxidle = "2" maxwait = "5000"

URL = "JDBC: mysql: // localhost / test"

Maxactive = "4" />

Contex.xml

Web-inf / web.xml

Web.xml

Connect MySQL

jdbc for mysql

javax.sql.datasource

container

<% @ Page Import = "java.sql. *"%>

<% @ Page Import = "javax.sql. *"%>

<% @ Page Import = "javax.naming. *"%>

<% @ Page session = "false"%>