JDBC初次体验

1. MySQL5

   1.1.在项目文件下创建lib文件夹,放入MySQL5的驱动包
   1.2.鼠标右键点击add as Library...,图片在MySQL8里
   1.3.导包 注册驱动 Class.forName("com.mysql.jdbc.Driver");
   1.4.获取 url :"jdbc:mysql://localhost:3306/数据库名";

2. MySQL8

   2.1.在项目文件下创建lib文件夹,放入MySQL8的驱动包
   2.2.鼠标右键点击add as Library...
   
   2.3.导包 注册驱动 Class.forName("com.mysql.cj.jdbc.Driver");
   2.4.获取 url :

   url = "jdbc:mysql://localhost:3306/数据库名?useSSL=false&serverTimezone=GMT";
   

3. JDBC初体验:

   import java.sql.Connection;
   import java.sql.DriverManager;
   import java.sql.Statement;
   import java.util.Scanner;
   
   public class ExerciseTest01 {
       /**
        * @param args
        * @throws Exception
        */
       public static void main(String[] args) throws Exception {
           Scanner scan = new Scanner(System.in);
   
           //1.导包 注册驱动
           Class.forName("com.mysql.cj.jdbc.Driver");
   
           //获取mysql对象
   //        String url = "jdbc:mysql://localhost:3306/mysql03exe?useSSL=false&serverTimezone=GMT";
           System.out.println("请输入你要操作的数据库:");
           String database = scan.next();
           String url = "jdbc:mysql://localhost:3306/" + database + "?useSSL=false&serverTimezone=GMT";
           //relation,connection 关系
         //  Connection relation = DriverManager.getConnection(url, "数据库用户名", "数据库密码");
           Connection relation = DriverManager.getConnection(url, "root", "kuigo1994");
         
           System.out.println("请输入你要操作命令:");
   //        String order = "update m set mo = 5000 where name = 'tom'";
   //        添加记录
           String order = "update m set mo = 5000 where name = 'tom'";
           //删除记录
   //        String sql = scan.nextLine(); 要报错?
           Statement stmt = relation.createStatement();
           int cou = stmt.executeUpdate(order);//返回影响行数
           if (cou > 0){
               System.out.println("执行成功");
           }else {
               System.out.println("执行失败");
           }
           //释放资源
           stmt.close();
           relation.close();
   
       }
   }
   

4. 用户登录判断:

   import util.JDBCUtill;//自定义的在5下
   import java.sql.Connection;
   import java.sql.ResultSet;
   import java.sql.SQLException;
   import java.sql.Statement;
   import java.util.Scanner;
   
   public class ExerciseTest07 {
       /** 判断用户登录请求
        * fa 为false 登录失败
        * fa 为true  登录成功
        * @param Sname
        * @param Spassword
        */
       public boolean judge(String Sname, String Spassword) {
           boolean fa = false;
           if (Sname == null && Spassword == null) {
               return fa;
           }
           Connection relation = null;
           Statement strm = null;
           ResultSet set = null;
           try {
               relation = JDBCUtill.getConnection();
               String roder = "select name ,password from userPassword where name = '"+Sname+"' and " +
                       "password = '"+Spassword+"'";
               strm = relation.createStatement();
               set = strm.executeQuery(roder);
               fa = set.next();
           } catch (SQLException e) {
               e.printStackTrace();
           } finally {
               JDBCUtill.close(set, strm, relation);
           }
           return fa;
       }
       public static void main(String[] args) {
           Scanner scanner = new Scanner(System.in);
           System.out.println("请输入用户:");
           String name = scanner.next();
           System.out.println("请输入密码:");
           String password = scanner.next();
           boolean judge = new ExerciseTest07().judge(name, password);
           if (judge)System.out.println("登录成功");
           else System.out.println("登录失败");
       }
   }
   

5. 抽取文件:
   5.1创建一个文件夹util,
   5.2创建一个文件bneo,内容如下:

   #url = jdbc:mysql://localhost:3306/数据库名//mysql5
   #url = jdbc:mysql://localhost:3306/数据库名?useSSL=false&serverTimezone=GMT//mysql8
   url = jdbc:mysql://localhost:3306/usPa?useSSL=false&serverTimezone=GMT
   user = root
   password = kuigo1994
   deivar = com.mysql.cj.jdbc.Driver
   

   5.3创建一个java文件:JDBCUtill.java

   package util;
   
   import java.io.FileReader;
   import java.io.IOException;
   import java.net.URL;
   import java.sql.*;
   import java.util.Properties;
   import java.util.Scanner;
   
   public class JDBCUtill {
       private static String url;
       private static String user;
       private static String password;
       private static String deivar;
   
       static {
           //读取文件
           try {
               Properties pro = new Properties();
               ClassLoader classLoader = JDBCUtill.class.getClassLoader();
               URL bneourl = classLoader.getResource("./util/bneo");//查找文件
               String path = bneourl.getPath();//获取路径
               pro.load(new FileReader(path));
               url = pro.getProperty("url");
               user = pro.getProperty("user");
               password = pro.getProperty("password");
               deivar = pro.getProperty("deivar");
               Class.forName(deivar);
           } catch (IOException e) {
               e.printStackTrace();
           } catch (ClassNotFoundException e) {
               e.printStackTrace();
           }
       }
   
       //使用配置文件
   
       /**
        * 获取连接
        * @return
        */
       public static Connection getConnection() throws SQLException {
           return DriverManager.getConnection(url,user,password);
       }
   
       /**
        *	处理异常
        * @param set
        * @param stm
        * @param conn
        */
       public static void close(ResultSet set,Statement stm,Connection conn){
           if (set != null){
               try {
                   set.close();
               } catch (SQLException e) {
                   e.printStackTrace();
               }
           }
           if (stm != null){
               try {
                   stm.close();
               } catch (SQLException e) {
                   e.printStackTrace();
               }
           }
           if (conn != null){
               try {
                   conn.close();
               } catch (SQLException e) {
                   e.printStackTrace();
               }
           }
       }
       public static void close(Statement stm,Connection conn){
           JDBCUtill.close(null,stm,conn);
       }
   }
   

   加油:    小团子

   ????????????????????????????
   
   ????????????????????????????