查看Jsp连接mysql的源代码 Jsp连接mysql 0

测试代码：
<pre class="prettyprint">
<%@ page contentType="text/html;charset=Gb2312"%> <%--UTF-8--%>
<%@ page import="java.sql.*"%>
<%
String dbName = "temp";
String tbName = "mytest";
String dbUsr = "root";
String dbPwd = "123456";

Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/"+dbName,dbUsr,dbPwd);
Statement stmt=con.createStatement();
String cmd = new String("select * from ");
cmd = cmd.concat(tbName);
ResultSet rs=stmt.executeQuery(cmd);
while(rs.next())
{
%>
<%=rs.getString("uid")%>
<%=rs.getString("uname")%><br>
<%
}
rs.close();
stmt.close();
con.close();
%>
<%out.print("数据库操作成功，恭喜你");%>
</pre>

提示出错：
<pre>
org.apache.jasper.JasperException: Unable to compile class for JSP: 

An error occurred at line: 26 in the jsp file: /testjdbc.jsp
String literal is not properly closed by a double-quote
23: stmt.close();
24: con.close();
25: %>
26: <%out.print("数据库操作成功，恭喜你");%>
27: 
</pre>

原因分析：

linux默认不支持Gb2312编码，改为UTF-8后则一切ok.