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.