JDBC编程 之 增删改查

 1 package com.good.jdbc;
 2 
 3 import java.sql.Connection;
 4 import java.sql.DriverManager;
 5 import java.sql.ResultSet;
 6 import java.sql.Statement;
 7 
 8 public class Main {
 9     //1数据库连接的方法就独立出来了
10     public static Connection getConnection(){
11         Connection conn = null;
12         try {
13             Class.forName("com.mysql.jdbc.Driver");
14             conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp_db","root","");
15         } catch (Exception e) {
16             e.printStackTrace();
17         }
18         return conn;
19     }
20     //2然后编写一个同样是静态的向数据表中插入数据的方法
21     public static void insert(){
22         //获取数据库连接
23         Connection conn = getConnection();
24         try {
25             String sql = "INSERT INTO tbl_user(name,password,email)" +
26                          "VALUES('Tom','123456','tom@gmail.com')";
27             Statement st = conn.createStatement();
28             int count = st.executeUpdate(sql);
29             System.out.println("向用户表中插入了 " + count + " 条记录");
30              conn.close();
31         } catch (Exception e) {
32             e.printStackTrace();
33         }
34     }
35     //3接下来写一个更新的方法
36     public static void update(){
37         //获取数据库连接
38         Connection conn = getConnection();
39         try {
40             String sql = "UPDATE tbl_user SET email='tom@126.com' WHERE name = 'Tom'";
41             Statement st = conn.createStatement();
42             int count = st.executeUpdate(sql);
43             System.out.println("向用户表中更新了 " + count + " 条记录");
44              conn.close();
45         } catch (Exception e) {
46             e.printStackTrace();
47         }
48     }
49     //4删除记录的方法
50     public static void delete(){
51         //获取数据库连接
52         Connection conn = getConnection();
53         try {
54             String sql = "DELETE FROM tbl_user WHERE name = 'TOM'";
55             Statement st = conn.createStatement();
56             int count = st.executeUpdate(sql);
57             System.out.println("向用户表中删除了 " + count + " 条记录");
58              conn.close();
59         } catch (Exception e) {
60             e.printStackTrace();
61         }
62     }
63     public static void main(String[] args) {
64 //        insert();
65         delete();
66         update();
67     }
68 }