<%@ page language="java" import="java.sql.*"%>
<%@ page language="java" import="java.io.*" %>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
JSP连接数据库测试
<%
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;
Class.forName(DRIVER);
//连接MySQL数据库
con = DriverManager.getConnection(url, "2015yinh", "2015yinh");
//执行select查询语句，查询2015yinh数据库test表中的数据
stmt = con.createStatement();
rs = stmt.executeQuery("select * from test");
while (rs.next())
{
out.println( "username=" + rs.getString("username") );
out.println("
");
}
%>