/**
  * 
  */
 package com.b510.hongten.annotation;

 import java.lang.annotation.Documented;
 import java.lang.annotation.ElementType;
 import java.lang.annotation.Retention;
 import java.lang.annotation.RetentionPolicy;
 import java.lang.annotation.Target;

 /**
  * JDBC annotation
  * 
  * @author Hongten
  * @date 2013-4-10
  */
 @Documented
 @Retention(RetentionPolicy.RUNTIME)
 @Target(ElementType.TYPE)
 public @interface JDBCAnnotation {

     String driver() default "com.mysql.jdbc.Driver";

     String dbName() default "";

     String encoding() default "UTF-8";

     String port() default "3306";

     String host() default "localhost";

     String userName() default "root";

     String password() default "";

 }

/java_annotation/src/com/b510/hongten/jdbc/JDBCUtil.java

復(fù)制代碼代碼如下:

/**
  * 
  */
 package com.b510.hongten.jdbc;

 import com.b510.hongten.annotation.JDBCAnnotation;

 /**
  * @author Hongten
  * @date 2013-4-12
  */
 @JDBCAnnotation(dbName = "db_lucene", port = "3306", host = "192.168.0.119", userName = "root", password = "root")
 public class JDBCUtil {

     private static String driver;
     private static String dbName;
     private static String encoding;
     private static String port;
     private static String host;
     private static String passwrod;
     private static String userName;
     private static String url;

     public void checkInterceptor(Class<?> cl) throws Exception {
         boolean flag = cl.isAnnotationPresent(JDBCAnnotation.class);
         if (flag) {
             JDBCAnnotation jdbcAnnotation = cl.getAnnotation(JDBCAnnotation.class);
             driver = jdbcAnnotation.driver();
             dbName = jdbcAnnotation.dbName();
             encoding = jdbcAnnotation.encoding();
             port = jdbcAnnotation.port();
             host = jdbcAnnotation.host();
             userName = jdbcAnnotation.userName();
             passwrod = jdbcAnnotation.password();
             url = "jdbc:mysql://" + host + ":" + port + "/" + dbName + "?characterEncoding=" + encoding;
             System.out.println("JDBCUtil加載注釋完成...");
         }
     }

     public JDBCUtil() {
         try {
             checkInterceptor(JDBCUtil.class);
         } catch (Exception e) {
             e.printStackTrace();
         }
     }

     public static String getDriver() {
         return driver;
     }

     public static void setDriver(String driver) {
         JDBCUtil.driver = driver;
     }

     public static String getDbName() {
         return dbName;
     }

     public static void setDbName(String dbName) {
         JDBCUtil.dbName = dbName;
     }

     public static String getEncoding() {
         return encoding;
     }

     public static void setEncoding(String encoding) {
         JDBCUtil.encoding = encoding;
     }

     public static String getPort() {
         return port;
     }

     public static void setPort(String port) {
         JDBCUtil.port = port;
     }

     public static String getHost() {
         return host;
     }

     public static void setHost(String host) {
         JDBCUtil.host = host;
     }

     public static String getPasswrod() {
         return passwrod;
     }

     public static void setPasswrod(String passwrod) {
         JDBCUtil.passwrod = passwrod;
     }

     public static String getUserName() {
         return userName;
     }

     public static void setUserName(String userName) {
         JDBCUtil.userName = userName;
     }

     public static String getUrl() {
         return url;
     }

     public static void setUrl(String url) {
         JDBCUtil.url = url;
     }

     
 }

/java_annotation/src/com/b510/hongten/jdbc/JDBCTest.java

復(fù)制代碼代碼如下:

/**
  * 
  */
 package com.b510.hongten.jdbc;

 import java.sql.Connection;
 import java.sql.DriverManager;
 import java.sql.PreparedStatement;
 import java.sql.ResultSet;
 import java.sql.SQLException;

 /**
  * 
  * @author Hongten</br>
  * @date 2012-7-16
  * 
  */
 public class JDBCTest {
     @SuppressWarnings("static-access")
     public static void main(String[] args) {
         JDBCUtil jdbcUtil = new JDBCUtil();
         String sql = "select * from mymails";
         try {
             Class.forName(jdbcUtil.getDriver());
             Connection conn = DriverManager.getConnection(jdbcUtil.getUrl(), jdbcUtil.getUserName(), jdbcUtil.getPasswrod());
             PreparedStatement ps = conn.prepareStatement(sql);
             ResultSet rs = ps.executeQuery();
             while (rs.next()) {
                 System.out.println("id : " + rs.getInt(1) + " name : " + rs.getString(2) + " mail : " + rs.getString(3));
             }
             // 關(guān)閉記錄集
             if (rs != null) {
                 try {
                     rs.close();
                 } catch (SQLException e) {
                     e.printStackTrace();
                 }
             }

             // 關(guān)閉聲明
             if (ps != null) {
                 try {
                     ps.close();
                 } catch (SQLException e) {
                     e.printStackTrace();
                 }
             }

             // 關(guān)閉鏈接對象
             if (conn != null) {
                 try {
                     conn.close();
                 } catch (SQLException e) {
                     e.printStackTrace();
                 }
             }
         } catch (Exception e) {
             e.printStackTrace();
         }
     }

 }