JavaWeb JDBC驱动链接

使用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();
	}

}