conncetion.java

网吧管理系统. 实现了网吧收费的管理.每小时设置2元,不足1小时扣除2元,1小时5分内扣除2元,以后扣除两小时的4元.

package com.liu.Cortrol;

import java.sql.*;


public class Conncetion {
		String url;
		Connection con;
		Statement s;
		Statement sm;
		ResultSet rs;
		
		public void Conncentionsql(){
			url = "jdbc:odbc:Netbar";
			try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	
			con = DriverManager.getConnection(url);
			s = con.createStatement();
			}
			catch(Exception e){
				e.printStackTrace();
			}
		}
		
		public void close(){
			
			try{
				if(sm!= null){
				sm.close();
				}
				con.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
	
}