connectiondatabase.java

struts2+spring+Hibernate整合的一个网站案例

package myitem.db;

import java.sql.*;



public class ConnectionDatabase {
	  private static String driver="org.gjt.mm.mysql.Driver";
	  private static String url="jdbc:mysql://localhost/itemjsp?user=root&password=&useUnicode=true&characterEncoding=utf-8";
	  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 void close()
		{
			try
			{
				this.cnn.close();
			}
			catch (Exception e)
			{
			}
		}
   }