命令行运行Java代码连接SQLServer、MySQL

短命女 2023-07-01 08:56 5阅读 0赞

### 文章目录 ###

*  1 方式一
 *  2 方式二

# 1 方式一 #

**环境：openjdk-14**  
![在这里插入图片描述][20200722190844350.png]  
源代码（此处以mysql为例）

package a_package;
    
    import java.sql.*;
    
    public class TestMysql { 
        public static void main(String[] args) throws Exception { 
            Class.forName("com.mysql.cj.jdbc.Driver");
            String url = "jdbc:mysql://localhost:3306/test_con?serverTimezone=UTC&useSSL=true";
            String user = "root";
            String password = "fanyi";
            Connection connection = DriverManager.getConnection(url, user, password);
    
            if (connection != null) { 
                Statement stmt = connection.createStatement();
                ResultSet rs = stmt.executeQuery("select * from t_test");
    	    
    	    System.out.printf("%5s,%10s,%5s\n", "id","name","age");
    	    System.out.println("----------------------");
                while (rs.next()) { 
    		    System.out.printf("%5s,%10s,%5s\n", rs.getString(1),rs.getString(2),rs.getString(3));
                }
            } else { 
                System.out.println("Fail.");
            }
    
            connection.close();
        }
    }

运行方式一

$ javac -cp mysql-jdbc/mysql-connector-java-8.0.21.jar package/a_package/TestMysql.java 
    $ java -cp mysql-jdbc/mysql-connector-java-8.0.21.jar package/a_package/TestMysql.java 
       id,      name,  age
    ----------------------
        1,      Lisa,   30
        2,     Jason,   25

运行方式二（由于jdk版本的升级，可以不使用`javac`，直接用命令`java`编译并运行java源文件了）

$ java -cp mysql-jdbc/mysql-connector-java-8.0.21.jar package/a_package/TestMysql.java
       id,      name,  age
    ----------------------
        1,      Lisa,   30
        2,     Jason,   25

# 2 方式二 #

**环境：jdk-8**

1.  向CLASSPATH添加jar包  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjI1MDMwMg_size_16_color_FFFFFF_t_70]  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjI1MDMwMg_size_16_color_FFFFFF_t_70 1]  
    ![在这里插入图片描述][20200120205013457.png]  
    注：如果要添加多个路径的话，每个路径要以英文分号`;`隔开。要是环境变量中没有`CLASSPATH`的话，自己新建一个就行。
2.  Java代码

// ********************连接SQLServer**************************
    import java.sql.*;
    
    public class ConnectSQLServer { 
    	public static void main(String[] args) { 
    		Connection connection;
    		String driver   = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
    		String url      = "jdbc:sqlserver://localhost:1433;DatabaseName=Java8";
    		String user     = "sa";
    		String password = "fanyi";
    
    		try { 
    			Class.forName(driver); 
    			connection = DriverManager.getConnection(url, user, password);
    
    			if (connection != null) { 
    				System.out.println("Success.");
    			} else { 
    				System.out.println("Fail.");
    			}
    
    			connection.close();
    		} catch (Exception e) { 
    			e.printStackTrace();
    		}
    	}
    
    }
    
    // ********************连接Mysql**************************
    
    import java.sql.*;
    
    public class ConnectMysql { 
    	public static void main(String[] args) throws Exception { 
    		Class.forName("com.mysql.jdbc.Driver");
    		String url      = "jdbc:mysql://localhost:3306/hibernate?useSSL=true";
    		String user     = "root";
    		String password = "fanyi";
    		Connection connection = DriverManager.getConnection(url, user, password);
    
    		if (connection != null) { 
    			System.out.println("Success.");
    		} else { 
    			System.out.println("Fail.");
    		}
    
    		connection.close();
    	}
    }

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjI1MDMwMg_size_16_color_FFFFFF_t_70 2]  
若是不使用IDE，且java代码中需要第三方jar包，需要手动在CLASSPATH中添加。这样JDK才能搜索到依赖的jar包

[20200722190844350.png]: https://img-blog.csdnimg.cn/20200722190844350.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjI1MDMwMg_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200120210037716.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjI1MDMwMg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjI1MDMwMg_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200120201553891.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjI1MDMwMg==,size_16,color_FFFFFF,t_70
[20200120205013457.png]: https://img-blog.csdnimg.cn/20200120205013457.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjI1MDMwMg_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200120205738301.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjI1MDMwMg==,size_16,color_FFFFFF,t_70