前文:笔者在idea上学习遇到诸多困难,记录一下,方便后来的人
1.新建
2.右键
3.右键.idea新建Directory命名为lib
4.找到web下的WEB_INF,右键WEB_INF,右键创建新的Directory命名为classes
5.点击Project Structure
6.如下图,选择为刚才新建的classes目录
两个都选classes,最后点击apply
7.把tomcat下的lib文件下的jsp.api和servlet,以及官网下载的mysql包都放在刚创建好的code文件下的.idea的子文件不断寻找到lib,然后放在其下
8.右键刚刚添加进来的jsp-api.jar,然后选择add as library,三个依次照做
9.点击右边的add configuration,找到Tomcat server 选择local
再点击右下角感叹号的Fix,再次点击apply,再点击ok
10.右键src,选择Package,
输入com.javaBean,回车键
再右键com.javaBean新建BookUtils
package com.javaBean;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class BookUtils {
private static final String URL = "jdbc:mysql://127.0.0.1:3306/book";
//将book替换为自己的数据库,后面的root和密码也换为你自己的
private static final String USER = "root";
private static final String PASSWORD = "123456";
public static Connection getConnection() {
Connection conn = null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
conn = DriverManager.getConnection(URL, USER, PASSWORD);
} catch (ClassNotFoundException e) {
e.printStackTrace();
throw new RuntimeException("Failed to load JDBC driver", e);
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException("Failed to get database connection", e);
}
return conn;
}
}
复制这段代码,进入BookUtils
下好mysql,也可以下好Mysql workbench,这样创建表格才会方便一点
或者直接使用命令行语句如下
win+r
输入cmd
mysql -u root -p
再输入密码,密码是在安装mysql时候设置的
再输入
create database book;
先输入这个代码选择数据库
use book;
再输入这段代码建立booktab的表
CREATE TABLE booktab (
name VARCHAR(255),
author VARCHAR(255),
price DOUBLE,
push VARCHAR(255)
);
再输入
insert into booktab(name,author,price,push)
values('不知道','不知道',0,'不知道出版社');
10.
import com.javaBean.BookUtils;
import com.javaBean.BookUtils;
import java.sql.*;
public class Main {
public static void main(String[] args) {
Connection conn = BookUtils.getConnection();
if (conn != null) {
System.out.println("数据库连接成功!");
String sql = "SELECT * FROM booktab";
try (Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql)) {
while (rs.next()) {
String name = rs.getString("name");
String author = rs.getString("author");
double price = rs.getDouble("price");
String publish = rs.getString("push");
System.out.println("书名: " + name + ", 作者: " + author + ", 价格: " + price + ", 出版社: " + publish);
}
} catch (SQLException e) {
e.printStackTrace();
}
} else {
System.out.println("数据库连接失败!");
}
}
}
11.右键运行Main
控制台输出连接成功,如果乱码请看笔者的另一篇博客,创作不易,点个赞或者收藏下叭