• JSP一个简单的项目实现教程


    跟着流程做下去,你将会获得(适合新手)

    1.用MySQL Workbench创建数据库和表

    2.用MyEclipse创建WEb项目

    3.使用JDBC连接数据库,做增删改查

    4.MyEclipse自定义标签

    目标页面如下

     1. 创建DB

    打开Workbench,配置用户名和密码之后进入Db工作台页面,创建数据库test和表tbl_books

    脚本如下

    SET FOREIGN_KEY_CHECKS=0;
    -- ----------------------------
    -- Table structure for tbl_books
    -- ----------------------------
    CREATE TABLE `tbl_books` (
      `isbn` varchar(20) NOT NULL,
      `title` varchar(100) NOT NULL,
      `editionNumber` int(11) NOT NULL,
      `copyright` varchar(4) NOT NULL,
      `publisherID` int(11) NOT NULL,
      `imageFile` varchar(20) NOT NULL,
      `price` double NOT NULL,
      PRIMARY KEY  (`isbn`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Records 
    -- ----------------------------
    INSERT INTO `tbl_books` VALUES ('0130125075', 'Java How to Program (Java 2)', '3', '2000', '1', 'jhtp3.jpg', '70');
    INSERT INTO `tbl_books` VALUES ('0130161438', 'Internet and World Wide Web How 
    
    to Program', '1', '2000', '1', 'iw3htp1.jpg', '70');
    INSERT INTO `tbl_books` VALUES ('0130284173', 'XML How to Program', '1', '2001', '1', 'xmlhtp1.jpg', '70');
    INSERT INTO `tbl_books` VALUES ('0130284181', 'Perl How to Program', '1', '2001', '1', 'perlhtp1.jpg', '70');
    INSERT INTO `tbl_books` VALUES ('013028419x', 'e-Business and e-Commerce How to 
    
    Program', '1', '2001', '1', 'ebechtp1.jpg', '70');
    INSERT INTO `tbl_books` VALUES ('0130829277', 'The Complete Java Training Course 
    
    (Java 1.1)', '2', '1998', '2', 'javactc2.jpg', '100');
    INSERT INTO `tbl_books` VALUES ('0130829293', 'The Complete Visual Basic 6 
    
    Training Course', '1', '1999', '2', 'vbctc1.jpg', '110');
    INSERT INTO `tbl_books` VALUES ('0130852473', 'The Complete Java 2 Training 
    
    Course', '3', '2000', '2', 'javactc3.jpg', '110');
    INSERT INTO `tbl_books` VALUES ('0130856118', 'The Complete Internet and World 
    
    Wide Web Programming Training Course', '1', '2000', '2', 'iw3ctc1.jpg', '110');
    INSERT INTO `tbl_books` VALUES ('0130895601', 'Advanced Java 2 Platform How to 
    
    Program', '1', '2002', '1', 'advjhtp1.jpg', '70');
    INSERT INTO `tbl_books` VALUES ('0130895717', 'C++ How to Program', '3', '2001', '1', 'cpphtp3.jpg', '70');
    INSERT INTO `tbl_books` VALUES ('0130895725', 'C How to Program', '3', '2001', '1', 'chtp3.jpg', '70');
    INSERT INTO `tbl_books` VALUES ('0132261197', 'C How to Program', '2', '1994', '1', 'chtp2.jpg', '50');
    INSERT INTO `tbl_books` VALUES ('0134569555', 'Visual Basic 6 How to Program', '1', '1999', '1', 'vbhtp1.jpg', '70');
    INSERT INTO `tbl_books` VALUES ('0135289106', 'C++ How to Program', '2', '1998', '1', 'cpphtp2.jpg', '50');
    INSERT INTO `tbl_books` VALUES ('0138993947', 'Java How to Program (Java 1.1)', '2', '1998', '1', 'jhtp2.jpg', '50');
    INSERT INTO `tbl_books` VALUES ('0139163050', 'The Complete C++ Training Course', '3', '2001', '2', 'cppctc3.jpg', '110');
    

    2.打开MyEclipse,空白处,右键->new->WebProject

    3.

  • 相关阅读:
    二叉树(前序,中序,后序遍历)查找
    插入查找
    归并排序
    解密Spring AOP 之AspectJ与动态代理基础知识
    常用的sql
    python 集合方法
    python 字典
    python 列表方法
    python 序列类型
    fake_useragent
  • 原文地址:https://www.cnblogs.com/yanchuan/p/6270605.html
Copyright © 2020-2023  润新知