用一個jsp實現對資料庫發訪問

標籤：

<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ 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="zzga";   
//表名   
String tableName="t_device";   
//連接字串   
String url="jdbc:mysql://localhost/"+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(" 精度 &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp&nbsp &nbsp");
out.print("緯度&nbsp &nbsp &nbsp &nbsp &nbsp &nbsp&nbsp &nbsp");
out.print("  地址 ");
out.print("<br>");
// 輸出每一個資料值     
while(rs.next()) {

out.print(rs.getString(4)+" ");

out.print("|");

out.print(rs.getString(5));
out.print("|");

out.print(rs.getString(3));

out.print("<br>");

}  
out.print("資料庫操作成功，恭喜你");   
rs.close();   
statement.close();   
connection.close();   
%>
</html>

用一個jsp實現對資料庫發訪問