package com.example.springboot.service;
|
|
import java.sql.Connection;
|
import java.sql.DriverManager;
|
import java.sql.PreparedStatement;
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
|
import org.springframework.stereotype.Component;
|
|
import com.example.springboot.entity.Glass;
|
@Component
|
public class JdbcConnections {
|
/**
|
* 数据库连接参数
|
* driver,url,username,password
|
*/
|
private static final String DRIVER = "com.mysql.jdbc.Driver";
|
private static final String URL = "jdbc:mysql://localhost:3306/canadames";
|
private static final String USERNAME = "root";
|
private static final String PASSWORD = "beibo.123/";
|
|
private static Connection conn = null;
|
private static PreparedStatement ps = null;
|
private static ResultSet rs = null;
|
|
public Glass selectGlass(int glassid) throws SQLException {
|
conn = getConn();
|
Glass glass=new Glass();
|
String sql = "select orderid from glass where glassid=?";
|
ps = conn.prepareStatement(sql);
|
ps.setInt(1, glassid);
|
rs= ps.executeQuery();
|
while (rs.next()) {
|
glass.setOrderId(rs.getString("orderid"));
|
}
|
conn.close();
|
return glass;
|
}
|
/**
|
* 1. 加载驱动
|
* 2. 获取连接 conn
|
* 3. 创建语句 ps
|
* 4. 执行语句 rs
|
* 5. 处理结果
|
* 6. 回收资源
|
*
|
* 实现CRUD
|
* 更新：
|
* 1增加
|
* 2删除
|
* 3修改
|
* 查询：
|
* 1. 查一个，一个对象
|
* 2. 查一组，做成一个对象列表，查全部
|
*/
|
public static Connection getConn() throws SQLException {
|
Connection conn = null;
|
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/canadames?serverTimezone=GMT%2B8&characterEncoding=utf-8", "root", "beibo.123/");
|
return conn;
|
}
|
|
static {
|
try {
|
Class.forName(DRIVER);
|
} catch (ClassNotFoundException e) {
|
e.printStackTrace();
|
}
|
}
|
|
|
}
|
