databaseoperate.java~5~

来自「这是一个电影票务的管理系统,内包含源代码......」· JAVA~5~ 代码 · 共 54 行

package com.cinema.db;

import java.sql.*;
import java.util.*;
import com.cinema.bean.*;


public class DatabaseOperate {
    String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=pubs";
    Connection con= null;
    public DatabaseOperate() {
        try
        {
            //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            con=DriverManager.getConnection(url,"sa","");
        }catch(Exception ce)
        {
            ce.printStackTrace();
        }

    }
    public void closecon(Connection con,Statement stmt,PreparedStatement pstmt,ResultSet res)
    {
        try
        {
            if(con != null)
            {
                con.close();
            }
            if(stmt !=null)
            {
                stmt.close();
            }
            if(pstmt != null)
            {
                pstmt.close();

            }
            if(res != null)
            {
               res.close();
            }
        }catch(Exception ce)
        {
            ce.printStackTrace();
        }
    }




}