先自我介绍一下,小编浙江大学毕业,去过华为、字节跳动等大厂,目前阿里P7
深知大多数程序员,想要提升技能,往往是自己摸索成长,但自己不成体系的自学效果低效又漫长,而且极易碰到天花板技术停滞不前!
因此收集整理了一份《2024年最新Linux运维全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友。
既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,涵盖了95%以上运维知识点,真正体系化!
由于文件比较多,这里只是将部分目录截图出来,全套包含大厂面经、学习笔记、源码讲义、实战项目、大纲路线、讲解视频,并且后续会持续更新
如果你需要这些资料,可以添加V获取:vip1024b (备注运维)
正文
特别注意这一个行参数:`jdbc:mysql://127.0.0.1:3306/springbook?useUnicode=true&characterEncoding=utf8&useSSL=false"`
##### pom.xml文件
<?xml version="1.0" encoding="UTF-8"?>
4.0.0
<groupId>com.swjd.yxl</groupId>
<artifactId>springBook</artifactId>
<version>1.0-SNAPSHOT</version>
<dependencies>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.14</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.16.18</version>
<scope>provided</scope>
</dependency>
<!--Spring测试模块-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
</dependencies>
##### log4j文件
log4j.rootLogger=DEBUG, Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
##### book
package com.swjd.bean;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@NoArgsConstructor
@AllArgsConstructor
@Data
public class Book {
private int id;
private String bookName;
private String author;
private int totalPage;
private int status;
}
##### BookController
package com.swjd.controller;
import com.swjd.service.BookServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
@Controller
public class BookController {
@Autowired
BookServiceImpl bookServiceImpl;
//显示全部书籍
public void show1() throws Exception {
bookServiceImpl.getAll();
}
//根据编号查询
public void show2(int id) throws Exception {
bookServiceImpl.getOneById(id);
}
//根据书名查询
public void show3(String bookName) throws Exception {
bookServiceImpl.getOneByName(bookName);
}
//根据编号查询
public void show4(int status) throws Exception {
bookServiceImpl.getMorByStatus(status);
}
}
##### BookDao
package com.swjd.dao;
import java.sql.ResultSet;
public interface BookDao {
//查询全部
public abstract ResultSet getAllBook() throws Exception;
//根据id查询
public abstract ResultSet getBookById(int id) throws Exception;
//根据书名查询
public abstract ResultSet getBookByName(String bookName) throws Exception;
//根据状态查询
public abstract ResultSet getBookByStatus(int status) throws Exception;
}
##### BookDaoImpl
package com.swjd.dao;
import com.swjd.util.BaseDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
@Repository
public class BookDaoImpl implements BookDao{
@Autowired
private BaseDao baseDao;
public ResultSet getAllBook() throws Exception {
//1.获取链接
Connection connection=baseDao.getConnection();
//2.编写sql
String sql=“select * from book”;
//3.执行(造船)
PreparedStatement ps=connection.prepareStatement(sql);
//4.拿结果
ResultSet rs=ps.executeQuery();
return rs;
}
public ResultSet getBookById(int id) throws Exception {
//1.获取链接
Connection connection=baseDao.getConnection();
//2.编写sql
String sql="select \* from book where id=?";
//3.执行(造船)
PreparedStatement ps=connection.prepareStatement(sql);
ps.setInt(1,id);
//4.拿结果
ResultSet rs=ps.executeQuery();
return rs;
}
public ResultSet getBookByName(String bookName) throws Exception {
//1.获取链接
Connection connection=baseDao.getConnection();
//2.编写sql
String sql="select \* from book where bookName=?";
//3.执行(造船)
PreparedStatement ps=connection.prepareStatement(sql);
ps.setString(1,bookName);
//4.拿结果
ResultSet rs=ps.executeQuery();
return rs;
}
public ResultSet getBookByStatus(int status) throws Exception {
//1.获取链接
Connection connection=baseDao.getConnection();
//2.编写sql
String sql="select \* from book where status=?";
//3.执行(造船)
PreparedStatement ps=connection.prepareStatement(sql);
ps.setInt(1,status);
//4.拿结果
ResultSet rs=ps.executeQuery();
return rs;
}
}
##### BookService
package com.swjd.service;
import java.sql.ResultSet;
public interface BookService {
//查询全部
public abstract void getAll() throws Exception;
//根据id查询
public abstract void getOneById(int id) throws Exception;
//根据书名查询
public abstract void getOneByName(String bookName) throws Exception;
//根据状态查询
public abstract void getMorByStatus(int status) throws Exception;
}
##### BookServiceImpl
package com.swjd.service;
import com.swjd.dao.BookDaoImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.sql.ResultSet;
import java.sql.SQLException;
@Service
public class BookServiceImpl implements BookService {
@Autowired
BookDaoImpl bookDaolImpl;
//拿全部数据,然后排版
public void getAll() throws Exception {
ResultSet rs=bookDaolImpl.getAllBook();
//设置显示格式
panBan(rs);
}
public void getOneById(int id) throws Exception {
ResultSet rs=bookDaolImpl.getBookById(id);
panBan(rs);
}
public void getOneByName(String bookName) throws Exception {
ResultSet rs=bookDaolImpl.getBookByName(bookName);
panBan(rs);
}
public void getMorByStatus(int status) throws Exception {
ResultSet rs=bookDaolImpl.getBookByStatus(status);
panBan(rs);
}
public void panBan(ResultSet rs) throws SQLException {
if(rs.getRow()==-1){
//表示没有查询到结果
System.out.println("-------无查询结果-------");
}else{
System.out.println("编号\t\t\t书名\t\t\t作者\t\t\t总页数\t\t\t状态");
while(rs.next()){
if (rs.getRow()==-1){
//表示没有查询到结果
System.out.println("------无查询结果------");
}else{
System.out.print(rs.getInt("id")+"\t\t\t"
+rs.getString("bookName")+"\t\t\t"
+rs.getString("author")+"\t\t\t"
+rs.getInt("totalPage")+"\t\t\t");
if (rs.getInt("status")==0){
System.out.println("借出");
}else if(rs.getInt("status")==1){
System.out.println("在库");
}else{
System.out.println("未知");
}
}
}
最后的话
最近很多小伙伴找我要Linux学习资料,于是我翻箱倒柜,整理了一些优质资源,涵盖视频、电子书、PPT等共享给大家!
资料预览
给大家整理的视频资料:
给大家整理的电子书资料:
如果本文对你有帮助,欢迎点赞、收藏、转发给朋友,让我有持续创作的动力!
网上学习资料一大堆,但如果学到的知识不成体系,遇到问题时只是浅尝辄止,不再深入研究,那么很难做到真正的技术提升。
需要这份系统化的资料的朋友,可以添加V获取:vip1024b (备注运维)
一个人可以走的很快,但一群人才能走的更远!不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!
KAC-1713546339321)]
给大家整理的电子书资料:
[外链图片转存中…(img-poDx1NUL-1713546339321)]
如果本文对你有帮助,欢迎点赞、收藏、转发给朋友,让我有持续创作的动力!
网上学习资料一大堆,但如果学到的知识不成体系,遇到问题时只是浅尝辄止,不再深入研究,那么很难做到真正的技术提升。
需要这份系统化的资料的朋友,可以添加V获取:vip1024b (备注运维)
[外链图片转存中…(img-heAm0Xlk-1713546339322)]
一个人可以走的很快,但一群人才能走的更远!不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!