mysql.java

本系统的设计模拟一般学校特别是高校的图书借阅管理内容

import java.sql.*;
import javax.swing.*;
import java.util.*;
import javax.swing.table.*;
public class MySQL{
	MySQL(String login,String password,String table,String sql){
		this.url=url;
		this.login=login;
		this.password=password;
		this.table=table;
		this.sql=sql;		
	}
	public ResultSet search(){		
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn=DriverManager.getConnection(url,login,password);
			statement=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			if(sql==null) sql="select * from"+" "+table;			
			rs=statement.executeQuery(sql);		
			}
			catch(SQLException e){
				JOptionPane.showMessageDialog(null,e.getMessage(),"database error",JOptionPane.ERROR_MESSAGE);
				System.exit(1);
			}
			catch(ClassNotFoundException cls){
				JOptionPane.showMessageDialog(null,cls.getMessage(),"drive not found ",JOptionPane.ERROR_MESSAGE);
				System.exit(1);
			}
			
		return rs;				
	}
	public int input(){
		int result=-1;
		try{
			if(!sql.equals("")){
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				conn=DriverManager.getConnection(url,login,password);
				statement=conn.createStatement();
				System.out.println(sql);			
				result=statement.executeUpdate(sql);
			}		
		}catch(SQLException e){
				JOptionPane.showMessageDialog(null,e.getMessage(),"database error",JOptionPane.ERROR_MESSAGE);
				//System.exit(1);
		}
		catch(ClassNotFoundException cls){
				JOptionPane.showMessageDialog(null,cls.getMessage(),"drive not found ",JOptionPane.ERROR_MESSAGE);
				System.exit(1);
		}				
		return result;
	}
	public void close(){
		try{
			statement.close();
			conn.close();
		}catch(SQLException e){}		
	}
//test driver	
	public static void main(String []args){
		//ResultSet rs=null;
		//Search sr=new Search("jdbc:odbc:guweiDNS","guwei","0340712","course");		
		try{
			/*	rs=sr.search();
				while(rs.next()){
				System.out.print(rs.getString(1)+" ");
				System.out.print(rs.getString(2)+" ");
				System.out.println(rs.getInt(3)+" ");
				}*/
			String s="insert into BookNumber values('456',10,10)";	
			MySQL sr=new MySQL("sa","","BookNumber",s);
			sr.input();		
				sr.close();	
		}catch(Exception e){}
	}
private String url="jdbc:odbc:TSJY";
private String sql;
private	String login;
private	String password;
private	String table;
ResultSet rs=null;
Connection conn=null;
Statement statement=null;
}