Java Code Examples for com.mysql.jdbc.Connection#close()

The following examples show how to use com.mysql.jdbc.Connection#close() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: DBUtils.java From StudentManagement with MIT License

5 votes

vote down

vote up

/**
    * 关闭数据库连接
    * @param conn Connection对象
    */
   public static void closeConnection(Connection conn) {
	//判断conn是否为空
   	if(conn != null){
   		try {
			conn.close();//关闭数据库连接
		} catch (SQLException e) {
			// TODO: handle exception
			e.printStackTrace();
		}
   	}
}

Example 2

Source File: FabricMySQLConnectionProxy.java From r-course with MIT License

5 votes

vote down

vote up

/**
 * Close this connection proxy which entails closing all
 * open connections to MySQL servers.
 */
public void close() throws SQLException {
    this.closed = true;
    for (Connection c : this.serverConnections.values()) {
        try {
            c.close();
        } catch (SQLException ex) {
        }
    }
}

Example 3

Source File: FabricMySQLConnectionProxy.java From Komondor with GNU General Public License v3.0

5 votes

vote down

vote up

/**
 * Close this connection proxy which entails closing all
 * open connections to MySQL servers.
 */
public void close() throws SQLException {
    this.closed = true;
    for (Connection c : this.serverConnections.values()) {
        try {
            c.close();
        } catch (SQLException ex) {
        }
    }
}

Example 4

Source File: MeetManagerDaoImpl.java From scada with MIT License

5 votes

vote down

vote up

@Override
public List<Room> getAllRoom() {
	Connection conn=null;
       try{
       	
       conn=getConnection();
  
       String sql="SELECT * FROM `scada`.`meet_room`;";
       
       PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);
       
       ResultSet rs=ps.executeQuery();
       
       List<Room> lr=new ArrayList<Room>();
            
       while(rs.next()){
       	Room r=new Room();
       	r.setMeetroom_id(rs.getInt(1));
       	r.setTime(rs.getString(2));       	
       	r.setUseful(rs.getString(3));      	
       	r.setNum(rs.getInt(4));      
       	lr.add(r);
       	r=null;
       }
       conn.close();  
       conn=null;
       return lr;
             
       }catch(Exception e)
       {
       	e.printStackTrace();
       }
       
	return null;
}

Example 5

Source File: MeetManagerDaoImpl.java From scada with MIT License

5 votes

vote down

vote up

@Override
public void updateAndDelete(int id) {
	
	ActionContext actionContext = ActionContext.getContext();
   	Map<String, Object> session = actionContext.getSession();
   	String select=(String) session.get("select");
   	String message=(String) session.get("message");

   	Connection conn=null;
   	
   	String sql=null;
   	
   	
   	if(!message.equals("")){
   	if(select.equals("id")){
   		try{
   		  			
       		conn=getConnection();
       		     	   
       		sql="UPDATE `scada`.`meet_room` SET `useful`='����' WHERE `meetroom_id`="+"'"+id+"'";

               PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);
   		        
       		ps.executeUpdate();
       		    
       	    //MeetManager meetManager=(MeetManager)this.getSessionFactory().openSession().get(MeetManager.class, id);
       		//this.getHibernateTemplate().delete(meetManager);
       		//this.getSessionFactory().openSession().close();
       		conn.close();
       		conn=null;
       		System.out.println(conn);
       		
   		}catch(Exception e){
   			System.out.println(e);		
   	     }
   	}
   		
   }
  }

Example 6

Source File: MeetManagerDaoImpl.java From scada with MIT License

5 votes

vote down

vote up

@Override
public String queryRoomUseful(String id) {
	String sql=null;
	Connection conn=null;
	String useful=null;
	
	try{
		conn=getConnection();
		sql="SELECT `useful` FROM scada.meet_room WHERE `meetroom_id`="+id;
           PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);
        
        ResultSet rs=ps.executeQuery();
        
        while(rs.next()){
        	useful=rs.getString("useful");
        }

        conn.close();
        conn=null;
        
        return useful;
	}catch(Exception e){
		
	}
	
	return useful;
}

Example 7

Source File: MeetManagerDaoImpl.java From scada with MIT License

5 votes

vote down

vote up

@Override
public String check(String id){
	Connection conn=null;
	String sql=null;
	String sql_1=null;
	try{
		conn=getConnection();
		
           sql="SELECT `meet_id` FROM scada.meet_manager WHERE meet_id="+id;
        
        PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);
        
        ResultSet rs=ps.executeQuery();
        
        while(rs.next()){
        	sql_1=rs.getString("meet_id");
        }
        
        conn.close();
        
        return sql_1;
        
	}catch(Exception e){
		e.printStackTrace();
	}
	
	return sql_1;
}

Example 8

