【运维】【期末实训】网站简易搭建模拟

最新推荐文章于 2025-11-23 19:53:25 发布

原创最新推荐文章于 2025-11-23 19:53:25 发布 · 377 阅读

7 ·

CC 4.0 BY-SA版权

文章标签：

#运维

网站服务器简易搭建模拟01 | 准备工作安装软件

1.准备环境

OpenEuler20.03
Java（JDK8）
Apache Tomcat 8.5.88
Mysql5

2.步骤

2.1 准备工作

下载openEule20.03软件

- openEuler所有版本下载 | 下载中心 | openEuler社区

下载安装软件如下软件

- xshell6
- xftp6
- VMWare Workstations16

虚拟机环境安装

- 网络设置

- 按照CentOS8标准安装openEuler20.03

2.2 修改主机名、静态IP、关闭防火墙

# 修改主机名未oe151
hostnamectl set-hostname oe151

# 设置静态IP
vi /etc/sysconfig/network-scripts/ifcfg-ens33

TYPE=Ethernet
BOOTPROTO=static
NAME=ens33
DEVICE=ens33
ONBOOT=yes
IPADDR=192.168.10.151
NETMASK=255.255.255.0
GATEWAY=192.168.10.2

# 关闭防火墙
systemctl stop firewalld

2.3 安装配置httpd

yum install -y httpd
systemctl is-enabled  httpd

cd /etc/httpd/conf/
vim   httpd.conf

# If your host doesn't have a ...
ServerName 192.168.10.151:80

systemctl  start  httpd.service
systemctl   enable    httpd

访问测试 http://192.168.10.151

2.4 安装配置MySql

yum install -y mysql5-server
/usr/libexec/mysqld  --defaults-file=/etc/my.cnf  --user=mysql  --initialize
grep "password"   /var/log/mysqld.log
systemctl  start  mysqld

mysql -uroot -hlocalhost -p
alter user  root@localhost  identified by "123123";
flush privileges;

create database class;
create table class.m_class(kid int primary key,className char(20));
insert into class.m_class values (1,"class1");
exit;

2.5 安装配置JDK

cd  /usr/local
tar   xf   jdk-8u371-linux-x64.tar.gz
ln  -s  /usr/local/jdk1.8.0_371   /usr/local/jdk
vim   /etc/profile

# 最后添加 vim 的 G ，按o
export JAVA_HOME=/usr/local/jdk
export CLASSPATH=$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib:/test
export PATH=$JAVA_HOME/bin:$PATH

source  /etc/profile
java   -version

2.6 安装配置Tomcat

cd  /usr/local
tar xf apache-tomcat-8.5.88.tar.gz

vim /etc/profile

# 在最后一行添加 
export TOMCAT_HOME=/usr/local/tomcat

/usr/local/tomcat/bin/startup.sh

# 访问测试：
http://192.168.10.151:8080/

cd   /usr/local/tomcat/webapps/

webapps 目录下放置MyProject1.war项目包，tomcat 会检测到，并自动解压

访问测试： http://192.168.10.151:8080/MyProject1/

在 Tomcat 中安装 jdbc 驱动
将mysql-connector-java-5.1.49.jar放到 /usr/local/tomcat/lib 目录下

修改conn.jsp中url，username，password

<%@ page language="java" contentType="text/html; charset=UTF-8"  pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>

<html>
<head>
<title>通过JSP打开数据表</title>
</head>
<body>

 <%
          Class.forName("com.mysql.jdbc.Driver");   ////驱动程序名
          String url = "jdbc:mysql://localhost:3306/class";   //数据库名
            String username = "root";     //数据库用户名
            String password = "123123";  //数据库用户密码
            Connection conn = DriverManager.getConnection(url, username, password);  //连接状态

            if(conn != null){
                out.print("数据库连接成功！");
                out.print("<br />");
                Statement stmt = null;
                ResultSet rs = null;
                String sql = "SELECT * FROM m_class;";  //查询语句
                stmt = conn.createStatement();
                rs = stmt.executeQuery(sql);
                out.print("查询结果：");
                out.print("<br />");
                out.println("kid" + "  " + "课程名称 ");
                out.print("<br />");
                while (rs.next()) {
                 out.println(rs.getInt("kid")+ " &nbsp " + rs.getString("className")); //将查询结果输出
                 out.print("<br />");
                }
            }
            else{
                out.print("连接失败！");
            }

%>
</body>
</html>

重启tomcat 服务

# 重启，先关闭，在启
/usr/local/tomcat/bin/shutdown.sh
/usr/local/tomcat/bin/startup.sh

访问测试： http://192.168.10.151:8080/MyProject1/