JSPÐÂÊÖÎÊÌ⣡ûÕÒµ½´ð°¸£¡

JSP´úÂëÈçÏ£º

<%@ 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="123456";

//Êý¾Ý¿âÃû

String dbName="test";

//±íÃû

String tableName="mytable";

//Áª½á×Ö·û´®

String url="jdbc:mysql://localhost:3308/"+dbName+"?user="+userName+"&password="+userPasswd;

Class.forName("com.mysql.jdbc.Driver").newInstance();

Connection connection=DriverManager.getConnection(url);

Statement statement = connection.createStatement();

String sql="SELECT * from "+tableName;

ResultSet rs = statement.executeQuery(sql);

//»ñµÃÊý¾Ý½á¹û¼¯ºÏ

ResultSetMetaData rmeta = rs.getMetaData();

//È·¶¨Êý¾Ý¼¯µÄÁÐÊý£¬Òà×Ö¶ÎÊý

int numColumns=rmeta.getColumnCount();

// Êä³öÿһ¸öÊý¾ÝÖµ

out.print("id");