test.jsp

来自「“JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库」· JSP 代码 · 共 50 行

<%@ page language="java" contentType="text/html;charset=GBK" %>
<%@ page import="java.sql.*,java.io.*,java.lang.*"%>
<%@ page import="java.text.SimpleDateFormat,java.util.Date"%>
<%
try
{
	Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
	Connection conn_oracle = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.53:1521:hg","oa","oa");
	Statement stm=null;
	ResultSet rs=null;
	ResultSetMetaData rsmd=null;
	String sql;
	stm=conn_oracle.createStatement();//创建连接对象
	sql="SELECT * FROM config";
	rs=stm.executeQuery(sql);
	rsmd=rs.getMetaData();
	int numberOfColumns = rsmd.getColumnCount();
	int count=0;
	int tt=0;
	String field[];
	int i=1;
	field=new String[400];	

	//查询字段
	for(i=1;i<=numberOfColumns;i++)
	{
		count++;
		field[i]=rsmd.getColumnName(i);
		out.println(i+"&nbsp"+field[i]+"&nbsp&nbsp");
	}
	
	//列数
	out.println("<br>"+count+"<br>");
   
	//查询数据
	
	while(rs.next())
	{
		for(i=1;i<=count;i++)
			out.println(i+"&nbsp"+rs.getString(i)+"<br>");
		
		
	}
if(rs!=null){stm=rs.getStatement();rs.close() ;}
if(stm!=null)stm.close();

}catch(ClassNotFoundException ec){out.println(ec);}
catch(SQLException e){out.println(e);}
  %>