Mysql JDBC

来源：互联网发布：陕西网络信息安全员编辑：程序博客网时间：2024/06/03 19:15

标准的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();      }      }   } }

阅读全文

0 0