Java Jdbc

package qs.jdbc;

import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Test {
  static Connection conn = null;
  static Statement stmt = null;
  
  public static void main(String[] args) {
 //   insert();
 //   update();
    delete();
    select(); 
  }
  
  public static void insert() {
    conn  = getConn();
    try {
      String sqlInsert = "insert into work(name, age, sex, addr, depart, wage)" 
          + "values('tom', '22','m','beijing','tech', '2500')";
      stmt = conn.createStatement();
      
      int count = stmt.executeUpdate(sqlInsert);
      System.out.println("inserted " + count + " rows");
 
      stmt.close();
      conn.close();
    } catch (SQLException e) {
      System.out.println("insert error !" + e.getMessage());
    }
  }
  
  public static void update() {
    conn = getConn();
    try {
      String sqlUpdate = "update work set wage = 3500 where name = 'tom'";
      stmt = conn.createStatement();
      int count = stmt.executeUpdate(sqlUpdate);
      System.out.println("updated " + count + " rows");
      
      stmt.close();
      conn.close();
      
    } catch (SQLException e) {
      System.out.println("update error ! " + e.getMessage());
    }
  }
  
  public static void select() {
    conn = getConn();
    try {
      String sqlSelect = "select * from work";
      stmt = conn.createStatement();
      ResultSet rs = stmt.executeQuery(sqlSelect);
      System.out.println("The Results are : " );
      while (rs.next()) {
        String name = rs.getString("name");
        int age = rs.getInt("age");
        String sex = rs.getString("sex");
        String addr = rs.getString("depart");
        int wage = rs.getInt("wage");
        
        System.out.println(name + " " + age + " " + sex + " " + addr + " " + wage);
      }
      
      stmt.close();
      stmt.close();
    } catch (SQLException e) {
      System.out.println("select error ! ");
    }
  }
  
  public static void delete() {
    conn = getConn();
    try {
      String sqlDelete = "delete from work where name = 'qs'";
      stmt = conn.createStatement();
      int count = stmt.executeUpdate(sqlDelete);
      System.out.println("deleted " + count + " row");
      stmt.close();
      conn.close();
    } catch (SQLException e) {
      System.out.println("delete error !" + e.getMessage());
    }
    
  }
  
  public static Connection getConn() {
    Connection myconn = null;
    try {
      Class.forName("com.mysql.jdbc.Driver");
      myconn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "test", "123456");
    } catch (Exception e) {
      System.out.println("conn error" + e.getMessage());
    }
    
    return myconn;
  }
}