%@ page language="java" import="java.sql.*"%>
<%@ page language="java" import="java.io.*" %>
<%@ page contentType="text/html;charset=UTF-8" %>
JSP测试页面---HelloWorld!
<%
out.println("Hello World!
世界,你好!
");
String DRIVER = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/2015yinh";
Connection con = null;
ResultSet rs = null;
Statement stmt = null;
int i = 1;
Class.forName(DRIVER);
con = DriverManager.getConnection(url, "2015yinh", "2015yinh");
stmt = con.createStatement();
rs = stmt.executeQuery("select * from test");
while (rs.next())
{
out.println( "username=" + rs.getString(1) );
}
out.println("
连接MySQL数据库成功!");
%>