JSP连接MySQL数据库的方法

<% @ page contentType = " text/html; charset=gb2312 "   %>
<% @ page language = " java "   %>
<% @ page  import = " com.mysql.jdbc.Driver "   %>
<% @ page  import = " java.sql.* "   %>
<%
// 驱动程序名
String driverName = " com.mysql.jdbc.Driver " ;
// 数据库用户名
String userName = " root " ;
// 密码
String userPasswd = " 123 " ;
// 数据库名
String dbName = " stock " ;
// 表名
String tableName = " users " ;
// 联结字符串
String url = " jdbc:mysql://localhost/ " + dbName + " ?user= " + userName + " &password= " + userPasswd;
Class.forName( " com.mysql.jdbc.Driver " ).newInstance();
Connection conn = DriverManager.getConnection(url);
Statement stmt  =  conn.createStatement();
String sql = " SELECT * FROM  " + tableName;
ResultSet rs  =  stmt.executeQuery(sql); 
// 获得数据结果集合
ResultSetMetaData rsmd  =  rs.getMetaData();
// 确定数据集的列数，亦字段数
int  numColumns = rsmd.getColumnCount();
//  输出每一个列名
out.print( " <table border=1><tr> " );
for ( int  i = 1 ;i < numColumns;i ++ )
{
    out.print("<td>"+rsmd.getColumnName(i)+"</td>");
}
out.print( " </tr> " );
while (rs.next()) 
{
out.print("<tr>");
    for(int i=1;i<numColumns;i++)
    {
    //输出数据
    out.print("<td>"+rs.getString(i)+"</td>");
    }
out.print("</tr>"); 
}  
out.print( " </table> " );
out.print( " 数据库操作成功，恭喜你 " ); 
rs.close(); 
stmt.close(); 
conn.close();
%>

MySql的jdbc下载地址： http://mysql.isu.edu.tw/Downloads/Connector-J/mysql-connector-java-5.1.6.zip