bdatacontrol.java

来自「简单的电子银行系统主要实现取钱存钱转账 系统很简单请大家帮我看看啊也可以给点意见」· Java 代码 · 共 141 行

package e_BankSystem_Data;

import java.sql.*;
import java.util.Vector;

public class BDataControl 
{
	   protected Connection connection;
	   protected Statement stmt;
	   protected ResultSet resultset;

	 
		
		 public BDataControl()
		   {
		     try
		     {
		    	 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				 connection = DriverManager.getConnection("jdbc:odbc:电子银行系统1");
				 stmt = connection.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_UPDATABLE);
		     }
		     catch(Exception ex)
		     {
		       System.out.println(ex.getMessage());
		     }
		   } 

		   
		   public Connection getConnection()
			{
			  return connection;
			}
		  
	  

		   public long executeUpdate(String sql) //throws Exception
		   {
		     try
		     {
		       return  stmt.executeUpdate(sql);
		     }
		     catch(Exception ex)
		     {
		       System.out.println(ex.getMessage());
		       return -1;
		     }
		   }

		   
		   
		   public ResultSet executeQuery(String sql) //throws Exception
		   {
		     try
		     {
		       return stmt.executeQuery(sql);
		     }
		     catch(Exception ex)
		     {	
		       System.out.println(ex.getMessage());
		       ex.printStackTrace();
		       return null;
		     }
		   }


	 
	   public void closeStmt()
	   {
	     try
	     {
	    	 if (stmt != null)
		       {
		         stmt.close();
		       }
	     }
	     catch(Exception ex)
	     {
	       System.out.println(ex.getMessage());
	       System.out.println(ex.getMessage());
	     }
	   }
	   
	   
	   
	 
	   
	   
	   public int getColumnCount(ResultSet resultset)
		{
			int Num = 0;
			try
			{
				Num = resultset.getMetaData().getColumnCount();
			}
			catch(Exception e)
			{
				e.printStackTrace();
			}
			return Num;
		}
		//获取表中的数据
		public Vector getData(int columnCount,ResultSet resultset)
		{
				Vector InfoVectors = new Vector();
				try
				{
					while (resultset.next()) 
					{
						Vector singleRow = new Vector();
						for (int i = 0; i < columnCount; i++)
							singleRow.addElement(resultset.getObject(i + 1));
						InfoVectors.addElement(singleRow);
					}
				}
				catch(SQLException e)
				{
					e.printStackTrace();
				}
				return InfoVectors;
		}
	


		//获取表的列名
		public Vector getColumnName(int columnCount,ResultSet resultset)
		{
			Vector InfoVectors = new Vector();	
			try
			{
				for (int i = 1; i <= columnCount; i++)
					InfoVectors.addElement(resultset.getMetaData().getColumnName(i));
			}
			catch(Exception e)
			{
				e.printStackTrace();
			}
			return InfoVectors;
			
		}
	}