idea和jdbk连接数据库

idea配置环境变量

	MAVEN_HOME=maven放置的位置
	PATH=%MAVEN_HOME%\bin

如果使用mysql时在idea里pom.xml添加

	<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
		<version>5.1.28</version>
	</dependency>

添加jdbc工具类

package org.example;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBUtils {
    public static Connection getConnection(String url, String user, String passwd){
        Connection connection=null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            try {
                 connection = DriverManager.getConnection(url, user, passwd);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        return connection;
    }
    public static void closeConnection(Connection conn){
        if(conn !=null){
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
   public static void exeSQL(Connection conn,String sql){
        System.out.println("sql=>" + sql);
        try {
            PreparedStatement preparedStatement = conn.prepareStatement(sql);
            preparedStatement.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    public static ResultSet selectSQL(Connection conn,String sql){
        System.out.println("sql=>" + sql);
        ResultSet resultSet = null;
        try {
            PreparedStatement preparedStatement = conn.prepareStatement(sql);
            resultSet = preparedStatement.executeQuery(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return resultSet;
    }
}

连接

package org.example;
import java.sql.Connection;
public class JDBCAPP {
    public static void main(String[] args) {
        String url = "jdbc:mysql://192.168.41.12:3306/bigdata";
        String user="root";
        String passwd = "123456";
        //1.获取mysql的连接
        Connection connection = DBUtils.getConnection(url, user, passwd);
        //2.select
        String sql="select name,age from bigdata.user_info";
        ResultSet resultSet = DBUtils.selectSQL(connection, sql);
        try {
            while (resultSet.next()){
                String name = resultSet.getString(1);
                int age = resultSet.getInt(2);
                System.out.println(name+","+age);
            }
            //1.insert、update、delete
        String sql1 = "insert into bigdata.user_info (name,age) values ('zs',18)";
        String sql2 = "update bigdata.user_info set name='qqqqqqqq' where id=11";
        String sql3 = "delete from bigdata.user_info where id=11";
        DBUtils.exeSQL(connection,sql1);
            //3.关闭连接
            DBUtils.closeConnection(connection);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

vscode 快捷键

1.ctrl + n => 打开一个窗口
2.shift+alt 多行编辑
3.sql 格式化 =》 shift+alt+f =>标准代码格式
4.ctrl + alt+i 数字递增
5.搜索文本内容 crtl+f
6.shift+alt+l 大写变小写
7. alt+shift+u小写变大写
8. 显示/隐藏左侧边栏：ctrl+b
9. ctrl+shift+L选中所有此单词
10. shift+alt+i 跳到每行末尾

idea 快捷键

1.psvm =》 main
2.alt+回车 =》try/catch
3.ctrl+alt+l调整代码格式 =》mysql
4.ctrl+alt+o去除没有使用的包
5.ctrl+p查看参数

切屏 alt+tab