Tomcat and MySQL system testing

Source: Internet
Author: User
Tags sql mysql string stmt tomcat netbeans
Mysql

1 . A simple JSP test page

FileName: index.jsp

The contents of the document are as follows:

<% @page contenttype= "text/html"%>

<% @page pageencoding= "UTF-8"%>

<body>

<%--<jsp:usebean id= "Beaninstancename" scope= "session" class= "Beanpackage.beanclassname"/>--%>

<%--<jsp:getproperty name= "Beaninstancename" property= PropertyName "/>"--%>

<% out.println ("Welcome ..."); %>

</body>

The thick line section is for added code, the other is automatically generated for Java development tool NetBeans, and the output is as shown in the figure:

!--? xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml"/--> < /v:path>

2 . Database Connection Test Page

File name: mysql_conn.jsp

The contents of the document are as follows:

<% @page contenttype= "text/html"%>

<% @page pageencoding= "UTF-8"%>

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

<%

Java.sql.Connection Conn;

Java.lang.String strconn;

Conn=null;

try{

Class.forName ("Org.gjt.mm.mysql.Driver"). newinstance ();

Conn=java.sql.drivermanager.getconnection ("Jdbc:mysql://localhost/mysql", "Root", "");

}

catch (Exception e) {

System.out.println (" connection Error ");

}

Statement stmt=conn.createstatement ();

ResultSet Rs_result=null;

%>

<body>

<%--<jsp:usebean id= "Beaninstancename" scope= "session" class= "Beanpackage.beanclassname"/>--%>

<%--<jsp:getproperty name= "Beaninstancename" property= PropertyName "/>"--%>

<%

Rs_result=stmt.executequery ("SELECT * from user");

String Name;

while (Rs_result.next ()) {

Name=rs_result.getstring ("user");

%>

<%=name%>

<%

}

Rs_result.close ();

Stmt.close ();

Conn.close ();

%>

</body>

Bold text is added, and the rest is automatically generated for Java development tools NetBeans.



Related Article

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.