makedatebase.java

用java开发的一个进销存,开发工具jc, 数据库sql server

package classfile;
import java.sql.*;
import javax.swing.*;
class MakeDatebase{
	static boolean dataCleck = true;
	String conStr = "jdbc:odbc:mySql";
	Connection con = null;
	ResultSet rct = null;
	Statement sta = null;
	
	MakeDatebase(){
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con = DriverManager.getConnection(conStr);
			dataCleck = true;
	    }
	    catch (Exception ex1) {
	    }
	    
		try {
			sta = con.createStatement();
	    }
	    catch (Exception ex3) {
	    }	    		
	}


	public void connectionSql(){
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	    }
	    catch (Exception ex1) {
	    }
	}
	public void closeConnection(){
		try {
			if(sta!=null)
				sta.close();
			if(rct!=null)
				rct.close();
			if(con!=null)
				con.close();
	    }
	    catch (Exception ex2) {
	    }
	}	
	public void updateDate(String sql){
		try {
			sta.executeUpdate(sql);
	    }
	    catch (Exception ex3) {
	    	System.out.println (sql.substring(0,6));
	    	if(sql.substring(0,6).equals("insert"))
	    	{
	    		JOptionPane.showMessageDialog(null,"你要添加的编号己存在");
	    		dataCleck = false;
	    	}
	    	else if(sql.substring(0,6).equals("delete"))
	    		JOptionPane.showMessageDialog(null,"你要删除的数据己有业务发生,无法删除");
	    	else
	    		JOptionPane.showMessageDialog(null,"此操作失败");
	    		 
	    }
	}
	
	
	public void selectDate(String sql){
		try {
			rct = sta.executeQuery(sql);
	    }
	    catch (Exception ex4) {
	    	ex4.printStackTrace();
	    }
	}
	
}