JDBC编程 之 增删改查

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 }