How to use JSP to access MySQL database _ MySQL

% @ Pageimportjava. SQL. * importjava. util. * importjava. io. * contentTypetexthtml; charsetgb2312 % htmlheadtitle use the MYsql database titlemetanameGENERATORcontentMicrosoftFrontPage4.0metanameProgIdcontentFrontPage. editor. export enthead <% @ page import = "java. SQL. *"
Import = "java. util .*"
Import = "java. io .*"
ContentType = "text/html; charset = gb2312"
%>


Use MYsql database

Use JSP to read Mysql database

<%!
String host = "localhost"; // database host
String database = "pinghui"; // database name
String user = "test"; // user name
String pass = ""; // password
%> <% Java. SQL. Connection sqlConn; // database Connection object
Java. SQL. Statement sqlStmt; // Statement object
Java. SQL. ResultSet sqlRst; // result set object
// Register the JDBC driver object
Class. forName ("org. gjt. mm. mysql. Driver"). newInstance ();
// Connect to the database
SqlConn = java. SQL. DriverManager. getConnection ("jdbc: mysql: //" + host + "/" + database, user, pass );
// Create a statement object
SqlStmt = sqlConn. createStatement (java. SQL. ResultSet. TYPE_SCROLL_INSENSITIVE, java. SQL. ResultSet. CONCUR_READ_ONLY );
// Execute the SQL statement
String sqlQuery = "select count (*) from comment ";
SqlRst=sqlStmt.exe cuteQuery (sqlQuery );
SqlRst. next ();
Int count = sqlRst. getInt (1); // obtain the total number of message records
SqlQuery = "select * from comment order by userid desc ;";
SqlRst=sqlStmt.exe cuteQuery (sqlQuery); // execute an SQL statement
%>
There are <% = count %> messages in total





























<% While (sqlRst. next () {// get the next record %> <% }%>

ID	Nickname	Gender	Address	IP address	Zip Code	Oicq	ICQ	Phone Number	Message	Time
<% = SqlRst. getString ("userid") %>	<% = SqlRst. getString ("username") %>	<% = SqlRst. getString ("sex") %>	<% = SqlRst. getString ("address") %>	<% = SqlRst. getString ("ip") %>	<% = SqlRst. getString ("post") %>	<% = SqlRst. getString ("oicq") %>	<% = SqlRst. getString ("icq") %>	<% = SqlRst. getString ("telnumber") %>	<% = SqlRst. getString ("comment") %>	<% = SqlRst. getString ("time") %>

<%
// Close the result set object
SqlRst. close ();
// Close the statement object
SqlStmt. close ();
// Close the database connection
SqlConn. close ();
%>