JDBC : java database connect
步骤:
- 加载驱动
-
- 物理加载
-
- 将咖啡☕️状态下的 jar 加奶变成奶瓶�� 将第三方 jar 构建进web工程
- 请神口诀:1咖啡☕️ 2奶瓶�� 3加servlet 4对勾√
- 代码加载
-
- Class.forName("com.mysql.jdbc.Driver");
- 获得连接
-
- Connection conn = DriverManager.getConnection(“路径,用户,密码”);
- url=jdbc:mysql://localhost:3306/express?characterEncoding=utf8&useSSL=true
- jar包 :import java.sql.Connection;
- 连接获得执行对象
-
- Statement stmt = conn.createStatement();
- PreparedStatement preparedstatement = conn.prepareStatement(sql);
- 依靠stmt执行对象存储数据
-
- 增删改:stmt.execute
- stmt.execute("INSERT INTO jdbcuser VALUES(null,'"+name+"','"+pwd+"')");
- 查:stmt.executeQuery
- ResultSet rs = stmt.executeQuery("SELECT * FROM user WHERE acc='" + acc + "' AND pwd='" + pwd + "' ");
- 关闭通道
-
- resultSet.close();
- statement.close();
- connection.close();