connectiondb.java

购物系统连库程序

package shopping;

import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.Date;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */

public class connectionDB {
    //连接数据库
    private Connection connection;
    private Statement statement;

    public Statement setDBConnection() throws Exception{

       // Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       // String url = "jdbc:odbc:personPayout";
        
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        String url ="jdbc:odbc:shopping";
        String user = "";
        String password ="";

        connection = DriverManager.getConnection(url, user, password);
        statement = connection.createStatement();

        return statement;
    }
    /**
     * 获取当前日期
     * @param form ShoppingForm
     */
    public String getSystemTime(String timeModel)
    {
         String s_time="";
         Date now_date = new Date();
         SimpleDateFormat formatter = new SimpleDateFormat(timeModel);
         s_time = formatter.format(now_date);
         
         return s_time;
    	
    }

    public connectionDB() {
    }
}