首页 > 代码库 > JDBC的应用
JDBC的应用
代码:
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <%@ page import="java.sql.*" %> <%@ page import="com.mysql.jdbc.*" %> <jsp:useBean id="myjdbc01" scope="page" class="com.zss.www.DBConn"/> <% request.setCharacterEncoding("utf-8"); String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="http://www.mamicode.com/"> <title>My JSP ‘001.jsp‘ starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="http://www.mamicode.com/styles.css"> --> </head> <body> <% String sql="select * from information"; ResultSet rs = myjdbc01.doSelect(sql); out.println("<table width=‘200‘ border=‘1‘>"); out.println("<tr>"); out.println("<th scope=‘col‘>姓名</th>"); out.println("<th scope=‘col‘>班级</th>"); while (rs.next()) { out.println("<tr>"); out.println("<td>"); out.println(rs.getString(1)); out.println("</td>"); out.println("<td>"); out.println(rs.getString(2)); out.println("</td>"); out.println("</tr>"); } out.println("</table>"); %> </body> </html>
运行截图:
在mySQL中:
JDBC的应用
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。