JavaWeb JDBC驱动链接

来源：互联网发布：python网络编程实例编辑：程序博客网时间：2024/06/06 03:23

使用JDBC步骤：

1.加载驱动程序： Class.forName(驱动程序类);

2.通过用户名密码和链接地址获取数据库对象：DriverManger.getConnection(链接地址，用户名，密码)

3.构造SQL语句

4。Statement实例： Statement stmt=conn.createStatement()

5.执行SQL语句 stmt.executeQuery(sql) 或stmt.executeUpdate(sql);

6.关闭连接 stmt.close();

package com.vince.jdbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;/** * JDBC的增删改操作 * @author lamp * */public class JdbcDemo {//数据库连接地址public final static String URL = "jdbc:mysql://localhost:3306/test";//用户名public final static String USERNAME = "root";//密码public final static String PASSWORD = "root";public final static String DRIVER = "com.mysql.jdbc.Driver";/** * 删除操作 */public static void delete(){try {Class.forName(DRIVER);Connection conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);String sql = "delete from person where id=1";Statement state = conn.createStatement();state.executeUpdate(sql);state.close();conn.close();System.out.println("delete success.");} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();}}/** * 更新操作 */public static void update(){try {Class.forName(DRIVER);Connection conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);String sql = "update person set age=19 where id=1";Statement state = conn.createStatement();state.executeUpdate(sql);state.close();conn.close();System.out.println("update success");} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();}}/** * 插入操作 */public static void insert2(){String name = "小白";int age  = 18;String description = "一个猥琐但不下流的人";try {Class.forName(DRIVER);Connection conn  = DriverManager.getConnection(URL, USERNAME, PASSWORD);//拼接SQL语句String sql = "insert into person(name,age,description)values('"+name+"',"+age+",'"+description+"')";Statement state = conn.createStatement();state.executeUpdate(sql);state.close();conn.close();System.out.println("success.");} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();}}/** * 插入操作 */public static void insert(){try {//1、加载数据库驱动程序Class.forName(DRIVER);//2、获取数据库连接Connection conn  = DriverManager.getConnection(URL, USERNAME, PASSWORD);//3、构造SQL语句String sql = "insert into person(name,age,description)values('小白',18,'一个猥琐但不下流的人')";//4、构造一个Statement实例(用来发送SQL语句的载体)Statement state = conn.createStatement();//5、执行SQL语句state.executeUpdate(sql);//6、关闭连接(释放资源)state.close();conn.close();System.out.println("success.");} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();}}public static void main(String[] args) {//insert();//update();//delete();insert2();}}

0 0