Source File: AchievementDaoImpl.java From scada with MIT License

5 votes

vote down

vote up

public List<MyInformation> getAllinformation(){
	Connection conn=null;
       try{
       	
       conn=getConnection();
  
       String sql="SELECT * FROM `scada`.`information`";
       
       PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);
       
       ResultSet rs=ps.executeQuery();
       
       List<MyInformation> lr=new ArrayList<MyInformation>();
            
       while(rs.next()){
       	MyInformation r=new MyInformation();
       	r.setId(rs.getInt("id"));
       	r.setInformation(rs.getString("text"));       	
       	      
       	lr.add(r);
       	r=null;
       }
       conn.close();  
       conn=null;
       return lr;
             
       }catch(Exception e)
       {
       	e.printStackTrace();
       }
       
	return null;
}

Example 9

Source File: MeetManagerDaoImpl.java From scada with MIT License

4 votes

vote down

vote up

@Override
public void save() {
	
	Connection conn=null;
	try {  
		ActionContext actionContext = ActionContext.getContext();
    	Map<String, Object> session = actionContext.getSession();

    	String []file=new String[10];

    	/*****************************************************/
		file[0]=(String) session.get("meet_id");
		file[1]=(String) session.get("meet_name");
		file[2]=(String) session.get("meet_title");
		file[3]=(String) session.get("meet_content");
		file[4]=(String) session.get("people_num");		
		file[5]=(String) session.get("start_end");
		file[6]=(String) session.get("location");
		file[7]=(String) session.get("meetroom_num");			
		file[8]=(String) session.get("useful_time");
		file[9]=(String) session.get("room_size");
		int meet_id=Integer.valueOf(file[0]);
		int people_num=Integer.valueOf(file[4]);
		int meetroom_num=Integer.valueOf(file[7]);
		int room_size=Integer.valueOf(file[9]);
		/*****************************************************/

		conn=getConnection();

		String sql=
           "INSERT INTO `scada`.`meet_manager` (`meet_id`, `meet_name`, `meet_title`, `meet_content`, `people_num`, `start_end`, `location`, `meetroom_num`, `useful_time`, `room_size`) "
		+ "VALUES ("+"'"+meet_id+"', '"+file[1]+"', '"+file[2]+"', '"+file[3]+"', '"+people_num+"', '"+file[5]+"', '"+file[6]+"', '"+meetroom_num+"', '"+file[8]+"', '"+room_size+"');";
		PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);
		int row = ps.executeUpdate();  
           
           if(row > 0) 
                  System.out.println("�ɹ������" + row + "������"); 
           
		
		conn.close();
		conn=null;
		
	}catch(Exception e){
		e.printStackTrace();
	}
	
}

Example 10

Source File: FileManagerDaoImpl.java From scada with MIT License

4 votes

vote down

vote up

@Override
public void save() {
	
	try {  
		ActionContext actionContext = ActionContext.getContext();
    	Map<String, Object> session = actionContext.getSession();
    	int j = 1;

    	String []file=new String[20];
		file[0]=(String) session.get("sname");
		file[1]=(String) session.get("identity_card");
		file[2]=(String) session.get("sex");
		file[3]=(String) session.get("both");
		file[4]=(String) session.get("age");
		
		file[5]=(String) session.get("location");
		file[6]=(String) session.get("zip_code");
		file[7]=(String) session.get("nation");
		
		file[8]=(String) session.get("politics_status");
		file[9]=(String) session.get("school");
		file[10]=(String) session.get("education_background");
		file[11]=(String) session.get("major");
		
		
		file[12]=(String) session.get("job_title");
		file[13]=(String) session.get("job_title_date");
		file[14]=(String) session.get("qualification");
		file[15]=(String) session.get("telephone");
		file[16]=(String) session.get("mobilephone");
		file[17]=(String) session.get("urgent_phone");
		file[18]=(String) session.get("company_email");
		file[19]=(String) session.get("sole_email");
		int age=Integer.valueOf(file[4]);

           Class.forName("com.mysql.jdbc.Driver");  

           String url = "jdbc:mysql://localhost:3306/scada";  

           String username = "root";  

           String password = "root";  

           Connection conn = (Connection) DriverManager.getConnection(url , username , password); 
           if (conn != null)   
           	  
               System.out.println("���ݿ����ӳɹ�!");  

           else  

               System.out.println("���ݿ�����ʧ��!");  

           //��ɺ�ǵùر����ݿ�����      
       
           String sql_1="SELECT `sid` FROM `scada`.`file_manager`;";
           PreparedStatement ps_1 = (PreparedStatement) conn.prepareStatement(sql_1);
           ResultSet s_1=ps_1.executeQuery();
           int sid;
             while(s_1.next()){
                 sid =s_1.getInt(1);
                 System.out.println(sid);
		      if(sid==0)
                 {
		    	  System.out.println(sid);
                 }else
               	 j=sid+1;
               }

           /*String sql_2="SELECT `identity_card` FROM `big_project`.`file_manager` WHERE identity_card="+"'"+file[1]+"';";
           PreparedStatement ps_2 = (PreparedStatement) conn.prepareStatement(sql_2);
           ResultSet s_2=ps_2.executeQuery();
           System.out.println(6);
           if(s_2==null){
           	System.out.println(7);*/
           String sql=
           		"INSERT INTO `scada`.`file_manager` (`sid`, `sname`, `identity_card`, `sex`, `both`, `age`, `location`, `zip_code`, `nation`, `politics_status`, `school`, `education_background`, `major`, `job_title`, `job_title_date`, `qualification`, `telephone`, `mobilephone`, `urgent_phone`, `company_email`, `sole_email`) "
           		+ "VALUES ('"+j+"', "+"'"+file[0]+"', '"+file[1]+"', '"+file[2]+"', '"+file[3]+"', '"+age+"', '"+file[5]+"', '"+file[6]+"', '"+file[7]+"', '"+file[8]+"', '"+file[9]+"', '"+file[10]+"', '"+file[11]+"', '"+file[12]+"', '"+file[13]+"', '"+file[14]+"', '"+file[15]+"', '"+file[16]+"', '"+file[17]+"', '"+file[18]+"', '"+file[19]+"');";
           PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);
           
           int row = ps.executeUpdate();  
          
           if(row > 0) 
                  System.out.println("�ɹ������" + row + "������"); 
           //}else{
           conn.close();
           conn=null;
           //} 
	}catch(Exception e){
		System.out.println(e);
	}
}

