package myitem.renshu;

import java.sql.*;
import javax.naming.*;
import javax.sql.*;


public class DBHandle {
	  private static String driver="org.gjt.mm.mysql.Driver";
	  private static String url="jdbc:mysql://localhost/itemjsp?user=root&password=langgege&useUnicode=true&characterEncoding=gb2312";
	  private static Connection cnn;
	     public static Connection getConn(){
	    	  try{
	    		  Class.forName(driver).newInstance();
	    		      cnn=DriverManager.getConnection(url);

	    		  }
	    		   catch(Exception e){
	    		      e.printStackTrace();
	    		  }
	    	 return cnn;
	     }
	     public static void closeResource(Statement st, ResultSet rs, Connection cnn) {
	         try {
	             if (rs != null) {
	                 rs.close();
	             }
	         }
	         catch (Exception es) {
	             es.printStackTrace();
	         }
	         try {
	             if (st != null) {
	                 st.close();
	             }
	         }
	         catch (Exception es) {
	             es.printStackTrace();
	         }
	         try {
	             if (cnn != null) {
	                 cnn.close();
	                 cnn = null;
	             }
	         }
	         catch (Exception es) {
	             es.printStackTrace();
	         }
	     }
 

}