public void testDDL()throws Exception{
        //1.注冊(cè)驅(qū)動(dòng)
        Class.forName("com.mysql.jdbc.Driver");
       
        //2.獲取連接
        Connection conn = DriverManager.getConnection(url, user, password);
       
        //3.創(chuàng)建Statement對(duì)象
        Statement stmt = conn.createStatement();
       
        //4.準(zhǔn)備sql語句
        String sql  ="CREATE TABLE student(sid INT PRIMARY KEY,sname VARCHAR(20),age INT)";
       
        //5.通過statement對(duì)象發(fā)送sql語句,返回執(zhí)行結(jié)果
        int count = stmt.executeUpdate(sql);
       
        //6.打印執(zhí)行結(jié)果
        System.out.println("影響了"+count+"條記錄");
}
//7.關(guān)閉資源
if(statement!=null)
{
    statement.close();
}

if(conn!=null)
{
    conn.close();
}

    // 獲取連接
    public static Connection getconnection() {
        Connection conn = null;
        try {
            // 1.注冊(cè)驅(qū)動(dòng)
            Class.forName("com.mysql.jdbc.Driver");
            // 2.獲取連接
            conn = DriverManager.getConnection(url, user, password);
            // 3.獲得statement對(duì)象
            Statement statement = conn.createStatement();
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return conn;
    }

    // 7.關(guān)閉資源
    public static void close(Statement statement, Connection connection) {
        {
            try {
                if (statement != null)
                    statement.close();
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }
}

    static{
        try {
            //1.獲得字節(jié)碼對(duì)象
            Class clazz = sqlUtil.class;
           
            //2.調(diào)用getResourceAsStream獲取路徑
            InputStream inputStream = clazz.getResourceAsStream("/db.properties");
            Properties pro = new Properties();
            pro.load(inputStream);
           
            //3.讀取參數(shù)
            url=pro.getProperty("url");
            password=pro.getProperty("password");
            user=pro.getProperty("user");
            driverClass=pro.getProperty("driverClass");
           
            Class.forName(driverClass);
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("注冊(cè)失敗！" + e.getMessage());
            throw new RuntimeException(e);
        }
    }
   
    // 獲取連接
    public static Connection getconnection() {
        Connection conn = null;
        try {       
            // 獲取連接
            conn = DriverManager.getConnection(url, user, password);
            // 獲得statement對(duì)象
            Statement statement = conn.createStatement();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return conn;
    }

    // 關(guān)閉資源
    public static void close(Statement statement, Connection connection) {
        {
            try {
                if (statement != null)
                    statement.close();
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }
}

import java.sql.Connection;
import java.sql.PreparedStatement;

import org.junit.Test;

public class PreparedStatementTest {
    Connection connection = null;
    @Test
    public void ddldmlTest() throws Exception {
        // 1.獲取連接
        connection = sqlUtil.getconnection();

        // 2.準(zhǔn)備SQL語句,預(yù)編譯語句，參數(shù)用？號(hào)占位
        String sql = "INSERT INTO SUBJECT VALUES(?,?)";

        // 3.獲得對(duì)象
        PreparedStatement preparedStatement = connection.prepareStatement(sql);

        /*
         * 4.設(shè)置SQL參數(shù) 需要參數(shù)是第幾個(gè)，并且知道它的類型 下面第一句表示：SQL語句第一個(gè)參數(shù)是int類型，參數(shù)值設(shè)置為3，如此類推
         */
        preparedStatement.setInt(1, 3);
        preparedStatement.setString(2, "英語");

        // 5.交給數(shù)據(jù)庫執(zhí)行SQL
        int num = preparedStatement.executeUpdate();

        System.out.println("有" + num + "條記錄受到了影響");

              sqlUtil.close(preparedStatement , connection );
    }
}

        // 2.準(zhǔn)備SQL語句,預(yù)編譯語句，參數(shù)用？號(hào)占位
        String sql = "select * from subject where sjid=? or sjname=?";

        // 3.獲得對(duì)象
        PreparedStatement preparedStatement = connection.prepareStatement(sql);

        /*
         * 4.設(shè)置SQL參數(shù) 需要參數(shù)是第幾個(gè)，并且知道它的類型 下面第一句表示：SQL語句第一個(gè)參數(shù)是int類型，參數(shù)值設(shè)置為3，如此類推
         */
        preparedStatement.setInt(1, 2);
        preparedStatement.setString(2, "語文");

        // 5.交給數(shù)據(jù)庫執(zhí)行SQL
        ResultSet rst = preparedStatement.executeQuery();
       
        //6.迭代結(jié)果集
        while(rst.next())
        {
            int id = rst.getInt("sjid");
            String name = rst.getString("sjname");
            System.out.println("ID:" + id + "  NAME:" + name);
        }
       
        //7.關(guān)閉連接
        sqlUtil.close(preparedStatement, connection);
}