linkbase.java

来自「自己做的影碟碟出租管理系统」· Java 代码 · 共 57 行

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import java.util.*; 
public class LinkBase {

      String url="jdbc:odbc:Mybase";
	  String login="sa";
	  String password=null;
	  Connection conn=null;
      Statement stmt=null;
	  ResultSet rs=null;
	  int rsnum=0;
	  ResultSetMetaData rsmd=null;
	  static int success=0;
	   
	   public LinkBase(String sqlStr,int ActionCode) {
	   	try {
	   		success=0;
	   		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	   		conn=DriverManager.getConnection(url,login,password);
	   	    stmt=conn.createStatement();
	   	    	if (ActionCode==1)
	   	    	{rs=stmt.executeQuery(sqlStr);
	   	    	 rsmd=rs.getMetaData();
	   	    	}
	   	        else 
	   	         rsnum=stmt.executeUpdate(sqlStr);
	   	         success=1;
    	}
    	  
			catch(ClassNotFoundException e){
			JOptionPane.showMessageDialog(null,e.getMessage(),"出错了！",JOptionPane.ERROR_MESSAGE);
			System.exit(1);
			}
			catch(SQLException e){
			JOptionPane.showMessageDialog(null,e.getMessage(),"出错了",JOptionPane.PLAIN_MESSAGE);
			 
			}
		
	   }
	
   public ResultSet  GetResult(){
	   	return rs;
	   	}
  public ResultSetMetaData  GetRsmd(){
	   	return rsmd;
	   	}
   

}