<%
@ 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<% @ 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();
%>