java.jee--jsp--jdbc链接数据库，展示数据

<%@ page language=“java” import=“java.util." pageEncoding=“GBK”%>
<%@ page import=“com.mysql.jdbc.Driver” %>
<%@ page import="java.sql.” %>
<%@ taglib uri=“http://java.sun.com/jsp/jstl/core” prefix=“c” %>
<%
//驱动程序名
String driverName=“com.mysql.jdbc.Driver”;
//数据库用户名
String userName=“xxxxx”;
//密码
String userPasswd=“xxxxxx”;
//数据库名
String dbName=“cms”;
//表名
String tableName=“article”;

//联结字符串 jdbc:mysql://localhost:3306/
String url=“jdbc:mysql://localhost:3306/”+dbName+"?user="+userName+"&password="+userPasswd;
Class.forName(“com.mysql.jdbc.Driver”).newInstance();
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();

//sql语句
String sql=“select t.TITLE, t.TITLE2, t.HOME_TITLE , t.HOMEPAGE_IMAGE, t.AUTHOR, t.CONTENT from article  t where t.node_id =20140806 and article_class_id = 1237”;

ResultSet rs = statement.executeQuery(sql);

//获取查询数据
List list = new ArrayList();
while(rs.next()) {

String title = rs.getString(“TITLE”);
String title2 = rs.getString(“TITLE2”);
String home_title = rs.getString(“HOME_TITLE”);
String homepage_image = rs.getString(“HOMEPAGE_IMAGE”);
String author = rs.getString(“AUTHOR”);
String summary = rs.getString(“summary”);

Map map = new HashMap();
map.put(“title”, title);
map.put(“title2”, title2);
map.put(“home_title”, home_title);
map.put(“homepage_image”, homepage_image);
map.put(“author”, author);
map.put(“summary”, summary);
list.add(map);
}

request.setAttribute(“list”, list);

//获得数据结果集合
//ResultSetMetaData rmeta = rs.getMetaData();
//确定数据集的列数，亦字段数
//int numColumns=rmeta.getColumnCount();
// 输出每一个数据值
//out.print(“id”); 
//out.print("|");
//out.print(“num”);
//out.print("
");
//while(rs.next()) {
//out.print(rs.getString(1)+" “); 
//out.print(”|");
//out.print(rs.getString(2));
//out.print("
"); 
//} 
//out.print("
");
//out.print(“数据库操作成功，恭喜你”);

rs.close(); 
statement.close(); 
connection.close(); 
%>

${map.title} ${map.title2}   ———————————————— 版权声明：本文为CSDN博主「绿竹痕」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。 原文链接：https://blog.csdn.net/jobjava/article/details/38519857