JDBC模板解决方案

JDBC模板

Java code

package com.cn.zjjt.util;import java.sql.Connection;import java.sql.DriverManager;public final class JdbcUtil {        public static final String DB_DRIVER="org.gjt.mm.mysql.Driver";    public static final String DB_URL="jdbc:mysql://localhost/zjjt";    public static final String DB_USERNAME="root";    public static final String DB_PASSWORD="root";    Connection conn;         private JdbcUtil(){            }        static  {         try {            Class.forName(DB_DRIVER);        } catch (Exception e) {            e.printStackTrace();            System.out.println(e.toString());        }    }        public  static Connection getConnection()  throws Exception //返回Connection    {        return DriverManager.getConnection(DB_URL,DB_USERNAME,DB_PASSWORD);    }        public void dbClose()  //关闭数据库连接    {        try {            conn.close();        } catch (Exception e) {            e.printStackTrace();            System.out.println(e.toString());        }    }}