databasesql.java

这是网络连通性测试与日志管理

import java.sql.*;
import java.util.*;
import  javax.swing.*;
public class DataBaseSQL{
		public static String url="jdbc:odbc:Testcon";
		public static Connection con;
		public static PreparedStatement stmt;
		public  DataBaseSQL(){
			
			try{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				con = DriverManager.getConnection(url);	
			}
			catch(Exception e){
				System.out.println("Error");
			}
		}
		public static void conClose(){
			try{
				con.close();
			}catch(Exception e){
				System.out.println("close Error");
			}
		}
	
		public static Vector setSelect(String sSelect,int seleType){
				ResultSet rs;
				Vector databaseData= new Vector();
				LogFloor floor= new LogFloor();
				ConfigFloor floor1 = new ConfigFloor();
				if(seleType==1){
				try{
					Statement stmt = con.createStatement();
					rs=stmt.executeQuery(sSelect);
				while(rs.next()){
					floor.setDate(rs.getString("logDate"));
					floor.setIP(rs.getString("IP"));
					floor.setPort(new Integer(rs.getInt("port")));
					floor.setWrongType((Integer)rs.getInt("wrongType"));
					Vector v=floor.getDataVector();
					databaseData.add(v);
				}
					stmt.close();			
				}
				catch(Exception e){
					System.out.println("sSelect Error");
				}

				}
				if(seleType==2){
				try{
					Statement stmt = con.createStatement();
					rs=stmt.executeQuery(sSelect);
				while(rs.next()){
					floor1.setIP(rs.getString("IP"));
					floor1.setPort(new Integer(rs.getInt("port")));
					floor1.setWrongTimes(new Integer(rs.getInt("wrongTimes")));
					floor1.setStatus(rs.getString("status"));
					floor1.setTimes(new Integer(rs.getString("times")));
					Vector v=floor1.getDataVector();
					databaseData.add(v);
				}
					stmt.close();			
				}
				catch(Exception e){
					System.out.println("sSelect Error");
				}

				}
				return databaseData;
			}
			public static void setInsert(String sInsert){
				try{
					
					Statement stmt = con.createStatement();
					stmt.executeUpdate(sInsert);
					stmt.close();
				}
				catch(Exception e){
					JFrame dialog = new JFrame();
					System.out.println("Insert Error");
					JOptionPane.showMessageDialog(dialog,"IP设备已在列表中！","Warning",JOptionPane.WARNING_MESSAGE);
				}		
			}
			public static void setDelete(String sDelete){
				try{
					Statement stmt = con.createStatement();
					stmt.executeUpdate(sDelete);
					stmt.close();
				}
				catch(Exception e){
					System.out.println("sDelete Error");
				}
			}
			public static void setUpdate(String sUpdate){
				try{
					Statement stmt = con.createStatement();
					stmt.executeUpdate(sUpdate);
					stmt.close();
				}
				catch(Exception e){
					System.out.println("sUpdate Error");
				}
			}
/*
	public static void main(String[] args){		
		//java.util.Date u = new java.util.Date();
		 String sSelect="select * from Config";
		 String sInsert="insert into Log(logDate,IP,port,wrongType)values('"+(new java.util.Date())+"','2.2.2.2',0,1)";
		 String sDelete="Delete from Log where id='060006'";
		 String updateData="UPdate Config set status='Ok',wrongTimes=0 where IP='127.0.0.1'";
		 String ss="COMMIT";
		 DataBaseSQL f= new DataBaseSQL();
		 Vector v= new Vector();
		 try{
			//Vector v1 = new Vector();
			//Vector v2 = new Vector();
			//System.out.println(""+u);
			//f.setInsert(sInsert);
			//f.setUpdate(updateData);
			//f.setDelete(sDelete);
			//if(v!=null){f.conClose();return;}
			v=f.setSelect(sSelect,2);
			System.out.println(""+v);
			//f.setUpdate(ss);
		 }
	     catch(Exception e){
				System.out.println("statment error");
		 }
		f.conClose();	
	}
  */

}