dbcon.java

一个经典购物车（shoppingcart）实例代码

package com.jpioneer.application.util;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBCon {
   private static Connection con;
   String url="jdbc:jtds:sqlserver://127.0.0.1:1433/shopping";
   String user="sa";
   String password="sa";
   public DBCon() throws Exception{
	   Class.forName("net.sourceforge.jtds.jdbc.Driver");
	   con=DriverManager.getConnection(url,user,password);
   }
	public static Connection getCon() throws Exception{
		new DBCon();
		return con;
	}
   
	public static void setClose() throws Exception{
		if(con!=null){
			con.close();
		}
	}
}