Maven-学习笔记06【基础-Maven工程servlet实例】

矫情吗；* 2022-11-01 10:55 204阅读 0赞

>  *  **[Java后端 学习路线 笔记汇总表【黑马程序员】][Java_ _]**
>  *  **[黑马程序员（腾讯微云）Maven基础讲义.pdf][Maven_.pdf]**
> 
> 1.  [Maven-学习笔记01【基础-Maven基本概念】][Maven-_01_-Maven]
> 2.  [Maven-学习笔记02【基础-Maven的安装和仓库种类】][Maven-_02_-Maven]
> 3.  [Maven-学习笔记03【基础-Maven标准目录结构和常用命令】][Maven-_03_-Maven]
> 4.  [Maven-学习笔记04【基础-Maven生命周期和概念模型图】][Maven-_04_-Maven]
> 5.  [Maven-学习笔记05【基础-使用骨架创建Maven的Java工程】][Maven-_05_-_Maven_Java]
> 6.  [Maven-学习笔记06【基础-Maven工程Servlet实例】][Maven-_06_-Maven_Servlet]

**目录**

第6节 Maven工程Servlet实例

maven工程servlet实例之指定web

maven工程servlet实例之导入项

maven工程servlet实例之jar包冲突

maven工程运行环境修改

maven的java工程取mysql数据库

数据库设计

创建maven工程

package com.itheima.dao;

ItemsDao.java

ItemsDaoImpl.java

package com.itheima.domain;

package com.itheima.test;

ItemsTest.java

运行结果

--------------------

# 第6节 Maven工程Servlet实例 #

## maven工程servlet实例之指定web ##

> 简单的使用servlet跳转的maven的web工程，servlet直接跳转到jsp页面。

> 想要让java文件夹下，可以写jsp页面
> 
> ![20210224151407266.png][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 1][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 2][]

> 设置java文件夹下，不能直接创建jsp页面：
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 3][]

## maven工程servlet实例之导入项 ##

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 4][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 5][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 6][]

## maven工程servlet实例之jar包冲突 ##

## maven工程运行环境修改 ##

## maven的java工程取mysql数据库 ##

### 数据库设计 ###

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 7][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 8][]

### 创建maven工程 ###

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 9][]  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 10][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 11][]
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 12][]

### package com.itheima.dao; ###

### ItemsDao.java ###

package com.itheima.dao;
    
    import com.itheima.domain.Items;
    
    import java.util.List;
    
    public interface ItemsDao {
        public List<Items> findAll() throws Exception;
    }

### ItemsDaoImpl.java ###

package com.itheima.dao.impl;
    
    import com.itheima.dao.ItemsDao;
    import com.itheima.domain.Items;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.util.ArrayList;
    import java.util.List;
    
    /**
     * 要想从数据库中取出数据
     * 必须有四个属性：数据库驱动，连接数据库的地址，数据库用户名称，数据库密码。
     */
    public class ItemsDaoImpl implements ItemsDao {
        public List<Items> findAll() throws Exception {
            List<Items> list = new ArrayList<Items>();
            //先获取connection对象
            Connection connection = null;
            //获取真正操作数据的对象
            PreparedStatement pst = null;
            //执行数据库查询操作
            ResultSet rs = null;
            try {
                //加载驱动类
                Class.forName("com.mysql.jdbc.Driver");
                //先获取contection对象
                connection = DriverManager.getConnection("jdbc:mysql:///maven", "root", "root");
                //获取真正操作数据的对象
                pst = connection.prepareCall("select * from items");
                //执行数据库查询操作
                rs = pst.executeQuery();
                //把数据库结果集转成java的List集合
                while (rs.next()) {
                    Items items = new Items();
                    items.setId(rs.getInt("id"));
                    items.setName(rs.getString("name"));
                    list.add(items);
                }
            } catch (Exception e) {
                e.printStackTrace();
            } finally {
                connection.close();
                pst.close();
                rs.close();
            }
            return list;
        }
    }

### package com.itheima.domain; ###

package com.itheima.domain;
    
    public class Items {
        private Integer id;
        private String name;
    
        public Integer getId() {
            return id;
        }
    
        public void setId(Integer id) {
            this.id = id;
        }
    
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    }

### package com.itheima.test; ###

### ItemsTest.java ###

package com.itheima.test;
    
    import com.itheima.dao.ItemsDao;
    import com.itheima.dao.impl.ItemsDaoImpl;
    import com.itheima.domain.Items;
    import org.junit.Test;
    
    import java.util.List;
    
    public class ItemsTest {
        @Test
        public void findAll() throws Exception {
            ItemsDao itemsDao = new ItemsDaoImpl();
            List<Items> list = itemsDao.findAll();
            for (Items items : list) {
                System.out.println(items.getName());
            }
        }
    }

### 运行结果 ###

> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 13][]

[Java_ _]: https://blog.csdn.net/weixin_44949135/article/details/113773297
[Maven_.pdf]: https://share.weiyun.com/a96xJhwl
[Maven-_01_-Maven]: https://blog.csdn.net/weixin_44949135/article/details/113920440
[Maven-_02_-Maven]: https://blog.csdn.net/weixin_44949135/article/details/113920954
[Maven-_03_-Maven]: https://blog.csdn.net/weixin_44949135/article/details/113922118
[Maven-_04_-Maven]: https://blog.csdn.net/weixin_44949135/article/details/113972939
[Maven-_05_-_Maven_Java]: https://blog.csdn.net/weixin_44949135/article/details/113998332
[Maven-_06_-Maven_Servlet]: https://blog.csdn.net/weixin_44949135/article/details/114021248
[20210224151407266.png]: /images/20221024/ec2bf364d19142c4ad76f36362b18ded.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20210224152030943.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 1]: /images/20221024/14e7a25a155a40d9a16058205d0a6bd4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 2]: /images/20221024/8a7073e09268456f9f544a3a88794418.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 3]: /images/20221024/8a89bdad73d94886b69c4ada79f37da8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 4]: /images/20221024/cc03931a7ff1438abf859b51ca7614cc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 5]: /images/20221024/c025029ab3f9466fbb98c7b31a83d325.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 6]: /images/20221024/d31bc0099c684360a672eb33b9931684.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 7]: /images/20221024/319825cb4e1c4ef1bb14f6c356ce1841.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 8]: /images/20221024/a34410a3d89c46f0bc0debf2780b872a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 9]: https://img-blog.csdnimg.cn/20210224161942818.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 10]: /images/20221024/b7ef6d2d72254995bf9a51a7eac3a5e6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 11]: /images/20221024/9eff1aee57984cd193b3073a97483121.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 12]: /images/20221024/a14b590d97464faab3c789e574400636.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDk0OTEzNQ_size_16_color_FFFFFF_t_70 13]: /images/20221024/520634c2ab0b440bb7661f1f60804bb9.png