databaseoperate.java~12~

这是一个电影票务的管理系统,内包含源代码......

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");

        }
        catch(Exception ce)
        {
            ce.printStackTrace();
        }

    }

    public Connection getCon()
    {
        try
        {
            con = DriverManager.getConnection(url, "sa", "");
        }
        catch (SQLException ex)
        {
            ex.printStackTrace();
        }

        return con;
    }

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

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

    public boolean updateTicket(String sql)
    {
        boolean flag = false;
        con = this.getCon();
        PreparedStatement pstmt = null;
        try
        {
            pstmt = con.prepareStatement(sql);
            int num = pstmt.executeUpdate();
            flag = num>0?true:false;
        }
        catch (SQLException ex)
        {
            ex.printStackTrace();
        }
        finally
        {
            try
            {
                this.closecon(null,pstmt,null,con);
            }
            catch(Exception ex)
            {
                ex.printStackTrace();
            }
        }
        return flag;
    }

    public Vector queryTicket(String seat)
    {
        Vector vec = new Vector();
        con = this.getCon();
        PreparedStatement pstmt = null;
        ResultSet res = null;
        try
        {
            String sql = "select * from tab_ticket where seat=?";
            pstmt = con.prepareStatement(sql);
            pstmt.setString(1,seat);
            res = pstmt.executeQuery();
            while(res.next())
            {
                TicketBean tb = new TicketBean();
                tb.setSeat(res.getString(1));
                tb.setTsign(res.getInt(2));
                vec.add(tb);
            }
        }
        catch (SQLException ex)
        {
            ex.printStackTrace();
        }
        finally
        {
            try
            {
                this.closecon(res, pstmt, null, con);
            }
            catch (Exception ex)
            {
                ex.printStackTrace();
            }
        }
        return vec;
    }

}