common.java~2~

来自「在jsp中实现分页显示」· JAVA~2~ 代码 · 共 27 行

package com.bict;
import java.sql.*;

public class Common {
    /*获取数据库连接*/
    public static Connection getConnection(){
          Connection con=null;
          try{
              Class.forName("org.gjt.mm.mysql.Driver");
              String str="jdbc:mysql://localhost:3306/test";
              con=DriverManager.getConnection(str,"root","");
          }catch(Exception e){
              e.printStackTrace();
          }
          return con;
    }
    /*释放数据库连接*/
    public static void freeConnection (Connection con){
         if(con!=null){
            try {
                con.close();
            } catch(SQLException ex) {
                ex.printStackTrace();
            }
         }
    }
}