import java.sql.Connection;
 
import java.sql.DriverManager;
 
import java.sql.PreparedStatement;
 
import java.sql.ResultSet;
 
import java.sql.SQLException;
 
import java.sql.Statement;
  
public class classname {
    public static String url = "jdbc:mysql://localhost:3306/test";//characterEncoding=GBK
    public static String username = "root";
    public static String password = "root";
    public static Connection con;
    public static Statement stmt;
    public static ResultSet rs;
    public static PreparedStatement pstmt;
     
    public static void main(String[] args) throws SQLException {
        connect();
        //select();
 
        //insert();
 
        //update();
        //delete();
 
        close();
    }
    public static void connect() {
        // 定位驱动
        try {
            Class.forName("com.mysql.jdbc.Driver");
            System.out.println("加载驱动成功!"); 
        } catch (ClassNotFoundException e) {
            System.out.println("加载驱动失败!");
            e.printStackTrace();
        }
        // 建立连接
        try {
            con = DriverManager.getConnection(url, username, password);
            stmt = con.createStatement();
            System.out.println("数据库连接成功!"); 
        } catch(SQLException e) {
            System.out.println("数据库连接失败!");
            e.printStackTrace();
        }
    }
    public static void select() {
        try {
          
         String sql="select * from test where name=? "; 
            pstmt=con.prepareStatement(sql); 
           pstmt.setString(1,"root"); 
         //String sql="select * from test where name='root' "; 
            //rs = stmt.executeQuery(sql);
           rs=pstmt.executeQuery();
            while (rs.next()) {
             System.out.println("你的第一个字段内容为："+rs.getString("name")); 
             System.out.println("你的第二个字段内容为："+rs.getInt(1)); 
            }
            rs.close();
        }catch (Exception e) {
            System.out.println("数据查询失败!");
            e.printStackTrace();
        }
    }
    public static void insert() {
        try {
         String sql="insert into test (id,name) values('2','admin')";
         stmt.executeUpdate(sql);
            System.out.println("数据插入成功!");
        }catch (Exception e) {
            System.out.println("数据插入失败!");
            e.printStackTrace();
        }
         
    }
    public static void update() {
        try {
         String sql="update test set name='rootroot' where id=1";
            stmt.executeUpdate(sql);
            System.out.println("数据更新成功!");
        }catch (Exception e) {
            System.out.println("数据更新失败!");
            e.printStackTrace();
        }
    }
    public static void delete() {
        try {
         String sql="delete from test where id=?";
          pstmt = con.prepareStatement(sql);
             pstmt.setInt(1,1);
             pstmt.executeUpdate();
            System.out.println("数据删除成功!");
        }catch (Exception e) {
            System.out.println("数据删除失败!");
            e.printStackTrace();
        }
    }
    public static void close() {
     try{
      if(rs!=null)
             rs.close();
      if(stmt!=null)
             stmt.close();
      if(con!=null)
             con.close();
     }catch(Exception e)
     {
      e.printStackTrace();
     }
    }
     
}