Example 11

Source File: MeetManagerDaoImpl.java From scada with MIT License

3 votes

vote down

vote up

@Override
public void updateAndInput(int id){

   	Connection conn=null;
   	
   	String sql=null;
   
   	
   		try{
   				
       		conn=getConnection();
       	    
       		sql="UPDATE `scada`.`meet_room` SET `useful`='������' WHERE `meetroom_id`="+"'"+id+"'";

               PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);
   		        
       		ps.executeUpdate();
       		    
       	    //MeetManager meetManager=(MeetManager)this.getSessionFactory().openSession().get(MeetManager.class, id);
       		//this.getHibernateTemplate().delete(meetManager);
       		//this.getSessionFactory().openSession().close();
       		conn.close();
       		conn=null;
       		
       		
   		}catch(Exception e){
   			System.out.println(e);		
   	    }
   
}

Example 12

Source File: MeetManagerDaoImpl.java From scada with MIT License

3 votes

vote down

vote up

public String query(String id){
      
	String sql=null;
	String sql_2=null;
	Connection conn=null;
	
	try{
		
		conn=getConnection();
		
		sql="SELECT `meetroom_num` FROM scada.meet_manager WHERE meet_id="+id;
        
        PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);
        
        ResultSet rs=ps.executeQuery();
        
        while(rs.next()){
        	sql_2=rs.getString("meetroom_num");
        }
        
        conn.close();
        conn=null;
        
        return sql_2;
		
	}catch(Exception e){
		System.out.println(e);
	}
	return sql_2;

}

Example 13

Source File: AchievementDaoImpl.java From scada with MIT License

2 votes

vote down

vote up

@Override
public void save() {
	ActionContext actionContext = ActionContext.getContext();
   	Map<String, Object> session = actionContext.getSession();
   	String infor=(String) session.get("information");
 
	try{   	  	

       Class.forName("com.mysql.jdbc.Driver");  

       String url = "jdbc:mysql://localhost:3306/scada";  

       String username = "root";  

       String password = "root";  

       Connection conn = (Connection) DriverManager.getConnection(url , username , password); 
       
       if (conn != null)   
     	  
           System.out.println("���ݿ����ӳɹ�!");  

       else  

           System.out.println("���ݿ�����ʧ��!"); 
       
       String sql_1="SELECT `id` FROM `scada`.`information`;";
       PreparedStatement ps_1 = (PreparedStatement) conn.prepareStatement(sql_1);
       ResultSet s_1= ps_1.executeQuery();
       
       int id=0;
         while(s_1.next()){
             id =s_1.getInt("id");
           }
           int id_1=id+1;    

       String sql_2="INSERT INTO `scada`.`information` (`id`,`text`) VALUES ('"+id_1+"','"+infor+"')";
       
       
       PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql_2);
       
       int row = ps.executeUpdate(); 
       
       if(row > 0) 
           System.out.println("�ɹ������" + row + "������"); 

 
    	
       conn.close();
       conn=null;
	}catch(Exception e){
		e.printStackTrace();
	}
}