CanadaMes.git - Gitblit

New file
			@@ -0,0 +1,72 @@
			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.getShort("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();
			}
			}


			}