Mysql JDBC

   标准的MySQL JDBC程序：

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.Statement;
public class TestMySQLJDBC {
    public static void main(String[] args) throws Exception {
        Connection conn = null;
        Statement stmt = null;
        String sql;
        String url = "jdbc:mysql://10.10.18.147:3306/test?user=root&password=root&useUnicode=true&characterEncoding=UTF8";
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection(url);
            stmt = conn.createStatement();
            sql = "create table student(NO varchar(20),name varchar(20),primary key(NO))";
            int result = stmt.executeUpdate(sql);
            if (result != -1) {
                System.out.println("创建数据表成功");
                sql = "insert into student(NO,name) values('2017001','张三')";
                result = stmt.executeUpdate(sql);

                sql = "select * from student";
                ResultSet rs = stmt.executeQuery(sql);
                System.out.println("学号\t姓名");
                while (rs.next()) {
                    System.out.println(rs.getString(1)+ "\t" + rs.getString(2));
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try{
              if(stmt != null){
                  stmt.close();
              }
            }catch(Exception e){
                e.printStackTrace();
            }
            try{
                if(conn != null){
                   conn.close();
                }
            }catch(Exception e){
                  e.printStackTrace();
            }
        }
    }
}

使用绑定变量：

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import com.mysql.jdbc.PreparedStatement;
public class TestMySQLJDBCBind {
  public static void main(String args[]){
      Connection conn = null;
      PreparedStatement prestmt = null;
      ResultSet rs = null;
      String sql ="select * from student where no=?";
      String url = "jdbc:mysql://10.10.18.147:3306/test?user=root&password=root&useUnicode=true&characterEncoding=UTF8";
      try {
          Class.forName("com.mysql.jdbc.Driver");
          conn = DriverManager.getConnection(url);
          prestmt = (PreparedStatement) conn.prepareStatement(sql);
          prestmt.setString(1, "2017001");
          rs = prestmt.executeQuery();
          while(rs.next()){
              String NO = rs.getString("NO");
              System.out.println("学号:"+NO);
          }
      }catch (Exception e) {
          e.printStackTrace();
      }finally {
         try {
              if (rs != null) {
                  rs.close();
              }
              if (conn != null) {
                  conn.close();
              }
         } catch (Exception e) {
              e.printStackTrace();
      }
      }
   }
 }