metadata.jsp
来自「一本jsp自学教材」· JSP 代码 · 共 55 行
JSP
55 行
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" %>
<%@ page import="com.mysql.jdbc.Driver" %>
<%@ page import="java.sql.*" %>
<HTML>
<head>
<title>获取列属性</title>
</head>
<BODY>
<%
//驱动程序名、数据库用户名、密码、数据库名、表名
String driverName="com.mysql.jdbc.Driver";
String username="root";
String password="yesterdayn";
String dbName="study";
String tableName="product";
//联结字符串
String url="jdbc:mysql://localhost/"+dbName+"?characterEncoding=GBK";
try{
//加载驱动程序
Class.forName("com.mysql.jdbc.Driver");
//建立同数据库的连接对象
Connection connection=DriverManager.getConnection(url,username,password);
Statement statement = connection.createStatement();
//发送执行SQL语句
String sql="SELECT * FROM "+tableName;
ResultSet rs=statement.executeQuery(sql);
ResultSetMetaData rsmd=rs.getMetaData();
out.print("<TABLE BORDER=1 bordercolorlight=#000000 >");
out.print("<TR>");
out.print("<TD width=70>列各称</TD>");
out.print("<TD width=80>列类型</TD>");
out.print("<TD width=60>列宽度</TD>");
out.print("</TR>");
for(int i=1;i<=rsmd.getColumnCount();i++)
{
out.print("<TR>");
out.print("<TD width=70>"+rsmd.getColumnName(i)+"</TD>");
out.print("<TD width=80>"+rsmd.getColumnTypeName(i)+"</TD>");
out.print("<TD width=60>"+rsmd.getColumnDisplaySize(i)+"</TD>");
out.print("</TR>");
}
out.print("</TABLE>");
rs.close();
statement.close();
connection.close();
}
catch(SQLException e)
{
out.print(e.toString());
}
%>
</HTML>
</BODY>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?