我将数据库first.sql转存到我的站点web/webroot/MySQL文件夹里.
绝对路就是E:\JSP\web\WebRoot\MySQL\first.sql
我应该如何改写这句话 String DbConn = "jdbc:mysql://localhost:3306/first";
完整的代码是
HTML code:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<HTML>
<HEAD>
<TITLE>jsp连接mysql</TITLE>
</HEAD>
<BODY>
<h2>JSP连接mySQL</h2>
<%
Connection con;
Statement stmt;
ResultSet rs;
Class.forName("com.mysql.jdbc.Driver");
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
String DbConn = "jdbc:mysql://localhost:3306/first";
String DbPass="123456";
con = java.sql.DriverManager.getConnection(DbConn,"test",DbPass);
stmt = con.createStatement();
rs = stmt.executeQuery("select * from txl");
out.println("<table border='1' cellspacing='0' cellpadding='0'>");
out.println("<tr><td>姓名</td><td>性别</td><td>电子邮件</td><td>电话</td><td>地址</td></tr>");
while(rs.next())
{
String user
