JDBC连接MySQL数据库实现增删查改

package com.qll.operate;

import java.sql.*;

public class OperateUser {
 String driver = "com.mysql.jdbc.Driver";
 String url = "jdbc:mysql://localhost:3306/test";
 String name = "root";
 String password = "123456";
 static Connection conn = null;
 Statement st = null;
 ResultSet rs = null;
 String sql = null;

 public void add() {
  try {
   sql = "insert into tuser values(60024054,'全磊磊','男',24,'广东省深圳市')";
   Class.forName(driver);
   conn = DriverManager.getConnection(url, name, password);
   st = conn.createStatement();
   st.executeUpdate(sql);
   conn.close();
  } catch (Exception e) {
   e.printStackTrace();
  }
 }

 public void delete() {
  try {
   sql = "delete from tuser where id=60024054 ";
   Class.forName(driver);
   conn = DriverManager.getConnection(url, name, password);
   st = conn.createStatement();
   st.executeUpdate(sql);
   st.close();
   conn.close();
  } catch (Exception e) {
   e.printStackTrace();
  }
 }

 public void find() {
  try {
   sql = "select * from tuser";
   Class.forName(driver);
   conn = DriverManager.getConnection(url, name, password);
   st = conn.createStatement();
   rs = st.executeQuery(sql);
   while (rs.next()) {
    System.out.println(rs.getInt(1) + "/t" + rs.getString(2) + "/t"
      + rs.getString(3) + "/t" + rs.getInt(4) + "/t"
      + rs.getString(5));
   }
   rs.close();
   st.close();
   conn.close();
  } catch (Exception e) {
   e.printStackTrace();
  }
 }

 public void update() {
  try {
   sql = "update tuser set  id=60024410,name='李仁波',sex='女',age=24,addr='广东深圳'";
   Class.forName(driver);
   conn = DriverManager.getConnection(url, name, password);
   st = conn.createStatement();
   st.executeUpdate(sql);
   st.close();
   conn.close();
  } catch (Exception e) {
   e.printStackTrace();
  }
 }
}