通过JDBC连接数据库（MySql为例）并读取数据库信息--JSP基础

最新推荐文章于 2023-05-22 10:51:00 发布

qq_29069777

最新推荐文章于 2023-05-22 10:51:00 发布

阅读量625

点赞数

分类专栏：前端文章标签： jsp java

原文链接：https://www.mk2048.com/blog/blog.php?id=hiaabicbj2cb&title=%E9%80%9A%E8%BF%87JDBC%E8%BF%9E%E6%8E%A5%E6%95%B0%E6%8D%AE%E5%BA%93%EF%BC%88MySql%E4%B8%BA%E4%BE%8B%EF%BC%89%E5%B9%B6%E8%AF%BB%E5%8F%96%E6%95%B0%E6%8D%AE%E5%BA%93%E4%BF%A1%E6%81%AF--JSP%E5%9F%BA%E

版权

前端专栏收录该内容

1175 篇文章 2 订阅

订阅专栏

1、先建数据库，数据库名为：employee_DB;然后在数据库employee_DB下建表，表名为employee;最后插入数据。

create database employee_DB;

use employee_DB;

create table employee(
id int primary key auto_increment,
name varchar(50),
age int,
sex varchar(2),
salary float,
department varchar(50)
);

desc employee;

insert into employee values(1,'张雨',20,'女',3600,'后勤部');

insert into employee values(2,'刘冰',22,'男',4500,'人事');

insert into employee values(3,'张雨',25,'男',5000,'技术部');

select * from employee;

2、index.jsp页面：

 1 <%@page import="java.sql.ResultSet"%>
 2 <%@page import="java.sql.Statement"%>
 3 <%@page import="java.sql.Connection"%>
 4 <%@page import="java.sql.DriverManager"%>
 5 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
 6 <%
 7 String path = request.getContextPath();
 8 String basePath = request.getScheme() "://" request.getServerName() ":" request.getServerPort() path "/";
 9 %>
10 
11 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
12 <html>
13   <head>
14     <base href="<%=basePath%>">
15     
16     <title>My JSP 'index.jsp' starting page</title>
17     <meta http-equiv="pragma" content="no-cache">
18     <meta http-equiv="cache-control" content="no-cache">
19     <meta http-equiv="expires" content="0">    
20     <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
21     <meta http-equiv="description" content="This is my page">
22     
23   </head>
24   
25   <body>
26     <%
27     try{
28          Class.forName("com.mysql.jdbc.Driver");
29          //out.print("加载驱动成功……");
30     }catch(ClassNotFoundException e){
31         //out.print("加载驱动出现异常！");
32         //out.print(e);在浏览器下输出异常
33         e.printStackTrace();
34     }
35     String url="jdbc:mysql://localhost:3306/employee_db";
36     String username="root";
37     String password="123456";
38     Connection conn=DriverManager.getConnection(url, username, password);
39     /*
40     if(conn!=null){
41         out.print("数据库连接成功！");
42         conn.close();
43     }else{
44         out.print("数据库连接失败！");
45     }
46     
47     */
48     Statement stmt=conn.createStatement();
49     String sql="select * from employee";
50     ResultSet rs=stmt.executeQuery(sql);
51     %>
52     <%
53       %>
54       <table border=2>
55           <tr>
56           <th>员工号</th>
57           <th>姓名</th>
58           <th>年龄</th>
59           <th>性别</th>
60           <th>薪水</th>
61           <th>部门</th>
62           </tr>
63    <%
64    while(rs.next()){
65            out.print("<tr>");
66            out.print("<td>" rs.getInt("id") "</td>");
67               out.print("<td>" rs.getString("name") "</td>");
68           out.print("<td>" rs.getString("age") "</td>");
69           out.print("<td>" rs.getString("sex") "</td>");
70           out.print("<td>" rs.getFloat("salary") "</td>");
71           out.print("<td>" rs.getString("department") "</td>");
72           out.print("</tr>");
73    }
74    out.print("</table>");
75    rs.close();
76    stmt.close();
77    conn.close();
78     %>
79   </body>
80 </html>

3、Effect Picture:

源码文件：jsp连接Mysql以及显示数据库信息.zip

更多专业前端知识，请上【猿2048】www.mk2048.com

qq_29069777

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
通过JDBC连接数据库（MySql为例）并读取数据库信息--JSP基础

1、先建数据库，数据库名为：employee_DB;然后在数据库employee_DB下建表，表名为employee;最后插入数据。 create databaseemployee_DB; use ...
复制链接

扫一扫