JDBC编程总结

最近自己做的一个东西，用JDBC实现对数据库的操作，在此总结一下：
一、JDBC编程步骤：
1、创建指定数据库的URL
2、加载驱动类到JVM
3、利用DriverManager创建数据库连接
4、Connection类--数据库连接
5、Statement类--发送并执行静态sql
6、ResultSet类（结果集）
7、关闭连接
二、操作实例
此实例为操作MySQL数据库的实例
资源文件如下：

mysql数据库连接资源
DriverClass=com.mysql.jdbc.Driver
DbURL=jdbc:mysql://localhost:3306/test
UserName=root
Password=jia

连接工具类：

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
import java.io.FileInputStream;

/**
 * Created by IntelliJ IDEA.
 * User: jiaxy
 * Date: 2009-8-11
 * Time: 9:46:12
 * DESC:
 */
public class ConnectionUtils {
    private static String DRIVERClASSNAME;
    private static String DBURL;
    private static String USERNAME;
    private static String PASSWORD;
    static{
        Properties pro=new Properties();
        FileInputStream inStream;
        try {
            inStream=new FileInputStream("src/propertity/mysql.properties");
             pro.load(inStream);
        } catch (Exception e) {
            e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
        }
        DRIVERClASSNAME=pro.getProperty("DriverClass");
        DBURL=pro.getProperty("DbURL");
        USERNAME=pro.getProperty("UserName");
        PASSWORD=pro.getProperty("Password");
    }

    /**
     * 获取连接
     * @return
     */
    public static Connection getConnection() {
        Connection conn = null;

        try {
            Class.forName(DRIVERClASSNAME);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
        }
        try {
            conn= DriverManager.getConnection(DBURL,USERNAME,PASSWORD);
        } catch (SQLException e) {
            e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
        }
        return conn;

    }


}

测试类：

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

/**
 * Created by IntelliJ IDEA.
 * User: jiaxy
 * Date: 2009-8-11
 * Time: 9:32:59
 * DESC:
 */
public class Test {
    public static void main(String[] argv) throws Exception {
        Connection conn = null;
        try {
            conn = ConnectionUtils.getConnection();
            Statement stmt = ConnectionUtils.getConnection().createStatement();
            ResultSet rs = stmt.executeQuery("select username from user");
            while (rs.next()) {
                System.out.println(rs.getString(1));
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            conn.close();
        }

    }
}

三、注意
1.使用完之后注意关闭连接
2.Statement可以使用多次，定义多个。一个Statement对象只和一个ResultSet对象关联，并且是最后一次查询。