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查看参数