目录

  • Introduction
    • ● Maven
    • ● Maven Web Project
    • ● JSP Template
    • ● Tomcat Hot Deploy
    • ● Exp04-CSS Layout
    • ● Exp05-Servlet/FIlter
    • ● Exp06-JSTL
    • ● Exp07-JDBC
    • ● Course Projects
    • ● Git&Github-Web
    • ● Git&Github-Java
  • HTML
    • ● Course Introduction
    • ● HTML Basics
    • ● Table&List&Display
    • ● Form Attributes
  • CSS
    • ● Basics
    • ● Units
    • ● Box Model
    • ● Background&Image&Text&Opacity
    • ● Combinators&Pseudo&Attribute Selectors
    • ● List&Table
    • ● -Inline-Block&Links&Vertical-Align&Float&Position
    • ● Box-sizing&Navigation
    • ● Transitions&Transforms&Card&Dropdowns&Viewport
    • ● Layout
    • ● Lecture08-01-Video
    • ● Lecture08-02-Video
    • ● Responsive Web Design
  • JavaScript
    • ● JavaScript Introduction
    • ● JavaScript Basics
    • ● jQuery
  • Servlet
    • ● Introduction
    • ● Servlet
    • ● Request&Response
    • ● Redirect&RequestDispatcher
    • ● Scope&Header
    • ● Filter&Listener
  • JSP
    • ● Introduction
    • ● EL
    • ● JSTL
    • ● Base&url Tags
    • ● AJAX
  • JDBC
    • ● JDBC Introduction
    • ● Connection&PreparedStatement&ResultSet
    • ● Transaction
    • ● Lecture16-01
    • ● Lecture16-02
  • MVC
    • ● MVC Introduction
  • Homework
    • ● h1-form
    • ● h2-card
    • ● h3-badge
    • ● h4-Navigation Drawer
    • ● h5-Floating Button
    • ● h6-Modal
    • ● Course Timetable Conflicting
    • ● Http Session
Exp07-JDBC

MySQL数据库IP地址,以实际为准

https://github.com/bwhyman/web-course/tree/master/web-experiments/experiment-07

IP: 120.46.159.231;  port:3306;

账号,密码,数据库,均为学号

context.xml,以下内容,替换实际IP,及学号

<?xml version="1.0" encoding="UTF-8"?>

<Context>

<Resource name="jdbc/MySQL" type="javax.sql.DataSource"

maxTotal="100" maxIdle="30" maxWaitMillis="10000" initialSize="1"

username="学号" password="学号"

driverClassName="com.mysql.cj.jdbc.Driver"

url="jdbc:mysql://120.46.159.231:3306/学号" />

</Context>