📄 querymetadata.jsp
字号:
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.DataSource" %>
<%@ page import="javax.naming.InitialContext" %>
<%@ page import="javax.naming.NamingException" %>
<HTML><HEAD>
<TITLE>queryMetaData.jsp</TITLE></HEAD>
<BODY>
<%
Connection conn=null;
try {
request.setCharacterEncoding("GB2312");
InitialContext ic=new InitialContext();
DataSource ds=(DataSource)ic.lookup("jdbc/DBConnCoreDS");
conn=ds.getConnection();
if(!conn.isClosed()) {
out.println("数据库连接成功!");
out.println("<BR>");
}
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("select * from dept");
ResultSetMetaData rsmd=rs.getMetaData();
for (int i = 1; i <= rsmd.getColumnCount(); i++) {
out.println("Column name=" + rsmd.getColumnName(i));
out.println(" type=" + rsmd.getColumnTypeName(i));
out.println(" java type=" + rsmd.getColumnType(i));
if (rsmd.getColumnType(i) == java.sql.Types.TIMESTAMP)
out.println(" it's a Date/Time!");
else
out.println(" it's NOT a Date/Time.");
out.println("<BR>");
}
rs.close();
st.close();
}
catch (SQLException e) {
out.println("数据库连接错误:" + e);
}
finally {
conn.close();
}
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -