jdbc编程之数据更新

package com.bupt.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class JDBCTest {
	public static Connection getConnection(){
		Connection conn = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");			//加载驱动
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp_db?useSSL=false", "root", "19930614");	//打开连接
		} catch (Exception e) {
			e.printStackTrace();
		}
		return conn;
	}
	
	public static void insert(){
		Connection conn = getConnection();
		Statement st = null;
		String sql = "INSERT INTO tbl_user(name,password,email)"+
					"VALUES('Tom','123456','tom@gmail.com')";
		try {
			st = conn.createStatement();
			int count = st.executeUpdate(sql);
			System.out.println("向用户表中插入了"+count+"条数据");
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public static void update(){
		Connection conn = getConnection();
		Statement st = null;
		String sql = "UPDATE tbl_user SET email='Tim@126.com' WHERE name='Tom'";
		try {
			st = conn.createStatement();
			int count = st.executeUpdate(sql);
			System.out.println("向用户表中更新了"+count+"条数据");
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public static void delete(){
		Connection conn = getConnection();
		Statement st = null;
		String sql = "DELETE FROM tbl_user WHERE name='Tom'";
		try {
			st = conn.createStatement();
			int count = st.executeUpdate(sql);
			System.out.println("从用户表中删除了"+count+"条数据");
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public static void main(String[] args) {
//		insert();
//		update();
		delete();
	}
}