dbconn.java

用java做的网上商店系统！代码完整。希望为大家有所帮助！

package org.qhit.shop.db;

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

public class DBConn {
	//1.连接
	public static Connection getConn(){
		Connection conn=null;
		String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
		String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=eshop";
		try {
			Class.forName(driver);
			conn=DriverManager.getConnection(url,"sa","123");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;		
	}
	//2.关闭
	public static void close(Connection conn){
		try {
			if(conn!=null)  conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}